If interactive content was not specified, then a different menu option than Insert PDF was used to insert the PDF file. You should be able to use ecport field contents to export the file, then re-insert it with the Insert PDF option to get the interactive features that you are missing. IF you can pull up just these records in a found set, a script could be used to put in the fix.
The PDF files were drug into the field using drag and drop. Insert PDF was not explicitly used.
Which is the functional equivalent of Insert File, not Insert PDF. You've done this for all the files, both before and after the layout change?
I'm surprised that worked.
Re-inserting the files still represents your best bet for fixing this, I think. You might add a button for this next to the container field and click it each time you see a case where you can't see the contents in the container field.
Dragging and dropping the files were used for 99.99% of all of the file insertion before and after the layout change.
Are you referring to a button that would execute a script to export and then re-import? Do you have a pseudo-script that I could work off of for addressing this issue?
Go To Record/Request/Page [First]
Set Variable [$FileName ; value:
Let ( [T = GetAsText ( GetValue ( YourTable::containerField ; ValueCount ( ContainerTest::containerField ) ) ) ;
L = Length ( T )];
Right ( T ; L - Position ( T ; "/" ; L ; -1 ) )
Set Variable [$Path ; Value: Get ( TemporaryPath ) & $FileName ]
Export Field Contents [ YourTable::ContainerField ; "$Path"]
Go To Field [YourTable::ContainerField]
Insert PDF [$Path]
Go to Record/Request/Page [Next ; exit after last ]
Note: Text in Blue is the entire calculation for the set variable step for $FileName. It should extract the file name from the container field regardless of the method used to insert the file and whether or not "store a reference" was specified.
Going out on a limb, I tried to create a second column (Document2) and Replaced the Field Contents of the column Document2 with Document1. All of a sudden the Document1 column was working correctly for the affected records.
Looking through the script options I came across the "Insert File" script command with the following special dialog options:
"For images and interactive content, you can display either the file icon or the file content. Some files can only be displayed as icons.
Display: Icon with filename
Content of file (when possible)"
My guess would be that this flag could be toggled on a columnuar level to prevent this from happening in the future.
Thank you both.
PhilModJunk's script is great; however, I recieved an error without first adding an additional variable to append "image:" onto the file path. I am attaching a screenshot below of the reworked script.TSFalconFileMaker, Inc.
Thanks for the "catch". As an added note, be very careful with the image, imagemac, imagewin and file tags. Don't know if this is still true with FMP 12, but in 11, they are case sensitive tags and the wrong captital letter can produce and invalid file path.