AnsweredAssumed Answered

Omitting records from view

Question asked by AndrewL on Aug 14, 2012
Latest reply on Aug 15, 2012 by AndrewL


Omitting records from view


Hello there,

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!