Auto user id

[Magic_Pharsa]

How can I make user email as a user id? ( auto complete) and non editable. Tx

[Mike_A · Accepted solution]

@Magic_Pharsa -

If your app requires user login, have you tried setting your UserID column appformula to be USEREMAIL()?

help.appsheet.com

USEREMAIL()

User's email address

[Magic_Pharsa]

It’s solved. Thank you

[Steve]

Better: do not use app formula; instead, set Initial value to the expression, USEREMAIL(), and Editable? to the expression, FALSE.

If you use app formula, the column value will be updated any time any user modifies the row. If some other user modifies the row, that user’s email will replace the existing value.