jasonwood Posted August 12, 2012 Share Posted August 12, 2012 Any tricks out there to conditionally lock specific fields (not entire records or layouts)? Link to comment Share on other sites More sharing options...
LaRetta Posted August 12, 2012 Share Posted August 12, 2012 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. :-) Link to comment Share on other sites More sharing options...
jasonwood Posted August 13, 2012 Author Share Posted August 13, 2012 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). Link to comment Share on other sites More sharing options...
mr_vodka Posted August 13, 2012 Share Posted August 13, 2012 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. Link to comment Share on other sites More sharing options...
bcooney Posted August 13, 2012 Share Posted August 13, 2012 Put the fields in a popup window controlled by a scripted Edit button. The button will only open the popup window if validation passes. Link to comment Share on other sites More sharing options...
jasonwood Posted August 13, 2012 Author Share Posted August 13, 2012 Wouldn't it be cool if you could use the conditional formatting feature to override the "Field Entry" setting? (feature request sent!) Link to comment Share on other sites More sharing options...
bcooney Posted August 14, 2012 Share Posted August 14, 2012 You could turn the fields into buttons and use a script trigger to allow/disallow entry based on validation. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4272 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now