Scripting a Find Function

[bb84604]

I am a fairly new user. I know this is a simple question, but I'm looking for an easy way to omit certain records from a layout view. I have a field called "Status" and in one layout I want to be able to automatically omit records that Status="Cancelled" or "Closed". I know I can manually do this using Find, but I'm sure there is an easy way to script this?

Thanks in advance for any help.

[-Queue-]

You could create a calculation number field of not (Status = "canceled" or Status = "closed"). Then create a relationship from a calculated number field equal to 1 to this status calculation field. When you want to show all records that are not canceled or closed, use Go to Related Record [show only related, newcalcrelationship].

If you have a particular found set (not all records showing) and only want to omit canceled and closed,

Freeze Window

Go to Record/Request/Page [First]

Loop

If [statuscalcfield]

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

Else

Omit Record

End If

End Loop If [not Status(CurrentFoundCount)]

End Loop

Go to Record/Request/Page [First]

[bb84604]

Thanks so much.