How to lock a field or layout based on value of another field

[tinymusiclost]

Hi Everyone

 

On my Invoice layout, I have a field named "Status".  Which when that field turns to "received"

as the invoice is completed I would like the layout to be non edible, but you can still edit three of the fields,

for example one of them fields being called "priceEx"

 

Any help would be greatly appreciated

Thanks

 

[Josh Ormond]

2 Options:

1. Use FM's built in Privileges and Security to prevent modifications to the record.
2. Script and control access to a special "Edit" layout, while turning off entry into fields on a "View Only" layout.
   • Add a button to enter an "Edit Mode".
   • Test the record to see if it's closed ( or maybe the developer/manager if he still needs to get in ).
   • Then either go to the Edit layout, or display a custom dialog saying "NO".