User Email not updating on Edit Record

Hi. I have User Email Address and Username on my form. When I edit an original record with a different user account I can see the values in each field have updated corecctly on the form but when I save the details the Username is only updated in the Google Sheet and not User Email Address.

User Email Address is a Ref type with Inital Value = USEREMAIL() and Username’s App Formula is [User Email Address].[Username].

Can anyone help on this one?

When I edit an original record […]

When you add a new record? Or when you edit an existing record? “Edit an original” is ambiguous.

[…] I can see the values in each field have updated corecctly on the form […]

Did you type the values into the form, or did the app auto-fill the values?

[…] when I save the details […]

Is “details” different from “the form”? What do you mean by this?

User Email Address is a Ref type […]

What table does it reference? Does that table have a Username column?

[…] Username’s App Formula is […]

A column with an app formula cannot be modified from a form, therefore something in your description of the problem is incomplete or wrong.

Hi @Steve. I also posted the comment on a similar thread with @Aleksi and his suggestion of moving the USEREMAIL() tag to the AppFormula Field instead of the Initial Value field worked.

1 Like