Mar 01, 2022 03:05 AM
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.
Mar 01, 2022 07:40 AM
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.
As a side note, I think(?) there might be restrictions on your number of internal syncs.
I’m not exactly sure.
Mar 01, 2022 08:25 AM
The maximum for internal syncs is 10.
Mar 01, 2022 09:35 AM
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?
Mar 01, 2022 10:45 AM
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.