I want to retrieve data from Air table based on 1st column Data .
I want when detail of first column is filled than row should be shown on screen.
Please tell me how to do that without knowing the row number.
get data with help of get columns, and when data received and stored to lists, use is in list item, and id it comes true, then use get index of item in list, and item will be that(user id or device id) which you have assigned for user, and in list( which you have got and stored for first column) and that index number you can use to get data with help of cell or from stored column list.
if your users have multiple data entry like one user have 10, and other have 20 then you cant leave those 10 cells empty, database will not return any data if you leave any single cell empty, and tell me how you are storing that ref? means how you create that for every user?
this is not a good idea because there is always a sense to use, how do you compare data for 2 or more users with same id? what if a user A has id 123 and user B also has same 123, and when you compare to get index of B, it will get data of A.
id must be different for every user, like gmail, yahoo and all others, id cant be same, because users always can be recognized by a different id, method of get index from list will always work for only first user, if there any same in list he will not go check that. please first correct your idea, then maybe someone can help.