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=
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
Pls correct this mistake
You can design like this
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?
Yes share to “anyone”.
Please make sure what you are getting in the get datalist
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
This must be the reason. I really Appreciate your time and feedback.
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.
Works Great now! Just need to arrange GUI. Thank you so much @Still-learning! Appreciate your help guys @dora_paz
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.