Skip to main content

Hi all,

I am wondering if there is an easier way to create similar tables.

So, each column is the same and works the same.

I can duplicate the table, but what I am looking for is more like a template.

I have to do 106 tables, and it just seems like I am doing it the wrong way.

They are budgets that get pulled into an interface.

Thanks,

 

 

What you want to do is just create ONE table, and then create FILTERED VIEWS to show you just the records you want to see on each view.

I discuss views in depth in my free Airtable training course, which you can take for free by signing up for a free trial membership with LinkedIn Learning: Learning Airtable.

Similar solution with the interfaces… you can create just one interface page that you filter to show you what you’d like to see.

What you want to do is just create ONE table, and then create FILTERED VIEWS to show you just the records you want to see on each view.

I discuss views in depth in my free Airtable training course, which you can take for free by signing up for a free trial membership with LinkedIn Learning: Learning Airtable.

Similar solution with the interfaces… you can create just one interface page that you filter to show you what you’d like to see.


Let me explain a little more.

School A Table has Columns which has another column with a roll up.

I want to duplicate this with a script for School B, which has no relation.

I would imagine there is some script that would duplicate everything and rename columns. (School A) to (School B).

Let me explain a little more.

School A Table has Columns which has another column with a roll up.

I want to duplicate this with a script for School B, which has no relation.

I would imagine there is some script that would duplicate everything and rename columns. (School A) to (School B).


Some clarification. School A has a main table with data, an additional table with linked fields, and a rollup, in which Google ads feed data to the main table. Maybe I am too ambitious, but I wanted to load everything again for a second school, so I just had to feed in the data. When I duplicate, I have to connect the fields and roll-ups again.

Terms & ConditionsAccessibility statement