Forum Discussion
JeffPeterson1
3 years agoQrew Captain
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
------------------------------
------------------------------
Jeff Peterson
------------------------------
- SaviNewman13 years agoQrew TraineeYes, 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
------------------------------- MikeTamoush3 years agoQrew CommanderAre 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__You3 years agoQrew Legend@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
------------------------------