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.

Reverse the numeric order in a field

Featured Replies

  • Newbies

I have some guys out in the field using FM Go 12, who read special meters.  They want to enter 5-digit readings, BUT, they always read the dials Right-to-Left, for accuracy.  How could I develop a numeric data entry field that allows these right-to-left reads on the form (always 5 digits), and when done, they click a button and this field is transformed left-to-right in reverse numeric order? 

e.g.,  53463 (entered), 36435 (stored) - or even - 43280 -> 08234 ??  My brain is fried.  THANKS!!

Solved by David Jondreau

  • Solution

I think you should store the original entry, just case and have a second field with the reversed/corrected digits. The second field can be a calculation using a custom function like this one (which I have not tested): https://www.briandunning.com/cf/160

I would probably build a layout with a big numeric keypad, i.e. it's made of FileMaker buttons. As they tap each button my script might store the digit in a repetition of a variable, e.g. $n[5], $n[4], etc. Actually $$ variables would be better, so you could display them on the layout as merge variables. The final tap would assemble the result: $n[1] & $n[2] & etc.

 

Be sure to store the result in a text field, since number fields will ignore leading zeros.

  • Author
  • Newbies

Wow!  That was quick!  I'll try both of these techniques.  One oddity:  not all meters are read in reverse order, so I may try to make it so that if the RevRead field is not blank, I will transpose.  Final "Read" field, will have to be numeric.  Ignoring leading zeroes is just fine.  Not all numbers are 5 digits.  Lots of human factors variance in the way the guys read these meters to deal with, too.

 

Thanks guys, I'll let you know. 

  • Author
  • Newbies

Thanks David & Fitch.  Both techniques work beautifully!  You da men!

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.