How to retrieve data from another table?

[Helmi_87]

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.

[Rafael_ANEIC-PY · Accepted solution]

Hello @Helmi_87, welcome to the Appsheet community!

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

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

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

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

[Helmi_87]

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!

[Helmi_87]

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

[Imtisunup_Longc]

One can also use SELECT option