How to display User's email when they enter data

[Atitiya_Ta]

Could you please help us to display user email
It can not show user email when we input Useremail() in the initial value.

[Aleksi]

Is this a public app?

[Atitiya_Ta]

We have created new app sheet for our customer. we want to have log in page for specific user and when customer open order. We want them to see only their order and can not see other customer order. Can you help us to make it happen?

[Aleksi]

This will happen automatically with the user’s email address if you use a security filter like [EmailColumn]=USEREMAIL(). Your table should have that “EmailColumn” with Initial value USEREMAIL().

[Atitiya_Ta]

I input Useremail() on initial value but it still not default as Current user Email
so It something wrong?

[Aleksi]

Are you adding a new record or modifying existing record?

[Atitiya_Ta]

I Modifying on Customer Email
I want to setting initial value as current user email to identify customer.

[Suvrutt_Gurjar]

Hi @Aleksi,

I am also experiencing a similar thing today. Below are my observations. I had posted this just a while ago in another thread ( Google access denied) but after reading this thread, I feel that this thread is more appropriate.

I have Google based account. The columns wherever expression USEREMAIL() is entered as default value, are returning blank for that field in the form view as well as when the record is saved in the back end Google sheet.

The fields wherever USERNAME() or USERROLE() is entered as default values, such columns are properly capturing user name and user role in the form view as well as on save in back end Google sheet, though.

Also when fields with USEREMAIL() are tested in the editor in test mode, the test results properly show user email but as mentioned, this value does not reflect in form or saved record.

Appreciate guidance.

[Aleksi]

If the new option called “Preview as user” is not filled in the emulator, it will show this kind of behavior. Add an email address and re-sync and it should work.

[Suvrutt_Gurjar]

Got it.Thank you @Aleksi as usual for your prompt guidance.

[Aleksi]

You’re welcome

[Gil]

Hi @Atitiya_Ta @Suvrutt_Gurjar,
The blank USEREMAIL() issue is fixed now. You may need to refresh you browser for the fix to take effect.

[Atitiya_Ta]

Hi Gill and Alex

Thank you.

[Suvrutt_Gurjar]

Thank you @Gil. Appreciate.

[AppsheetNoob69]

Hi,

I am experiencing a similar issue. My View filters are based on the logged in user “Preview App As”, is not working because the USEREMAIL() is only capturing the App Owner’s email and not the Preview App As user.

The app is not yet deployed and it’s in the development stage. I could have missed something here. I just noticed this today when testing who can access the views.