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!!