Skip 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 multiple numeric values in one field

Featured Replies

I have looked around and seen plenty of solutions for filtering text lists but what I am trying to do is basically very simple but I dont seem to find it

Field A contins multiple numeric values per record . What I want to do is find a calculation that I can use to filter these values in each record to be within a specific range of numbers and discard any that fall outside the range

For example Field A contains values of 187561, 188221, 196774, 215545, 216887, 223349 and I want to filter them to values that are >190582 and <217349 so the result would be a reduced value list of 196774, 215545, 216887

Its easy enough to do in a portal with filtering but I need to store the list of filtered values in the record table

Is there a simple way to do this?

Is there a simple way to do this?

No, I don't think so.

Its easy enough to do in a portal with filtering but I need to store the list of filtered values in the record table

Do you mean you need the calculation field to be stored? Why?

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.