Forum Discussion

HALEYHALEY's avatar
HALEYHALEY
Qrew Trainee
7 years ago

Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?

Hello, I am working with a document library. There are 20 tables, and different users have permission to access different tables. All records have file attachments. I would like to set up a c...
Ask about Quickbase functionality
File attachments
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The formula URL to display a clickable link to a file attchment in another table is like this

URLRoot() & "up/" & [_DBID_PROJECTS] & "/a/r" & [Related project] & "/e30/v0"

Replace e30 with e and fid of the field holding the file attachment. The v0 just says to always show the most recent version if the attached file.

.