Help

Sync multiple table to 1 table

Topic Labels: Sync
1474 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Tjahjadi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hai everyone how to sync multi table to 1 table?
because I have 8 table in 1 base and then want to create 1 table summary using value from those 8 tables.

image

4 Replies 4

Hey @Lucas_Tjahjadi!

Yes, you can sync multiple tables into one table.

If you create a synced table, you can choose to add a new sync source.
Refer to my screenshot below.

image

As a side note, I think(?) there might be restrictions on your number of internal syncs.
I’m not exactly sure.

The maximum for internal syncs is 10.

Have you considered why you need 8 separate tables to begin with? Would you benefit from just using one table and 8 (or more) filtered views?

augmented
10 - Mercury
10 - Mercury

If you are truly doing a summarization, you could create a common field in each of the 8 tables that corresponds to the unit of aggregation that you want to use (like day, month, year, etc). This field will be a link field to another table (Let’s call it “Summary”), used for compiling summary stats. Fields in this table will the linked fields to all the other tables plus rollups. The downside is that it is one more field to enter in every table, but you could likely automate it. The upside is that you don’t needlessly use up your record allowance.