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.
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:
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()?
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.
