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.

Value List / Set functions?

Laura Linton
in Value Lists

Featured Replies

  • Newbies

I've been checking out my FM reference books for various value list / set functions. I have a field in my database for level. This could be interpreted as grade for the people in my database but not necessarily. I want to write a utility that checks if the level is in my grade value list (is it a valid member of my set - problem 1), what is its position in my value list (grades are not necessarily numeric so I can't add 1 to them - problem 2) so I can change it to the next grade in the value list (problem 3 - easy with the GetValue function if I can take care of problems 1 & 2).

Any suggestions?

I think this file on my web site will solve your second problem of identifying the position of a value in your value list.

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000049

Create an account or sign in to comment

https://fmforums.com/topic/51321-value-list-set-functions/
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.