3 Replies Latest reply on May 4, 2014 4:48 PM by keywords

    PDF Relationship by the PDF Title


      I have 20 employees and I want to email each persons PDF paystub that was deposited in their bank account. Each PDF paystub is titled with the persons name.


      Question: Is it possible to create a database that will automatically import or reference each employees paystub and have the relationship based on the PDF title so I don't have to import each PDF, assigning it to each employees record?


      Any ideas would be appreciated!

        • 1. Re: PDF Relationship by the PDF Title

          Where are the PDFs stored? Are they created in FileMaker elsewhere?




          Pete Minich

          President/CEO Fresh City & Souper Salad



          Direct/FaceTime/Text  - 781.223.8884

          • 2. Re: PDF Relationship by the PDF Title

            The PDFs are stored in a folder on my Mac hard drive.

            • 3. Re: PDF Relationship by the PDF Title

              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


              Let( [


              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.