Thank you for your reply.
I am actually trying to look up the value of a cell based on the User_ID and Column.
The block you are suggesting is returning all values for a specific column, but I need this list to be filtered by the User_ID.
This is exactly what I am looking for, only difference is that I want to look up data from a Google sheet…
I check the blocks and try to replicate it.
Many thanks for your help!
V
It works the same in Google sheet and also in Airtable.
Use the same logic just change the table from Local to Google sheet.
It is better to use the Local Table for filtered results and will become more useful when you have multiple users using the same app then you do not want to have the filtered results in Google sheet but you want it stored in the phone of the user.