I do not seem to be able to create the following logic for my app. These are the steps that I need to implement:
1.) Get the text written in Text Box
2.) Get the entire content of the Airtable Spreadsheet table
3.) Parse every existing cell (from every column and row) and compare it to the text from Text Box
4.) If a text from Text Box equals to a cell that it was compared to, then return the entire row where that cell is
So far, I have the following blocks for my app which does not seem to work:
Side note: I have my Spreadsheet component set up correctly because when I try to look for a specific cell in the specific column and row, it gets me a result while using the Get Cell block of Spreadsheet component.
I have the same problem. I wanted to make a cell query and Airtable bring me all the cells of this line. This would be very useful for example, when querying a barcode. If I could bring the whole line through the bar code, then I would be satisfied. Another thing that would be cool, would be to research all products by a certain manufacturer.
I find this topic very important as one of mine that presents the same content of this one. Can we count on a pleasant response?
Anyone any ideas? I’m still stuck here without any progress. No matter I try, I am still not able to search for a value and then return the row where that value is found.
Here is a guide on how to filter data in Airtable. In the example the data is filtered by date, but you can use the same logic to do it with any type of value.
In post 19 I attached an aia file that has 3 screens and in each screen there is an example of how to filter data…
