October 9, 201015 yr 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
October 9, 201015 yr 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.
October 9, 201015 yr Author 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.
October 10, 201015 yr Flag lock is a field you create. Why copy paste? Duplicate the layout. Why ask? Why not do it and tell us the result?
Create an account or sign in to comment