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.

Boolean field formatting -> single check or radio button?

  •
rich williams
in Layouts

Featured Replies

Hi All,

I am using ESS and hooked up to ms sql db. I have a column in the db of type BIT. with possible values of zero or one. This is the typical way of storing boolean/true false values.. What is the best way to handle this in FM?

I notice with radio buttons the labels and values are not seperate.. And also i can't make a single checkbox.. checked meaning true and unchecked meaning false.

Am i missing something? how can i handle this? thanks!

For Boolean checkboxes, I usually just use a value list with value 1. Then ties that value list to the field with a checkbox. You can resize the checkbox to not show the text.

FileMaker has very loose data types. So if this were in a FileMaker table, then you could just use a number field.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

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.