Help

Scripting: Duplicate Table

Topic Labels: Scripting extentions
675 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jon_Smith2
4 - Data Explorer
4 - Data Explorer

Hi all, New to Airtable scripting. Wanted to see if what I’m trying to accomplish is possible before digging in.

Is it possible to duplicate a “master table” and rename it? Or create a new table and copy the values from another table?

Thanks in advance!

1 Reply 1

The answer is a tentative “Yes it is possible”, though likely not advised since that would mean having two tables with identical data structures, a set up not often ideal for relational databases.

You would first need to do base.createTableAsync and include all the fields you need created. Note: not all field types can be created via script (none of the calculated fields). Then you would batch create the same number of records that existed in the first table using the original field values. Certain field types like attachments would be more difficult to migrate, but not impossible.