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.

Simplest Yes/No value list?

K1200
in Value Lists

Featured Replies

I'm using the Format As Boolean option for a numeric flag value, with the displayed values being simply "Yes" and "No".

I defined a value list so the user can make their Yes/No selection. Currently, the options that are shown to the user are "1 = Yes" and "0 = No" -- and everything works fine.

However, I would like to offer simple "Yes" or "No" choices. Is there a way to define the value list to display only the words but still set the numeric field without having to define a table to hold the choices?

Thanks for any help.

I don't think so. I just make the field a button that toggles the choice.

  • Author

Thanks for the suggestion.

I tried it using a Case statment to toggle the value, but upon clicking the field (to toggle it) the field displays a 0 or 1 until I click somewhere outside of the field. Then it displays the appropriate "Yes" or "No". Have I missed something? Or is that how it has to work?

If the field itself is a button, that shouldn't happen.

See the demo I have posted here.

  • Author

Thanks. That did it.

I had overcomplicated things by using an Insert Calculated Result. The simpler Set Field + "not" operation does the job.

Create an account or sign in to comment

https://fmforums.com/topic/50689-simplest-yesno-value-list/
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.