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.
Solved! Go to Solution.
Yes.
In your app editor, click here:
Then in here, you set your LOOKUP expression:
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:
Define App formulas and Initial values - AppSheet Help
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()?
Yes.
In your app editor, click here:
Then in here, you set your LOOKUP expression:
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.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |