Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Repeat Tables and Columns

966 3
cancel
Showing results for 
Search instead for 
Did you mean: 
brightvessel
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

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

brightvessel_0-1706353700792.png

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

brightvessel_1-1706353735612.png

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.

brightvessel_2-1706353825678.png

brightvessel_3-1706353838601.png

Thanks,

 

 

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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.