Airtable API: Duplicate Record

TroyTessalone · ‎Oct 27, 2021

Airtable Standard API Add endpoint to duplicate a Record, same as can be done via the UI. Settings Record ID Fields to include (ALL, NONE, Specify Subset) Example This can be used to clone a template Record.

Alla_Pob · ‎Feb 09, 2017

I have 2 tables, and I need a result that shows only inputs that are the same in both tables. Hence, to compute the intersection of a number of arrays. array intersect ( array1, array2 [, array#… ] ) Returns an array containing all the values of array1 that are present in all the arguments. Where: array1 The array with master values to check. array2 An array to compare values against. … A variable list of arrays to compare. Any workarounds at this point?

JonathanB · ‎Jun 13, 2022

I have a lot of bases now that have a large number of tables, but in some cases some of these tables are synced tables that just provide “background” data that is processed in other native tables. It would be useful to have the ability to “group” these synced tables together into a menu that could be toggled (or even locked) leaving just the ones where processing actually takes place visible across the top. Similar to how you can now group views in the sidebar.

Ali_Aboutera · ‎Jan 06, 2018

I think some tables requires that the new records are on the 1st row not the last, I know there are sorting options that could do that but I would like to see that as an option (top to bottom or bottom to top)

Simon_Lammers · ‎Mar 08, 2018

I’d like to secondary click on any value and find an option called “add to filter” which filters the records matching this added value to the filter. Would be much quicker than typing it manually in the filter.

AlliAlosa · ‎Sep 05, 2018

Are there any plans in the works to allow integration with Blocks using apps like Zapier? There are hundreds of uses for this I’m sure. In particular, I would love to be able to save a pdf from the page designer block and add it to a record based on the trigger of that record being added to a particular view.

Michael_Lever · ‎May 03, 2021

I am using AT for my law library. Recently, after having manually entered details of >4000 cases, I was very tired, I still am - puppyitis - and accidentally deleted a field. Wonderful. I checked the snapshot only to find the latest I’d taken predated numerous entries and the latest AT had done also predated many entries with no way of my knowing which and what. I have added a new field and started entering the information again. When I told someone what I’d done they were surprised that I hadn’t backed up. I can’t. I said, i am using a cloud-based app which doesn’t allow back-ups whenever I like. The manual snapshot interval is very long. In the app (non-cloud0 I’ve been using for my law library I can save whenever I like which i do as I go. My question is this - and if not a question then a suggestion. Is is possible to lock a field so that if an attempt is made to delete it a warning comes up “do you want to delete”?

Noel_Howell · ‎May 02, 2017

Anyone know the formula reference to pull the name/info of the person who submitted a form on the record? Thanks! –Noel

Adam_Workman · ‎Apr 02, 2018

I could be wrong but whenever I print a record (using the built in print record feature), it does not appear automatically add the current date to the header or footer and also lacks page numbers. The print record feature based on view is incredibly helpful and does not require the manual creation of a print layout using the new blocks feature (which seems great but also labor intensive to start). Having said that, our records are updated regularly and it would be nice to be able to reference printed records and to determine what date they were printed - as well as page numbers for when they go on multiple pages? - This would just be a great version management tool. Thoughts?

Henry_Ferguson · ‎Feb 10, 2019

Just a heads up for anyone who hasn’t noticed this non-intuitive behavior. For Numbers and Currency Field types the “precision” selection can affect the values, not just the formatting. It looks to me like Airtable is inconsistent here though, so results can get pretty funky. For example, create a column that is a Number or Currency and set the precision to 1.00 or $1.00. Type the value 0.49 in the first row and replicate it 9 more times for a total of 10 rows. The sum shown at the bottom of the column will be 4.90, which is correct. The value displayed in each row is 0.49. The non-intuitive behavior comes when you change the precision. Change the precision to $1 instead of $1.00. Each row now shows $0, which makes sense given the rounding. The total at the bottom is now $5, which doesn’t make much sense given all the numbers are 0. Also doesn’t make much sense given the actual values are $0.49 and the actual total is $4.90. Now change the precision back to $1.00. All the rows are now $0.00 and the total is $0.00. (I guess Airtable gets to pocket the $4.90?). I can imagine this behavior causing serious headaches. Imagine I’m keeping a budget, and I want to see the values to the dollar sometimes, and to the cent other times. If I change the precision, I absolutely do not want it to be changing the values. But there seems to be no way to prevent this.

Airtable API: Duplicate Record

Array intersect formula

Toggle/group tables

Option to add row from top not from bottom

Add value to filter to filter records

Block Integrations

Field lock - to avoid delete

Name of the person who submitted the form?

Print Record: Add 'current date' and 'page numbers'?

Non-intuitive behavior of number or currency precision

Format Formula as Checkbox

CSV Import in Interfaces

React to Record Comments

Allow Emoji reactions to comments

Multiplying by percent column yields result that i...