Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

omitting found records

kaosgds
in Script Workspace and Script Triggers

Featured Replies

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

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.

Create an account or sign in to comment

https://fmforums.com/topic/54603-omitting-found-records/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.