Here I’ve attached images of a very simple sample of block code about collecting (or comparing) data from an airtable spreadsheet - in this case, I used “call spreadsheet1.getcolumn()” command:
If the images don’t display correctly, here’s a sample of my code:
when Button_1.click do
call spreadsheet1.getcolumn - column name = “Password” - max record: “1000000000000”
when spreadsheet1.gotcolumn do
notice = get(responsecode)
So, as we can see, this code is supposed to get the column data from the airtable spreadsheet when the button is clicked. When the data is found, a notifier will alert a response code (I used the notifier just as a test. It could be a change in text from labels, buttons, etc.)
My only concern about this code is that it doesn’t respond to the program. I was wondering if there might be something wrong about it… somehow in my companion I click the button and the notifier is not displaying any message. Not even an ‘error’ alert.
The only ‘call’ command in the spreadsheet that actually responds to the program is ‘Create Row’.
Note: Spreadsheet properties (API key, Base ID, Table name, View name) are already corrected.
- I have already seen all relative posts and solutions from the community; such as the ones where I must remove a blank row from the spreadsheet. I have also seen video tutorials.
- I have also tried to combine various elements (like the ‘switch’ variable).
Any help out there will be truly appreciated.