Help

Formulas in a field type Formula not tranfering when I sync them to another Table

Solved
Jump to Solution
802 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nosberto
4 - Data Explorer
4 - Data Explorer

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,

1 Solution

Accepted Solutions
Blake_D
6 - Interface Innovator
6 - Interface Innovator

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.

See Solution in Thread

2 Replies 2
Blake_D
6 - Interface Innovator
6 - Interface Innovator

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.

Thank you Blake! 👍

I did not consider duplicating the entire base*  per Projet.  This solution works for me.