Jump to content

Scripting a Find Function


This topic is 6995 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

This topic is 6995 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.