I have an Employee Table, and a Documents Table.I need to be able to upload 1 document, and have it automatically display on each employee's "page" I have two tabs.Employee Information - Essential DocumentsI want to be able to upload a document and it automatically go under each employee's "essential documents" tab.SOS!------------------------------Newman, Savi------------------------------

Well, in fact I always wear my cape when I'm Quickbasing. ------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sounds like you just need a table-to-table relationship between your employee table and your documents table. Then you can use a report link field to display a report of documents related to that employee.------------------------------Jeff Peterson------------------------------

Yes, but I have to upload the same document over and over under different related employee names for it to show.I want to upload one document, one time, and have it appear under each employee account.------------------------------Newman, Savi------------------------------

Are you saying that some documents are employee specific, and others are global to all employees? Or are ALL documents global for all employees?------------------------------Mike Tamoush------------------------------

@Lynne,Make a formula Rich Text field like this on the Employee Record.var text Words = "Click here for xxx Document";var text URL = URLRoot() & "up/" & [_DBID_Documents] & "/a/r" & "123" & "/e99/v0";"<a href=" & $URL & ">" & $Words & "</a>"Change the 123 to be the Record ID# of the document Record.Change the 99 to the field ID# of the field that holds the document.Change [_DBID_Documents] to be the table alias of the docs table that you find under advanced settings for that table.You should see a link and when clicked it will open the document or download the document according to how the user's computer is set to treat that file type. ------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Obviously Theres A Way, But How?!

11 Replies

JeffPeterson1
Qrew Captain
3 years ago
Sounds like you just need a table-to-table relationship between your employee table and your documents table. Then you can use a report link field to display a report of documents related to that employee.

------------------------------
Jeff Peterson
------------------------------
- SaviNewman1
  Qrew Trainee
  3 years ago
  Yes, but I have to upload the same document over and over under different related employee names for it to show.
  I want to upload one document, one time, and have it appear under each employee account.
  
  ------------------------------
  Newman, Savi
  ------------------------------
  - MikeTamoush
    Qrew Commander
    3 years ago
    Are you saying that some documents are employee specific, and others are global to all employees? Or are ALL documents global for all employees?
    
    ------------------------------
    Mike Tamoush
    ------------------------------
AdamKeever1
Qrew Commander
3 years ago
You can combine your initial process with Mark's suggestion. So you have a table of essential documents:

And that table home page has a URL:
https://[YOUR_REALM_NAME].quickbase.com/db/[YOUR_TABLE_ID]?a=td

Copy the table home page URL and put it in the formula field that Mark described or you could simply use a formula URL field:

Place the button wherever makes the most sense on a form or table:

When they click the button, they have access to all of the essential documents.

------------------------------
Adam Keever
------------------------------

Forum Discussion

Obviously Theres A Way, But How?!