Avoid to edit a useremail after a record creation

AppSheet AppSheet Q&A
1

Appreaciate your help on this.

When a record is created, I have set the USEREMAIL() function to get the user email of the record creator, but later when I need to edit the record, the useremail gets modified and is replaced by my useremail. How can I do to keep the initial useremail and not get modified when the record is edited? I tried to uncheck the Edit option but an error says that when there is a formula the record cannot be read only.

2

Please move the expression USEREMAIL() to the “initial value” setting of the column settings and make the editable_if setting as FALSE

1 Like
3

Awesome! it worked. Thank you so much.

1 Like
4

You are welcome Good to know it works the way you wish.