Unfortunately Google API is not working anymore You can try any of these 3 alternatives ="api.qrserver.com/v1/create-qr-code/?data="&B11 ="qrcode.tec-it.com/API/QRCode?data="&B11 ="quickchart.io/qr?text="B11 Kind Regards
I would love to see a part 2 of this that includes the output and how to create a form where you can select the quantities that are received/removed in bulk.
First of all have a Merry Christmas. Thanks for the clear explanation, this was really helpful. Looking forward to your next video for the output version. 🎄🎄🎄
Hi Sri, great video. Is there anyway to add quantity when doing inventory input QR scanning? Where can i check part 2 for output inventory qty? thank you
I've added another qr code for when items are scanned out. How would I update the quantity in stock logic so it shows the correct quantity when an item has been scanned out?
Hello, How are you? Thank you for your videos and the effort you put behind them. However, at 4:54, you talked of sharing the link on the automatic way of updating the Google form once you input data in the sheet. You mentioned including the link in the description, which I can't find. Could you have forgotten to include it or if it doesn't bother you, kindly share it as a reply to this comment. Thanks!
Hello! I think you are referring to this one th-cam.com/video/k0RS4oPzy80/w-d-xo.html Thank you for letting me know I'll include it n the description Kind Regards
I spent a lot of time searching for videos and this was by far the best easy to follow video. I simply want to track company assets as they leave the warehouse and when they get returned so I have set up two bar codes per asset but how do I get google sheets to enter the name of the individual that is scanning the item to appear on the spreadsheet without the employee having to enter their name each time in a field on the google form or is this not an option? Also, how do I print the QR codes and possible name them with the asset name (ie. baker-1, baker-2, baker-3)?
Thank you for your words! I don´t see how without using code (Even with code I would have to think deeply) I´ll think about it and come back if I find a solution Kind Regards!
so does that mean we have to enter both in the form and in the COlumn A the products? or is there a way to simply fill the form (or the Column, vice versa) and it would fill the other one ?
Wireless bar code scanner. Bar code scanners are nice because they just tell the computer the number and then carriage return. Then just the coding portion (I know I make it sound easy lol)
Is there something like this which will allow tracking the use of tools? I would like to be able to loan tools out and know who has them. Of course check them back in when they are returned, and even allow people to exchange the tools using their cell phones.
Can we modify the quantity displayed from the QR? (for example if in a reading there´s 50 of the same product i just scan 1 and i can count the whole batch)
hi there very interesting video soo much to learn about it! with this technique is it possible to create the input/output forms for different users (only for output and some in and output). and when you scan the QR code that you can put in the number of items you in input or output so that you dont have to scan 10 times the same code to have the right amount of items in or out? I'm looking to do this for a long long time but never find how to do it! this idea of you may bring me to the good path. just wondering is the items mentioned above were possible to add in ? :) kind regards
Thank you for the video. I have a question - My google sheets does not generate the qr picutre (=image(...)). and I do everything as you do. What could be the reason please? Thank you.
Hello! It could be that the qr generator from google stopped working. You shoul change it for something like this ="quickchart.io/qr?text="&ENCODEURL(A2) Kind Regards
if for 1 input i would like an extra word to go on the input sheet on a second column... is there any way? like I know a QR can have tons of info.. if lets say in input there is timestamp then on ther other column the product name .. is there a way to add another column that could be example the customer name and so on .. ?
Yes but how can it get back in more columns into the result page? am i supposed to write the products with semi column delimited with other info? thats where i get confused
If I wanted to be able to input a number for the quantity of item from just scanning the QR once, like if I purchased 20 shirts that were all the same and wanted to add them into the inventory. Instead of just scanning 20 times, can I somehow have the google form recognize the different unique names still but also keep a running quantity total? Sorry if this didn't make sense
Hmmm Up to my knowledge (which is not too much), I think not, given that normal barcodes store numbers and not urls (I think) If someone knows more bout classic barcodes, excuse my ignorance Kind Regards
Is there a way I can use the QR code to also track the location of the product? Like if we had pre determined "aisles" or sections the product can be placed like A1, A2...
Hello, Thank you so much for your video. I tried adding new products and dragging the URLs and the QR code. I also added the product name onto the google form, when I tried to scan the qr code it kept saying a new question was added, and it didn't let me automatically submit the form. How can I add new products and have everything else work?
If i print this on my product label so its easier for someone to scan it and out the product. Can I take the response only for a particular email ID so when someone buys my product and scans at home, the stock shouldn't work there.
would like to know how you can do it so that when you scan the qr, it asks for the product type (eg, hoodie, t-shirt, hat etc), the color, the size and the quantity purchased or sold per item.
Hello! In order to send immediately you use ...ft5Ty/formResponse?entry... In order to display the form you use ...ft5Ty/viewform?usp=pp_url&entry... Regards!
You are right there is a bug with the google chart api. You need to change it with an alternative such as this ="quickchart.io/qr?text="&ENCODEURL(A2) Kind Regards
ATTENTION: (9/4/24): The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com Here is an example of its use =image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2))
Hi! I've gotten to the stage where I'm editing the URL To Input to add &A2 at the end. But when I try and test scan the new QR code instead of opening the link to the Google Form it says "Note:" and tries to make a note that has the link and the word "guitar" (I'm using a Samsung Galaxy Note 10 Plus) I checked I have all my quotation marks etc in the right places. Any suggestions?
Yes I think so You stand in the cell, right click get the link for the cell, and this is what you will put in the QR Code. I wouldn´t know how to make it dynamic though Regards!
You are right The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com Here is an example of its use =image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2)) Regards!
Unfortunately Google API is not working anymore You can try any of these 3 alternatives ="api.qrserver.com/v1/create-qr-code/?data="&B11 ="qrcode.tec-it.com/API/QRCode?data="&B11 ="quickchart.io/qr?text="B11 Kind Regards
Unfortunately Google API is not working anymore
You can try any of these 3 alternatives
="api.qrserver.com/v1/create-qr-code/?data="&B11
="qrcode.tec-it.com/API/QRCode?data="&B11
="quickchart.io/qr?text="B11
Kind Regards
Could you tell us more about that your API
I would love to see a part 2 of this that includes the output and how to create a form where you can select the quantities that are received/removed in bulk.
Would love to see a part 2 on the output, thank you for this great explaining video
Same, I am guessing still has not put one up, can't see on channel
First of all have a Merry Christmas.
Thanks for the clear explanation, this was really helpful. Looking forward to your next video for the output version.
🎄🎄🎄
Thank you! And sorry for answering almost at the next christmas ;)
Hi Sri, great video. Is there anyway to add quantity when doing inventory input QR scanning? Where can i check part 2 for output inventory qty? thank you
I've added another qr code for when items are scanned out. How would I update the quantity in stock logic so it shows the correct quantity when an item has been scanned out?
Thank you! This was a great tutorial.
Thank you!
Hello, How are you? Thank you for your videos and the effort you put behind them. However, at 4:54, you talked of sharing the link on the automatic way of updating the Google form once you input data in the sheet. You mentioned including the link in the description, which I can't find. Could you have forgotten to include it or if it doesn't bother you, kindly share it as a reply to this comment. Thanks!
Hello!
I think you are referring to this one
th-cam.com/video/k0RS4oPzy80/w-d-xo.html
Thank you for letting me know
I'll include it n the description
Kind Regards
@@practicalsheets Thank you for your quick response
Thank you for the video.. It is very clear..
Thank you for commenting!
I spent a lot of time searching for videos and this was by far the best easy to follow video. I simply want to track company assets as they leave the warehouse and when they get returned so I have set up two bar codes per asset but how do I get google sheets to enter the name of the individual that is scanning the item to appear on the spreadsheet without the employee having to enter their name each time in a field on the google form or is this not an option? Also, how do I print the QR codes and possible name them with the asset name (ie. baker-1, baker-2, baker-3)?
Thank you for your words!
I don´t see how without using code (Even with code I would have to think deeply)
I´ll think about it and come back if I find a solution
Kind Regards!
Thank you for your response!
This is really helpful. thank you
Thank you for commenting!
Bro muchas gracias por el video!! Te ganaste un seguidor!!
Mil gracias Gabriel!
Would like to see an output for this and as well if you can implement in a form a name of who have taken items out would be good as well
Of course.
I will work in part 2
Regards!
so does that mean we have to enter both in the form and in the COlumn A the products? or is there a way to simply fill the form (or the Column, vice versa) and it would fill the other one ?
It should be one or the other. But you still have to have the question ecause you need the id
Kind Regards
How can you make it so that you can scan in and scan out inventory and have the quantity updated automatically?
That’s what I want 😅
Plus one for this request too.
Wireless bar code scanner. Bar code scanners are nice because they just tell the computer the number and then carriage return. Then just the coding portion (I know I make it sound easy lol)
Thanks very much. that's very well explained and followed. Would definitely appreciate part 2 of video
Thanks for the words
Any suggestions for Pt 2?
Regards!
Fantastic, thank you!
Thank you for commenting!
Thank you….. nice solution and great explanation
Is there something like this which will allow tracking the use of tools? I would like to be able to loan tools out and know who has them. Of course check them back in when they are returned, and even allow people to exchange the tools using their cell phones.
Very interesting case, I would use thw QR but taking the to a form where they would put their name and maye more data
Regards!
great video, is there a way to close the google form after the qr code reads it? the camera appear so it can scan the qr code again. Thanks
Hello!
I´m not sure
There may be. I´ll look into it
Regards!
Can we modify the quantity displayed from the QR? (for example if in a reading there´s 50 of the same product i just scan 1 and i can count the whole batch)
we could add a field in the form of quantity so you could add a lot of the same product
Regards!
hi there very interesting video soo much to learn about it!
with this technique is it possible to create the input/output forms for different users (only for output and some in and output).
and when you scan the QR code that you can put in the number of items you in input or output so that you dont have to scan 10 times the same code to have the right amount of items in or out?
I'm looking to do this for a long long time but never find how to do it! this idea of you may bring me to the good path. just wondering is the items mentioned above were possible to add in ? :)
kind regards
Thank you for the video. I have a question - My google sheets does not generate the qr picutre (=image(...)). and I do everything as you do. What could be the reason please? Thank you.
Hello!
It could be that the qr generator from google stopped working. You shoul change it for something like this
="quickchart.io/qr?text="&ENCODEURL(A2)
Kind Regards
you're the man
🙏
if for 1 input i would like an extra word to go on the input sheet on a second column... is there any way? like I know a QR can have tons of info.. if lets say in input there is timestamp then on ther other column the product name .. is there a way to add another column that could be example the customer name and so on .. ?
Hi
That's the beauty of the QR. As you say, you may add al the amount of information you want
Kind Regards
Yes but how can it get back in more columns into the result page? am i supposed to write the products with semi column delimited with other info? thats where i get confused
If I wanted to be able to input a number for the quantity of item from just scanning the QR once, like if I purchased 20 shirts that were all the same and wanted to add them into the inventory. Instead of just scanning 20 times, can I somehow have the google form recognize the different unique names still but also keep a running quantity total? Sorry if this didn't make sense
thanks this is awesome but can it work with normal barcode 128 not just qr
Hmmm
Up to my knowledge (which is not too much), I think not, given that normal barcodes store numbers and not urls (I think)
If someone knows more bout classic barcodes, excuse my ignorance
Kind Regards
Is there a way I can use the QR code to also track the location of the product? Like if we had pre determined "aisles" or sections the product can be placed like A1, A2...
Hmmm. You would have to open the form so you could manually write the location
Regards!
Thank you!I found it is practical
Yes!
I´m glad I´m sticking with the title "Practical Sheets"
;)
Really, thanks for the message!
Regards!
Hello, Thank you so much for your video. I tried adding new products and dragging the URLs and the QR code. I also added the product name onto the google form, when I tried to scan the qr code it kept saying a new question was added, and it didn't let me automatically submit the form. How can I add new products and have everything else work?
If i print this on my product label so its easier for someone to scan it and out the product. Can I take the response only for a particular email ID so when someone buys my product and scans at home, the stock shouldn't work there.
Hmmm
I think it could work
You could set up the countif only for that particular email
Kind Regards
would like to know how you can do it so that when you scan the qr, it asks for the product type (eg, hoodie, t-shirt, hat etc), the color, the size and the quantity purchased or sold per item.
Hello!
In order to send immediately you use
...ft5Ty/formResponse?entry...
In order to display the form you use
...ft5Ty/viewform?usp=pp_url&entry...
Regards!
Can we move a column in Google Spreadsheet for validating what has been scanned ?
It works well! Thank you so much!
Great video, How do you auto update the form if you keep adding new products in google sheet?
Hello!
Here is a video where I do that
th-cam.com/video/k0RS4oPzy80/w-d-xo.html
Regards!
how can I contact with you if I have a query
Best way is through the patreon page
Or you can write to practical.sheets@gmail.com
Kind Regards
It works!
However after I created another multiple choice, it didn't work. Do you know how to solve it?
Thanks in advance!
Really thank U
I followed your instruction. I am still getting stuck at 11:56. I spend 5 hours to figure out how to do QR code. It is not easy.
You are right there is a bug with the google chart api.
You need to change it with an alternative such as this
="quickchart.io/qr?text="&ENCODEURL(A2)
Kind Regards
@@practicalsheets Let me try. I will let you know if it fix. Thank you
Thks, very usefull
ATTENTION: (9/4/24): The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com
Here is an example of its use
=image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2))
Not sure i’m putting it in correctly cause it’s not working
what about size?
@@dvncfilm did you get it to work?
@@petecandelario1700 yes
@@petecandelario1700 but I can't control the size of QR codes in Google Sheet
Hi! I've gotten to the stage where I'm editing the URL To Input to add &A2 at the end.
But when I try and test scan the new QR code instead of opening the link to the Google Form it says "Note:" and tries to make a note that has the link and the word "guitar" (I'm using a Samsung Galaxy Note 10 Plus)
I checked I have all my quotation marks etc in the right places. Any suggestions?
Nevermind - apparently it is my phone. When I use a different QR scanner it works
Excellent! Glad you figured it out
Regards!
If I have more than 1000 items, can I find/go to the specific cell (for example A556) by scanning QR code?
Yes I think so
You stand in the cell, right click get the link for the cell, and this is what you will put in the QR Code. I wouldn´t know how to make it dynamic though
Regards!
IF my product already has the line QR how to linked with google form?
Hmmm, I´m not sure if it can be done with Forms
Maybe better try appsheet instead?
Regards!
I tried the formula but I don't now why it's not showing the Qr code , always blank
You are right
The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com
Here is an example of its use
=image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2))
Regards!
My google sheets didn’t generate a QR picture and I did everything you did. How do I fix it?
Did you solve?
Kind Regards
@@practicalsheets facing the same issue but after few refreshes of page its working
@@Openupmind Thanks for sharing!
I am having a hard time creating the QR code
Mine is showing an error
Not working for me.. 😢
Hello!
Any specific error?
Regards!
Is anyone else still unable to get a QR code?
Unfortunately Google API is not working anymore
You can try any of these 3 alternatives
="api.qrserver.com/v1/create-qr-code/?data="&B11
="qrcode.tec-it.com/API/QRCode?data="&B11
="quickchart.io/qr?text="B11
Kind Regards
@@practicalsheets yeah thanks. I got it. But how unusual for Google to stop services
@@dalecollins-smith3551 It is unusual. No press release or anything
Kind Regards
how to get link