Jump 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.

Limiting text formatting abilities to all fields in database

AspenArchive
in Calculation Engine (Define Fields)

Featured Replies

That's simply it - is there a way to deny text formatting to all fields within a database? Data ENTRY is allowed, just not formatting, it MUST stay the way the layout has described it.

I've set validation on some fields for size and font and color, but there are 100+ fields that need these options and not only would that be tedious work (though creating a database can certainly be so) it also does not allow me the option to deny alignment formatting, which is one of the most important ones - any suggestions?

I posted this again in the Accounts and Privileges forum, so apologies if it repeats...

Thanks!

SC

It is pretty easy. In Define Fields, Options, Auto-enter by calculation, uncheck "Do not replace existing value", with the formula:

Evaluate ( Quote ( the field name here ) )

(P.S. I deleted your other post. There were no answers yet. It's not an Accounts and Privileges question; this is the best place for it.)

This is a cool trick... I didn't realize that evaluate would strip out all formatting

Create an account or sign in to comment

https://fmforums.com/topic/36366-limiting-text-formatting-abilities-to-all-fields-in-database/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

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.