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.

Specified Find Requests

Featured Replies

I have little problem when specifiying find requests to omit records on a found set.

In the Specified Find Requests dialog box, I can easily input the field to match a specific number, literal text and all that jazz. What I need to do is have the cirteria be field data from a global field (that changes now and then). Ive tried every combination I can think of and it doesnt work. I can set the criteria to be the actual variable in the global field but I cant get FIlemaker to actually look at the field contents.

The online help is pants (no surprises there) and ive only ever seen examples where criteria has been a specific number or text. Can a Specified Find Request involve looking at the content of a field?

Following a Find script step you could use Set Field (by calculation) to hold the value of your global field, and then perform the find.

Dynamic find data must be entered using

Enter Find Mode [ ]

Set Field

Omit (if necessary)

Perform Find [ ]

It cannot be entered using a stored request.

  • Author

Thank you -Queue-!

Your idea has worked: entering find mode, setting the field data and using the step Omit works. Quite why the stored request cant be dynamic is beyond me.

Thanks

Create an account or sign in to comment

Important Information

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

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.