For the accounting module I have a field that links to the PDF of the vendor invoice.
This allow accounting staff to store PDF on their fileserver which filemaker can find because I have the complete path.
FileMaker know the Vendor Name, the Year, and the PO number. It can then build the path to the file.
Acting File Server / Vendors / Acme Inc / 2018 / PO_15482.pdf.
Works great and they love it.
But now they want something similar for the creative dept to link to QT movies.
The issue is that, unlike accountants, Creative Staff are detailed oriented. They will never build the proper folder hiracery to build a valid path.
So now for the question:
If FileMaker has the exact File Name and the path to the server, can I write a script to do a FIND for that file?