Forum Discussion

HALEYHALEY's avatar
HALEYHALEY
Qrew Trainee
8 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
8 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.
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
>That is a showstopper.

Hardly.

>Do you know of a way to go around this?

With script you could just create 20 hidden <iframe>s with the individual file content search results and then just scrape out the results and display the final result in a tabular format on the host page. The net result would appear as a single report on the host page spanning all 20 tables of documents.