PROTECT RECORDS

bump!

Hi, 

You can use the option "Writable if..." in the options of a table ("Edit fields").

If you implent a "Yes/No" field you can show it as a checkbox and set in the "Writable if..." field the function: 

 

'Yes/No' = 1

 

To make the record writable if it once locked, you can use a button with the formula: 

'Yes/No' := 1

 

Best, Jörg

This doesnt appear to work for formula columns? It locks data entry fields but calculations are free? How can we lock formula fields please Jorg?

thanks

Tim

Hi, 

You can nor write in formula fields anyway. If you do not want to show them with a certain condition you may enter the condition in the option "show field only if". 

It is also possible to add the condition directly into the formula of the field. E.g.

 

if "my condition" then "my formula"

 

Best, Jörg

Hi, 

The fields is still writeable if we write by update multiple record. How to sort out that?

Thanks.

Antsa.