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.

Replace Contents changed in 7?

Featured Replies

There is a difference between versions I noticed ... In vs. 6, I used Set Field [NumberField, NumberField] to strip leading zeros and alpha. Replace Contents worked the same whether from menu or script.

In 7, Set Field (setting a num field to itself) strips leading zeros and text) but Replace Contents (both from menu and script) does not!? I wonder why that was changed. Mind you, I'm not complaining ... just want to understand so I can take full advantage of the differences. I thought I recalled another change about Replace Contents but now can't find it. I don't think it was this issue, however.

I have been playing with the new Filter() function and applying it to number fields and calculations. Yes, I know it's a text function but I couldn't help myself. I can strip text but preserve leading zeros easily (in calculations, auto-enter or script) with:

Filter(text; "0123456789") ... sooooo much easier than in prior versions. In fact, when using Filter() on number field, you don't even need the ". But if you want to include ANY zeros, it must be listed at the end as:

Filter(text; 1234567890) ... which will also preserve the leading zeros. If you try it with the zero first, the calculation will remove the zero again after you exit the calculation box.

Of course Abs() and Int() will also strip text but it removes the leading zeros as does TextToNum. crazy.gif Filter is incredible!!!

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.