Jul 30, 2024 09:25 AM - edited Jul 30, 2024 09:26 AM
I've created on a base a table template with several formulas that I'd like to duplicated for the various projets that I managed but when I try to copy / sync the table to another base, all my formulas are not transfered and the columns with the Formula Field Type are changed to a Number Field type.
Is there an automatic way to copy the formulas or do I have to manually copy/paste them on each new base ?
I've left some some images for reference, as you can see the field type is completely different and dont include my formulas.
Thanks,
Solved! Go to Solution.
Jul 30, 2024 10:00 AM
When you copy tables to another base the formula fields do not stay intact and do change as you have experienced. There are a few ways to do what you are asking and that is the manual copy and paste, use Airtable's API with some scripting to automate copying the formulas, an Airtable app or third-party app, or create a template base with all your desired tables and formulas. When you start a new project, duplicate the entire base instead of copying individual tables. This way, all tables and their formulas are preserved.
I hope this helps and if you have any questions feel free to ask.
Jul 30, 2024 10:00 AM
When you copy tables to another base the formula fields do not stay intact and do change as you have experienced. There are a few ways to do what you are asking and that is the manual copy and paste, use Airtable's API with some scripting to automate copying the formulas, an Airtable app or third-party app, or create a template base with all your desired tables and formulas. When you start a new project, duplicate the entire base instead of copying individual tables. This way, all tables and their formulas are preserved.
I hope this helps and if you have any questions feel free to ask.
Jul 31, 2024 07:18 AM
Thank you Blake! 👍
I did not consider duplicating the entire base* per Projet. This solution works for me.