Im trying to get CR X to search through a field in a table and tell me if a certain filename is there. I wrote a formula to do it and it works, except that it displays the results of each file in the field and creates just as many reports. So if there are 5 files in "filenames" it will create a seperate report for each one with the correct results. I need 1 report with 1 result, but I have to search through all of the items and Im unsure on how to do this. I was thinking of using an array but Im unsure of how to populate it using {Attachments.filename}. I don't know how to cycle through them. Does anyone have any suggestions on how to have it search all items in the field and return only one result? Any suggestions would be appreciated!

Thanks for the reply and sorry for the confusion.

 

I’m currently using a formula to find an occurrence of a search value in a given record.

 

When I run the formula, it creates a separate details section for each instance.

 

When I find the search value, I want it to give me a True, if not, a False.

As of now, it is doing just that, but with a detail section for each instance.

 

Is it possible to search all {Attachments.FileName} instances and return one result in one detail section?

 

This is the formula I’m using now.

 

if {Attachments.FileName}[1 to 3] = "ROP" then TRUE

else False