Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Sync multiple table to 1 table

Topic Labels: Sync
287 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

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.