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.

Formating a field

Featured Replies

Is it possible to format a field to display fractions?

I want to enter my values using decimals (10.5), but have the record read 10 1/2. Tried "number format" in layout mode but fractions aren't an option.

Running FMP6, but have access to FMP7 if needed.

Thanks

  • Author

Thanks for the help Bob.

  • 1 month later...
  • Author

I'm still having a little trouble doing this. If it isn't much trouble can someone take a look at the attached example to see if what I'm trying to do is possible?

Thanks

Sample.zip

See attachment.

For field L, I created a calculated display field Ldisp which shows fractions, and placed it over top of field L, so when finished entering data in L, Ldisp contents show instead. You can repeat the same for the other fields.

The display fields' formatting should be set to not allow entry.

Sample.fp5.zip

  • Author

Outstanding Bob! This is very helpful.

Thanks, J

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.