Forum Discussion

SaviNewman1's avatar
SaviNewman1
Qrew Trainee
4 years ago

Obviously Theres A Way, But How?!

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 - Essen...
Tables and fields
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 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's avatar
SaviNewman1
Qrew Trainee
4 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's avatar
    MikeTamoush
    Qrew Commander
    4 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      @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
      ------------------------------
      • SaviNewman1's avatar
        SaviNewman1
        Qrew Trainee
        4 years ago
        Not all heroes wear capes. Thank you so much!

        ------------------------------
        Newman, Savi
        ------------------------------