Calculation for a file path resulting in container to display an image
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.