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.

simple text formatting

George Swisher
in Calculation Engine (Define Fields)

Featured Replies

I have moved from ACCESS to FM and learning more about formatting field. I have a text field where users can enter a phone number only with no dashes or "( )". I want to validate the field where they must enter all ten number (areaCode phoneNumber) with no other characters. Then I want the field to display, but not store, the data as (xxx) xxx-xxxx. How can I do this?

Hi George,

I see you are using v5, this has become a lot easier in v7

This topic comes up from time to time, I just did a search for Phone and Format and got the Maximum Hits of 200. However, you would really have to go back to find much about how to do this in v5.

I attached this file click here

To this thread Click Here

HTH

Lee

cool.gif

  • Author

thanks!

I will take a look at it.

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

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.