Does anyone know how I can allow a data field...

(Robert Winsloe) #1

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?

(Reza Raoofi) #2

Open the column’s definition and enter this expression in its Editable_if property:


(Aleksi Alkio) #3

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])).

(Robert Winsloe) #4

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.

(Reza Raoofi) #5

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).

(Aleksi Alkio) #6

Good point Reza

(Robert Winsloe) #7

Very good point!!

Thank you.