AnsweredAssumed Answered

Hiding the status area but allowing users to perform simple multiple find/omit requests

Question asked by MartinBridges on Jul 26, 2013
Latest reply on Jul 26, 2013 by debi

Evening all,

In find mode you can use the status area to select whether the find request will find or omit records. It's a simple little check-box.

I have a solution where the status area is hidden. I have a list view of addresses. I've written the following script to replicate that litle check box.


When they enter Find Mode I take them through to a duplicate list view layout where at the end of every row/record there is an extra field called TABLE::Omit. It's a checkbox field with the value 1.


When they hit return my script runs...



// This loop tells FileMaker to 'omit' the request in it's find routine. It leaves all others as 'include'

Go to Record/Request/Page [First]


If [TABLE::Omit = 1]

Omit Record

End If

Go to Record/Request/Page [Next; Exit after last]

End Loop


// This then clears the Omit field before the find routine

Set Field [TABLE::Omit; ""]

Replace Field Contents[]


Perform Find []



Any suggestions of turning this into a global script so that I don't have to roll out multiple versions changing the reference to TABLE::Omit/