Repeat Tables and Columns

[brightvessel]

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,

[ScottWorld]

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.

[brightvessel]

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).

[brightvessel]

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.