How to retrieve data from another table?

Hi There,

I Have three tables USER, TTD and DETAIL TTD. In TTD Table, there are two columns that I want to fill in with data from USER table based on USERMAIL () which is also stored in USER table.

Hello @Helmi_87, welcome to the Appsheet community!

To search a table using an especific value, you can use the LOOKUP() function.

LOOKUP( find-value , in-dataset , in-column , return-column )

LOOKUP(useremail(),"USER","Email_column","Return_column")
2 Likes

Thank you @Rafael_ANEIC-PY for your quick response,
I will try to implement and see reference link that you gave.
Thank you very much!

2 Likes

thank you @Rafael_ANEIC-PY for your guidance. it works :ok_hand:

2 Likes