question by a new comers

[Harry0416]

May I know how to do the following thing for my app. 

For example, if someone login with an email (like abc@gmail.com).  Then I can know he is Jack and auto fill-in some information (e.g. name, age, role, etc.) in the app.

Is it possible to do so? Please let me know if there's a way to do.

[Aurelien]

Hi @Harry0416 

Yes, if you have a table with all of the user's informations, you will need to use the Initial Value expressions, using LOOKUP() expression.

For example:

LOOKUP(USEREMAIL(),"USER","email","age")

For reference:

LOOKUP() - AppSheet Help

Define App formulas and Initial values - AppSheet Help

[Harry0416]

Thanks for helping! @Aurelien 

So I have to add a new column in the google sheet that store the user's email (I only have the name, phone, live location). So that I can auto fill in those data in the app with the lookup()?

[Aurelien · Accepted solution]

Yes.

In your app editor, click here:

Then in here, you set your LOOKUP expression:

[MultiTech]

Using lookup() is a brute force method, you'll want to implement the Current User system instead; increases the efficiency of your system, and opens the doors to advanced functionalities.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-aroun...