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?