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 Lists and the Actual Data Stored be different values?

Featured Replies

FM stores value list options as they are whole.

A web form supports showing the label and storing an associated value.

Can the same behavior be easily duplicated in FM?

This is in cases where you're working with data that uses simple stand ins rather than the entire string.

stored value  -- Means:

a (All Options)

b (Beta Release)

c (Complete Image)

tr (Translated)

 

I could do a focused find/replace with that CSV data and change those values into their full descriptions, which means any data going back the other way needs to be exported with the values rather than descriptions first.

When you define a value list, you get to choose between custom values and values from a field. If you select values from a field, you can select a 2nd field (in the same record) to be used as the label. Fields formatted as pop-up menu will continue to display the label after selection. For fields formatted as drop-down list, you can overlay the field with a non enterable field showing the label. If you're using a field formatted as a checkbox set, you can define the value list to show values only from the 2nd field. In either case, only the value from the 1st field is stored.

 

  • Author

Ya know.. I even saw that while perusing around the options. It just didn't occur to me that .. that was what I was looking for, almost.

I wish I could do it with a plain value list. This way, though I did it by adding a table for configuring value list choices and then use those fields. Sp it works.

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.