Need help please. Im trying to create barcode scanner wherein once I scan the code and recognize as recorded data in my spreadsheet. Info will appear in textboxes once I click SUBMIT. But this the error I get
Select list item: Attempt to get item number 2 of a list of length 1: (())
It looks like you are not getting data from google spreadsheet. Try setting web url in the following format
https://docs.google.com/spreadsheets/d/<your_id>/gviz/tq?tqx=out:csv&tq=Select * WHERE A=
Sure thing will try this one. Thanks
Also have a look at below post, it will help you
gviz is an abbreviation for Google Visualization API which is used to access google sheets and google charts, among other things. In this tutorial we will focus on getting and querying data on google sheets, to work with or display this data in...
Appreciate your feedback. Done with your advise and this is the error I get
Thanks so much. I will look into it.
Did you use the web address as suggested by dora in previous post and try?
But i am sure, if you use only digit alone in any cell and upon search you will get the whole sheet cell values…
Yes. Am I doing it right? see picture please.
Same error ‘Attempt get item number 1 of a list of length 0’
add one get datalist global variable and right click on it, then click Do it and cross check whether you are getting or not the value… BTW Did you share your gsheet atleast to viewer by one and all?
Please make sure what you are getting in the
You do not need ΄ ΄ arround barcode_data.text and most probably you do not need url encode block. Use
Do it on join block and post a screenshot
Connect companion and use Do it to debug your blocks
This must be the reason. I really Appreciate your time and feedback.
Tried this one. Same error
And this is my updated block
can you post your aia here or in pm? or try like this and post your result
Sure. I’ll send you so that you can double check. Thank you so much.
Problem solved via pm. It is due to the barcode text block,
Works Great now! Just need to arrange GUI. Thank you so much
@Still-learning! Appreciate your help guys @dora_paz