Searching for empty container field
I have a contaner field for photos. How do I search for records in which that container fied is empty? Thanks
In a script or in a manual search?
Either way, you can do this by entering search criteria in a calculation field that references the container field. If the container field is empty, this calculation field will also be empty so entering a = into it and performing the find will find those records where the container field is empty.
OK. What does the calc look like? The calc field has to appear in the layout? Thanks.
If(IsEmpty(containerfield), 1, 0) would set the calc field to a one or zero. Test to make sure.
You can use gettext(containerfield) to get the pathnames, filenames etc.
It is also possible to get the source code of websites and much more.
That works, but you don't actually need the getastext function. You can simply specify text as the return type and put the name of the container field as your sole term and you get the same results.
It works great- thanks!
Retrieving data ...