Where are the PDFs stored? Are they created in FileMaker elsewhere?
President/CEO Fresh City & Souper Salad
Direct/FaceTime/Text - 781.223.8884
The PDFs are stored in a folder on my Mac hard drive.
You didn't answer Pete's second question—how are the pdf's created? If you create them within your database somehow, then the process is easy. All you need to do is add a container field to the pay table where the data comes from and store the pdf in there (I do that all the time with quotes, invoices, letters, etc). Here is the calc I use to achieve this, which I posted a day or so ago with some further explanation here: https://fmdev.filemaker.com/message/146676#146676
mainpath = "/yourHD/(—the directory FMS uses, such as—Library/FileMaker Server/Data/Databases, or whatever you wish to use with FMP)/yourFolder/yourSubfolder(s)/" ;
name = <calc here based on record being exported> & " quote " ;
date = Month ( yourDatefield ) & "–" & Right ( Year ( yourDatefield ) ; 2 ) ;
extension = ".pdf" ;
thedoc = mainpath & name & date & extension ;
$filepath = "file:" & thedoc ;
$imagepath = "image:" & thedoc ] ;
$filepath & "¶" & $imagepath )
If the pdf's come from some external source you could still use this calc, but you would have to include a calc to gather the name of the pdf based on the employee name—whatever you can devise to achieve this. Then you could still insert it into a container field to facilitate emailing it to the employee.