Normal Topic Locking records (Read 472 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Locking records
Oct 30th, 2023 at 5:15pm
Print Post Print Post  
Is there a simply way to lock specific fields in a record once it is created and saved?

This may be necessary for values in the main form and sub-form are not changed after the record has been process.

An example would be creating a sale for $1000 and posting it to our Accounts database, but then changing the sale amount after the invoice is posted.

Any changes would only be made by manager/administrator level.

I have made an alert on the daily report which would warn if an invoice has an error, but it is far from perfect.
  
Back to top
 
IP Logged
 
FlipGilbert
Full Member
***
Offline


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: Locking records
Reply #1 - Jan 4th, 2024 at 12:42am
Print Post Print Post  
Yes, there are many ways
I use an If formula that looks like...

If (Status = "Complete") and Not @Group = "Admin"
     {
           ReadOnly(SaleAmount,2)
     }
This makes only that one element read only with the ability edit the other details.

I hope this is helpful.
-flip


There are much sharper knives in this forum.
  

It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged