Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

good day!

i'm trying to get a script to omit records that have certain values in a particular field. i used the perform find script function with omit records indicated, but all the records continue to end up in the final product. what does [Restore] mean in the script? is it putting the records back in?

i'm afraid i'm a bit rusty on filemaker, as i only manage one database which has worked well enough for our purposes for several years. now, i'm trying to do a little streamlining and finding i don't remember much about what i was doing when i originally set it up.

thanks

Posted

Enter Find Mode[] ~uncheck the Pause checkbox

Set Field [MyField; "Value I want to Omit"]

Omit Record

New Record/Request

Set Field [MyField; "additional Value I want to Omit"]

Omit Record

Perform Find[] ~do not check the Specify checkbox

Test with above script. If it doesn't do what you want then you may need to better describe your specific script.

This topic is 6291 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.