Does anyone know how I can allow a data field (column) to be completed for a new record but also prevent that same field from being editable in an existing record when in update/edit mode?
Open the column’s definition and enter this expression in its Editable_if property:
The problem with Reza’s formula (sorry Reza) is when the user makes a typo error, he/she can’t do anything. Sometimes it’s okay and sometimes not. How about… NOT(IN([KeyColumn],TableName[KeyColumn])).
Many thanks Aleksi.
Your formula worked perfectly.
In the end I included your formula in an OR statement.
The first option was your formula the second was USEREMAIL()=[email of user].
This then allows the user to edit all fields in their own records but not for others.
If you were going to allow each user to edit their own record which I think is a great idea and makes a lot of sense, then that OR will neutralize Aleksi’s formula, because for new records that USEREMAIL()=[email of user] piece by itself will always return TRUE, and it would be enough on its own (assuming the initial value of [email of user] is set to USEREMAIL(), and prefilled for all new records).
Good point Reza
Very good point!!