Solved: How to retrieve data from another table? - Page 2

Helmi_87 · 01-25-2021 03:12 AM

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

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")

View solution in original post