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.

Filtering Current Found Set

Featured Replies

I have setup a database that lists records in a filtering method via internal relationships. I would like to be able to include the current found set as one of the filtered sets. However I can't find anyway of determining what is the found set as there is no way of "Getting" that information. I suppose i could have a mark records script included in every find but that would slow down the dbs quite a bit and I want this to be fairly seamless.

Does anyone know of a way to determine what records are found and which records are omitted at any given point in time.

In FM8, this can be done by just using the primary ID in the relationship, and using the "Match all" option in the Go to Related Records [] step.

In prior versions, you would need to build a multi-key of all the IDs of the records in the found set. This can be done with a Set Field[] loop (appending the record IDs to a global text field,) or by using the Copy All Records script step (copying from a layout with only the record ID field and pasting that into the global,) then using that global as the relationship key,

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.