Joseph31 Posted October 9, 2010 Posted October 9, 2010 I know this has been asked so many times... Is there a way to lock fields on a layout so users may not change the data after a button or switch is activated (clicked) I have more than 20 fields on some layouts.... Thank you
bcooney Posted October 9, 2010 Posted October 9, 2010 To truly lock edit of fields, you would use FM's Security and create an access rule that limits edit. For example, if there is a field in the record, "flag_Locked," then the access calc would be, allow edit if flag_Locked≠1. How you set flag_Locked is up to you. You could have anything from the field on the layout, formatted as a checkbox with a value list of 1, to an elaborate script that prints, asks the user if they want to lock the record, and then if yes, sets this flag field. I typically create two layouts, one with all the data entry interface (buttons, portal "add row" buttons, delete row buttons) etc, and one without all that - the "locked" layout. I also create a nav script that if flag_locked =1, go to Locked layout.
Joseph31 Posted October 9, 2010 Author Posted October 9, 2010 Two questions: but first thank you for your reply 1) where is the flag lock? Is it when you create the field under options? 2) the duplicate layout --- doe this have the same relationships to original and can I just copy and past the original layout to make the second? Just a thought will a script trigger work in a case of locking the field based off off a locking field? Thank you.
bruceR Posted October 10, 2010 Posted October 10, 2010 Flag lock is a field you create. Why copy paste? Duplicate the layout. Why ask? Why not do it and tell us the result?
Recommended Posts
This topic is 5157 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