Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
A sync table can only have 1 source. But you could have 20 Actions on 20 tables to create a record in the centralized table. The centralized table can have a formula to link back to the original document such that wen clicked, it will display the file attachment even though the file attachment is not actually on the centralized table.
QuickBaseCoachD
7 years agoQrew Captain
The centralized table could have a relationship back to each of the 20 source tables. So 20 relationships. Then it could self detect if the Parent was deleted and either be hidden from reports or deleted by an Action or automation.
That could also be useful to use a lookup for any Text fields on the source records, that way you would not need to deal with edits by Actions as they would just be lookup fields.
That could also be useful to use a lookup for any Text fields on the source records, that way you would not need to deal with edits by Actions as they would just be lookup fields.