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.

Conditional field locking

Featured Replies

Any tricks out there to conditionally lock specific fields (not entire records or layouts)?

I don't know about tricks but security allows conditional restriction on fields. If you can provide an example, we can provide the logic on how to handle it. :-)

  • Author

For example, if field "Tracking_Number" is not empty, prohibit user from modifying fields "Weight", "Shipping Rate", and "Ship Date".

But they should still be allowed to edit/delete the tracking number, as well as other fields on the layout/in the record.

Security has the ability to use the calculation engine to control record and layout access, but when it comes to individual fields, it's just basically on or off as far as I can see...

I tried testing for "Get ( ActiveFieldName )" in the record edit rules, but it seems it only evaluates when you first enter the record (so you can just click in a permitted field first).

you could use 2 different privilege sets to control which has edit access and read only. Another option may be to put those fields into its own table.

Put the fields in a popup window controlled by a scripted Edit button. The button will only open the popup window if validation passes.

  • Author

Wouldn't it be cool if you could use the conditional formatting feature to override the "Field Entry" setting? (feature request sent!)

You could turn the fields into buttons and use a script trigger to allow/disallow entry based on validation.

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.