I’ve succesfully connected the airtable with thunkable X. My application makes this:
read input string
query the spreadsheet with this string or substring or null string (field name)
show the results in a listviewer
Until this moment, everything works fine.
The user select one of the resulting elements of the listviewer
the listviewer returns the index of the element selected by the user, but what I want is to access again my spreadshet to get the row corresponding to the selected name. But, what is the index of the element in the spreadsheet? I don’t know if there is a property that returns the _id of a row of a spreadsheet (this would solve all my problems)
What I did is that I store the index of the elements that are part of the resulting list in another list (e.g. 2, 4, 8 are the elements of the spreadsheet that are showed in the listviewer). This worked initially if the input string was null (I mean, I show all the spreadsheet elements in the listviewer). I stop working when I decided to sort the spreadsheet (it seems that airtable maintains internarlly the initial _id of each row independently of the order it has in the view you see)
So, now I select one element and show me other, usually the following now (yes, I’ve tried to +1 my rownumber variable, but it does not work). In general the behaviour is unpredictable, as internally airtable has _id of the row as they are created, so if you remove a row and add another one, the new one does not have the +1 id, but the +2 id).
Does it makes sense to you? Please help me, I’m mentoring some girls and they need to finish this app to present it for a competition.