This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve seen a few posts about duplicating records and their linked records with scripting, but none showing an example. Does anyone have some example code that will duplicate a records and it’s linked records, and update the association of the linked r...
Here’s what works for filtering down the queries from the 4 different table:
// THIS APP WILL CREATE A DUPLICATE OF A RECORDS AND IT'S CHILDREN
let jobtbl = base.getTable("JOBS"); //parent table
let witbl = base.getTable("WORK ITEMS"); //child table1...
This successfully filtered the query down to a list of items only linked to the job. This works in my case because have an ID field (key) in my child tables that use the use the linked job number as a prefix. The right way to do this would probably b...
Found this post that might be key to get past the filter issue:
Completely stuck on filtering through and array Scripting app
Hey @Kim_Trager1:
The return type of a linked record field is an array of linked record objects,...
I’ve been using Airtable heavily for about 2.5 year and have go about as far as I can with it’s core web interface. So, I’m starting to get into the scripting app. I’ve done programming in VBA for excel, solidworks, and autocad, but Javascript is new...
