Inventory with QR Codes in Google Sheets and Google Forms
In this project we will learn how to use QR codes with Google Forms and Google Sheets to easily input new items to your inventory system
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Пікірлер: 90
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))
@petecandelario1700
2 ай бұрын
Not sure i’m putting it in correctly cause it’s not working
@dvncfilm
2 ай бұрын
what about size?
@petecandelario1700
2 ай бұрын
@@dvncfilm did you get it to work?
@dvncfilm
2 ай бұрын
@@petecandelario1700 yes
@dvncfilm
2 ай бұрын
@@petecandelario1700 but I can't control the size of QR codes in Google Sheet
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
@mrdimmu
8 ай бұрын
Same, I am guessing still has not put one up, can't see on channel
It works well! Thank you so much!
Thank you….. nice solution and great explanation
Thanks very much. that's very well explained and followed. Would definitely appreciate part 2 of video
@practicalsheets
10 ай бұрын
Thanks for the words Any suggestions for Pt 2? Regards!
Fantastic, thank you!
@practicalsheets
10 ай бұрын
Thank you for commenting!
Bro muchas gracias por el video!! Te ganaste un seguidor!!
@practicalsheets
10 ай бұрын
Mil gracias Gabriel!
Thank you! This was a great tutorial.
@practicalsheets
8 ай бұрын
Thank you!
Thank you!I found it is practical
@practicalsheets
Жыл бұрын
Yes! I´m glad I´m sticking with the title "Practical Sheets" ;) Really, thanks for the message! Regards!
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. 🎄🎄🎄
@practicalsheets
Күн бұрын
Thank you! And sorry for answering almost at the next christmas ;)
Thank you for the video.. It is very clear..
@practicalsheets
8 ай бұрын
Thank you for commenting!
Really thank U
This is really helpful. thank you
@practicalsheets
8 ай бұрын
Thank you for commenting!
Thks, very usefull
you're the man
@practicalsheets
3 ай бұрын
🙏
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?
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
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
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
Can we move a column in Google Spreadsheet for validating what has been scanned ?
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?
It works! However after I created another multiple choice, it didn't work. Do you know how to solve it? Thanks in advance!
Great video, How do you auto update the form if you keep adding new products in google sheet?
@practicalsheets
Жыл бұрын
Hello! Here is a video where I do that kzread.info/dash/bejne/nWSGtZaogN3faJM.html 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)?
@practicalsheets
7 ай бұрын
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!
@user-nt9ul8jh6j
7 ай бұрын
Thank you for your response!
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
@practicalsheets
Жыл бұрын
Hello! I´m not sure There may be. I´ll look into it 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 ?
@practicalsheets
2 ай бұрын
It should be one or the other. But you still have to have the question ecause you need the id Kind Regards
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.
@practicalsheets
Ай бұрын
Hmmm I think it could work You could set up the countif only for that particular email Kind Regards
thanks this is awesome but can it work with normal barcode 128 not just qr
@practicalsheets
Ай бұрын
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
How can you make it so that you can scan in and scan out inventory and have the quantity updated automatically?
@Rockingwithms.R
10 ай бұрын
That’s what I want 😅
@mehoolshrestha5891
9 ай бұрын
Please do a video in this! Would be great!!
@revosven
2 ай бұрын
Plus one for this request too.
@latenttweet
2 ай бұрын
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.
@practicalsheets
7 ай бұрын
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!
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 .. ?
@practicalsheets
2 ай бұрын
Hi That's the beauty of the QR. As you say, you may add al the amount of information you want Kind Regards
@renaudgg
2 ай бұрын
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
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)
@practicalsheets
Жыл бұрын
we could add a field in the form of quantity so you could add a lot of the same product 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...
@practicalsheets
7 ай бұрын
Hmmm. You would have to open the form so you could manually write the location 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.
@practicalsheets
7 ай бұрын
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!
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.
@practicalsheets
Күн бұрын
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 I have more than 1000 items, can I find/go to the specific cell (for example A556) by scanning QR code?
@practicalsheets
Жыл бұрын
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!
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?
@DaleyKreations
10 ай бұрын
Nevermind - apparently it is my phone. When I use a different QR scanner it works
@practicalsheets
10 ай бұрын
Excellent! Glad you figured it out Regards!
IF my product already has the line QR how to linked with google form?
@practicalsheets
10 ай бұрын
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
@practicalsheets
2 ай бұрын
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!
Mine is showing an error
My google sheets didn’t generate a QR picture and I did everything you did. How do I fix it?
@practicalsheets
3 ай бұрын
Did you solve? Kind Regards
@Openupmind
3 ай бұрын
@@practicalsheets facing the same issue but after few refreshes of page its working
@practicalsheets
2 ай бұрын
@@Openupmind Thanks for sharing!
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.
@practicalsheets
Күн бұрын
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
@FunLearningPiano
Күн бұрын
@@practicalsheets Let me try. I will let you know if it fix. Thank you
Not working for me.. 😢
@practicalsheets
10 ай бұрын
Hello! Any specific error? Regards!
how to get link