Capturing the "File cannot be found" within a calculation

Discussion created by PeterWindle on Jul 10, 2012
Latest reply on Jul 10, 2012 by erolst

Hello all,


We're all familiar with container fields that have a reference to an image/file, when the file is removed/moved, you get the message in the container field indicating that the file cannot be found.


This is great, except that I would like to display the image in calculation field and display a generic default icon if the image cannot be found.


The question is, what do I use to trap the "Image cannot be found" condition?


I have tried a number of things so far, but nothing I have tried seems to work...?!!


I have tried VerifyContainer, isvalid, patterncount(field,"The file connot be found)



This is using FileMaker 12...


Am I simply barking up the wrong tree...?

Any suggestions?