JGP

Yep i tried to test the length but it returned "0". If i convert the "calculation/reference field with result container" to a "Container field with a calculation" it returns a length result but doesn't link to my referenced files on the fly. I'm not all that familiar with AppleScript but will give Fentons idea a go. But will keep checking back if anyone else has any creative ideas. JP

It returns my calculation "image:Previews/" & JobNumberMonthYear & ".pdf" & ¶ & "image:Previews/" & JobNumberMonthYear & ".jpg" whether the PREVIEW field has a linked image or not.

I've got a calculation field (result container) to present a preview of an image file. Field name PREVIEW. Script = "image:Previews/" & JobNumberMonthYear & ".pdf" & ¶ & "image:Previews/" & JobNumberMonthYear & ".jpg" This all works fine. I wanted to create another calculation field (called EMPTY) to let me know if the PREVIEW field is empty (in other words there was no file for the PREVIEW calculation to link to) so that i could do a find based on this result and then create these image files. At the moment, when there is no image showing in PREVIEW it shows the text "The file cannot be found:1115-08". I have tried a lot of calculations without much joy and can't find any similar problems on any forums. Appreciate any suggestions.

Thanks guys for your feedback. I ran with Stuarts Exit script in the perform script dialog. (after one turn at having the never ending loop. backed up first though). Worked a treat. Stuart do you see any problem with this style of script in a solution for a client either in FM or runtime? Once again thanks for your earlier help.

I hoping i've got the right area to post this query. I'm trying to get it that when my solution opens a new window from a button click that the new window in front is the only one selectable and if you click on the back window it stays in the back until you have clicked a close/commit button on the front layout. I've had rough success with this through the pause script step in the button script that creates the new window, but doing it this way needs the operator to click the cancel/continue button in the status area. My solution doesn't use the status area in any of the layouts so i was hoping there is a script step that i'm not seeing that may achieve my goal. Any help would be appreciated. Thanks in adavnce JP

The simple things in life are often the best. Comment, that worked a treat. Thanks for the help.

I've been using FM for few years but new to forums. So here we go! I've got a container field in which i want reference to an image in the folder "Previews" (Same level as my FM solution). I can get this to work with this calculation "image:Previews/" & JobNumberMonth & ".pdf" In FM the field "JobNumberMonth" contains 4 digits "0206" relating to job number 6 of the 2nd month. In my "Previews" folder i have screenshots that are named "0206.pdf" etc that link to my FM solution. What i want to do is be able to have files of different types in the "Previews" folder (.jpg .png etc) I have tried taking the file extension off the reference file and out of the calculation. This does work (places the image in the container) but appears to run slower when scrolling through the records. Also when you drag the image out of the container field to the desktop you can double click on the resulting "Picture clipping.pictClipping" file and it will open an image of equal size to the original. When you remove the file extension from the process this results in the "Picture clipping.pictClipping" file being blank on opening. I have been trying to create a calculation based on something like If .pdf not available use .png. If png not available use .jpg else "" This is my challenge should you choose to accept. TIA