tiny
(Tin)
September 29, 2021, 5:00pm
#1
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: (())
dora_paz
(Dora)
September 29, 2021, 5:26pm
#2
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=
1 Like
tiny
(Tin)
September 29, 2021, 5:35pm
#3
Sure thing will try this one. Thanks
dora_paz
(Dora)
September 29, 2021, 5:36pm
#4
Also have a look at below post, it will help you
INTRO
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...
1 Like
tiny
(Tin)
September 29, 2021, 5:47pm
#6
Appreciate your feedback. Done with your advise and this is the error I get
tiny
(Tin)
September 29, 2021, 5:48pm
#7
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…
1 Like
tiny
(Tin)
September 29, 2021, 6:03pm
#9
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?
1 Like
Please make sure what you are getting in the get datalist
1 Like
dora_paz
(Dora)
September 29, 2021, 6:14pm
#14
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
[Animation4]
1 Like
tiny
(Tin)
September 29, 2021, 6:18pm
#15
This must be the reason. I really Appreciate your time and feedback.
1 Like
tiny
(Tin)
September 29, 2021, 6:38pm
#17
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
1 Like
tiny
(Tin)
September 29, 2021, 7:02pm
#19
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,
2 Likes
tiny
(Tin)
September 29, 2021, 8:17pm
#21
Works Great now! Just need to arrange GUI. Thank you so much @Still-learning ! Appreciate your help guys @dora_paz
2 Likes