I have a container field into which a PDF can be uploaded (by a user-activated script). I want to also have a date field which shows the creation date of the PDF.
I do this with a FMP script that uploads the PDF and also does the following:
1. Paste the clipboard to a throwaway field in the DB
2. Call an Applescript to get the creation date of the PDF and copy it to the clipboard
3. Paste from the clipboard into the date field
4. Copy the original clipboard contents back to the clipboard from the throwaway field
It works, but it's awfully ugly, since it uses Applescript and passes data via the clipboard. Does anyone have a better way (without resorting to plugins)? Before you say it: Getcontainerattribute() can only return a creation date for a photo, so that doesn't work here, even if I use Insert Image to upload the PDF.