Skip to main content

Repeat Tables and Columns

Forum|alt.badge.img+3

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,

 

 

This topic has been closed for replies.

3 replies

ScottWorld
Forum|alt.badge.img+35

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.

    Forum|alt.badge.img+3

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

    Forum|alt.badge.img+3

    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