Select list item: Attempt to get item number 2 of a list of length 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: (())
image

image

image

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

Sure thing will try this one. Thanks

Also have a look at below post, it will help you

1 Like

Pls correct this mistake

image

You can design like this

image

1 Like

Appreciate your feedback. Done with your advise and this is the error I get
image

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

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

Yes share to “anyone”.

Please make sure what you are getting in the get datalist

1 Like

image

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

1 Like

This must be the reason. I really Appreciate your time and feedback.
image

1 Like

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

image

1 Like

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

Works Great now! Just need to arrange GUI. Thank you so much @Still-learning! Appreciate your help guys @dora_paz :smiley:

2 Likes