Hello -- I would like to open pdf files that are stored in a secure external manner.
Only the first page of multipage files show in a FM container window (if I';m not mistaken) so I am wondering about using Preview (Mac, of course). I can retrieve the file path to the secure file by processing the text output of the container file, and then use it as a variable filename in a Send Event script step, but Preview cannot open it.
By Scotty Nordlund
After upgrading to MirrorSync 3 from 2, I can no longer sync container fields. During the reconfiguration process, I get the tooltip in the uploaded image below. The tooltip says "Neither field is writable. This could be because they are calculation or summary fields. It could also be caused by field-level validation or custom access privileges.". These container fields are not calc or summary fields. There is no field level validation or custom access privileges that I know if. They are full access, and the fields have not changed since my last MirrorSync 2 configuration. Please help!
I'm using Filemaker Pro 11 in Windows 7, trying to automate the exporting of files from container fields. I've written a script that goes through all the records to export the files in the container fields while skipping empty container fields. The code works well, except that there are a number of records with container fields where I get the "Container fields cannot be exported." error. When I try go to these records and try manually exporting the container field contents by right clicking, the "Export Field Contents..." option is grayed out, though I am able to open the document and then manually save it. There are, however, way too many of these cases for me to practically do this one by one, so I'm hoping if someone has an idea what's going on here and how I might be able to automate the exporting of these fields that are giving me this error.
To help me troubleshoot this, I wrote a shorter code that focused on exporting the field contents of just one record. This helped me figure out which records were giving me this error. Here's the code:
Set Variable [$filePath; Value:"filewin:" & Get(DocumentsPath) & TABLENAME_::TABLE_ID_FIELD]
Export Field Contents [TABLENAME_::FIELDNAME; "$filePath"]
I've been searching and trying a bunch of different things, but with no luck. Any tips and pointers would be greatly appreciated.
By Miss A!
Anybody with a solution or understanding as to why FM crashing when browsing records on layouts that have container fields?
By Steve Martino
I had a few questions regarding inserting, then retrieving a PDFÂ from a container field.Â Scripts attached.
What I have is a table forÂ Customers related to a table Customer_contact.Â In the Customers Table I have a layout/procedure to write letters to customers, either individually, or in bulk.Â Then print. What I would then like to do is have the option (in the Customer_contact table) to either just put a record of the contact (date, which letter sent) or save a copy of the entire letter in a container field as a PDF.Â The reason for the 2 options are I only really want to save the letters that are related to unpaid invoices, not the bulk letters, newsletters, etc.
So I came up with these 2 scripts to save and retrieve.Â It does work, butÂ I read up on saving to a temporary path to embed the pdf into the container field, butÂ I amÂ confused by the method.Â So when my script runs, it does what I need it to do, butÂ leaves an untitled.pdf file on my desktop (which I don't like, but I did script it that way).Â It does work but I always wonder if it is correct, and if there is a better way.Â I do want to embed the pdf's into the container, not store remotely
My questions are:
1.Â Is the first script correct (the steps with the arrows specifically, but overall too)
2.Â Is the second script correct for retrieval?Â Obviously if I have to change the first script, the second will need updating.
Any help, opinions, ridicule, pointers, are always appreciated.
PS.Â I'll always be the only user, so record locking with the loop script wont hurt me, but if an alternate method is better, I'm always interested in learning