1 Reply Latest reply on Jul 26, 2013 12:39 PM by debi

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

    MartinBridges

      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]

      Loop

      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/

       

      regards

      Martin