How to show the data of the row when you type the email address of the user (email address is the first column)

AppSheet AppSheet Q&A
,
1

When you type the email address of the user it shows the data on the corresponding column.

3X_9_e_9e729c2f1ff03aa5c024f884a3e251a821df1f2e.png
3X_9_e_9e729c2f1ff03aa5c024f884a3e251a821df1f2e.png729×191 5.28 KB

example when you type “aa@gmail.com” it will show the data on column BCDE. thank you.

2

Hi, if you are using Ref field on another table and the email is a key column, you can use Deref expression like [Email].[ColumnB] for example with the initial value.