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.

TextToNum is a bit wierd?

Rover
in Calculation Engine (Define Fields)

Featured Replies

I have 2 fields, test and test2.

Test2 is a text field I use for input (or a number field, it makes no difference to my problem)

Test is a calculation that returns a number with the formula TextToNum(test2).

I want to see if test2 contains a numeric, if not I expected test to be blank.

It works as expected except when test2 contains no numerics and starts with the letter f, n, t or y. Upper/lower case makes no difference. If test2 starts with f or n, then test=0. If test2 starts with t or ty, then test=1

I can figure out a work-around, but this bugs me. Can anybody explain what's happening? Please? Pretty-please?

Thanks

Use TextToNum("a" & test2). T/F and Y/N are considered boolean for True/False and Yes/No in versions before 7. So any strings starting with those letters are also treated as boolean.

  • Author

Well, DUH!

Don't I feel stupid?!

Guess I didn't see the forest for the trees, or is it see the trees for the forest?

Thanks much for the explanation.

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.