Find - If this field has data, ignore these fields

[harry8]

Actually there are two postal address field areas. If the alternative address fields are used, I want the Find to ignore the regular fields -- to exclude that data when I export -- can I do that?

I am doing a find on some records. On an 'add new request' I want to have the 'find' determine if a certain field is populated. If it is I want to have the find ignore the fields that I do not want. How do I mark 'ignore' on the fields (or something similar)?

Harry

[falkaholic]

Make a calculation field like this:

addressExport = case (address1 <> "", address1,address2 <> "" address2, "no address" )

then use the calc field in your exports and finds instead of the original fields.

[jasonwood]

So if a user specifies a particular criteria, then you want any other criteria they may have entered to be ignored?

Simply script the find something like this.

Enter find mode

Pause

(user enters find info, then hits "enter" or a button which resumes the current script)

If yourField != "" then set every other field to ""

Perform find

You can see that the second last step would involve some labour especially if there are a lot of fields. Alternatively, in place of this step you could copy the content of yourField, enter find mode again (I assume this clears the find requests?), then paste back into yourField, and perform the find.

I used copy/paste for simplicity. It'd probably be better to use a global field so as not to disrupt the user's clipboard.

[jasonwood]

I think I misunderstood your question now that I've seen Erik's answer... woops.