AnsweredAssumed Answered

Opening PDFs with Unknown Names

Question asked by jda76 on Apr 9, 2013
Latest reply on Apr 9, 2013 by Mike_Mitchell

Hi there,

Here's what I'm trying to do:

 

We have jobs that receive multiple invoices which are scanned and named by a third party and all PDFs for all jobs are stored in the same folder. The PDFs are named JobNumber_VendorType_VendorInvoiceNumber.pdf. ex. 3898475_trucking_6456.pdf

 

In FileMaker, I would like to create the button "View All Invoices for This Job" or "View All Trucking Invoices for This Job" on the job records. This script would ideally trigger all the PDFs that begin with the job number (3898475 in the example above) to open.

 

The vendor invoice numbers would never be entered into FileMaker, so the last section of the filename would be unknown. Is this possible?

 

Any ideas would be greatly appreciated!!

 

Thanks!

Outcomes