Omitting records from view
Sorry, this is probably dead easy to anyone else here, but I cannot for the life of me figure out how to do it. Can you help?
Here's the thing: I have a database with a script that shows all records in a particular layout, sorts them, then pauses, then returns to original layout
Print Setup [Restore; No dialog]
Go to Layout ["Inventory List"]
Perform Script ["Sort by Location"]
Enter Preview Mode [Pause]
Go to Layout [original layout]
Show All Records
Enter Browse Mode
Simple enough. Now, the database contains a field named "Damaged" - a checkbox. What I would like to achieve is this, I'd like all items that have a "checked" value in this field to be excluded from above view.
I guess I need to perform a find function first in order to filter out the relevant records, but I am not exactly sure how. I tried a few things but no good, so far. Can anyone please tell me how to include this in the script above?
Thanks ever so much for your help!