AnsweredAssumed Answered

Calculation for a file path resulting in container to display an image

Question asked by disabled_dbail22@comcast.net on Nov 13, 2010
Latest reply on Feb 22, 2011 by AdrieneSmith

Title

Calculation for a file path resulting in container to display an image

Post

Is there any calculation that can tell you if the resultant path in a calculaiton field that results in a container finds a file?  I have a database with over 20,000 records which has only 400 records with photos to display.  Using a calculation to a file path for a jpeg image works fine and displays the image when necessary.

My problem is I need to know if a calculation did result in an image for several reasons including filtering a portal to only show records with a relaed image.

No calculation I try such as length() getastext() shows any difference.  Is there a calculation that can determine if there will be or does display an image.  A scrip to loop through the images in a folder to load a file and test for an error was WAAAAY to slow and in a few years the recourds could total 50,000 with a few thousand photos.

Ideas??

Outcomes