Can you scan a barcode into a Google Sheet?
Рет қаралды 317,043
5 жыл бұрынYES, Of course, you can.
(saved you the click)
NO WAIT, please watch and see how we did it.
We'll be happy to reveal how the magic trick is done. Watch how you can have multiple app users scan barcodes into the same Google Sheet at the same time!
There are several business cases that can take advantage of barcode scanning into a Google Sheet; the more obvious are inventory and asset tracking. Other solutions are event attendance and even home work check in for educators.
Scan to Web from Berry Wing
Apple devices
apps.apple.com/us/app/barcode...
Android devices
play.google.com/store/apps/de...
@themobilesalesengineer5688 3 жыл бұрын
Here is Chapter Two! Check in and Check out using Google Sheets. kzfaq.info/get/bejne/Zrakobmn17y4c40.html
@ganeshagrawal608 2 жыл бұрын
I ave wasted hours looking for an official google plugin or extension, there is nothing available except you genius. I haven't yet checked if this works for me(just saw the video, and it's exactly what I needed). Great job gentleman.
@AngelLopez-iv5jv Жыл бұрын
I don’t even know what to say. This 80% of what I what I was looking for. Thank you!!!
@TimAir. 4 жыл бұрын
Thankyou SOOOO much!!! This has saved me an incredible amount of time when scanning in and out inventory!! life saver!
@themobilesalesengineer5688 4 жыл бұрын
Happy to hear that!
@bhuplink 3 жыл бұрын
Would love if unique entry's could be created viz. The sheet enters and identifies scan from a Mobile A and scan from a Mobile B differently in the same Google sheet.
@muhdismadi1101 2 жыл бұрын
that attempt form submit was so brief. I was going back and forth what to input.
@muhdismadi1101 2 жыл бұрын
but i got it in the end.
@brandymcclain1061 2 жыл бұрын
Teacher: how do I get name of student into Google sheet without them having to enter their name? Bathroom tracker. Want to give specific qr code assigned as sticker so they can stick it to agenda book. I want the name and time & date stamp without typing anything into a form. Want each code specific to each kid. I scan, they go to bathroom. How can I do this?
@georgeer5994 3 жыл бұрын
Thank you so much, it works wonderfully.
@mohammadizzuddin1976 2 жыл бұрын
this is very usefull to check existing item in your inventory
@gianclaudiobarletta9861 4 жыл бұрын
Hi there, thank you for this great video! I was looking to a sort of fridge food management file and it worked! Starting from the sheet created by the APP, I created a new one which takes the information from there and then......no more expired food!
@εγεω Жыл бұрын
Hello interesting claim. You can extract expiring dates from the barcodes? Really nice option if you have that ease.
@anandmallikarjunan7775 Жыл бұрын
An excellent presentation Sir. Wish you good luck Sir.
@SessAurea2 Жыл бұрын
Hello! Thanks for your video, I just have a question, how can I scan it and make an out instead of an in ? Thank you 🙏🏻
@souravraj 9 ай бұрын
Thank a lot i was looking at a paid subcription app to do this. Thanks for free solution
@magentag2492 4 жыл бұрын
Hi this video is great ! I have this all working but would like to know how to arrange the sheet so that when scanning the barcode it will enter the qty of the item please ?
@eddie_Za 5 ай бұрын
when we scanning 1 barcade, can the info on the barcode fill into 2 or more column, for example 1 barcode scan will fill name and class column?
@TikidataAnalytics 6 ай бұрын
Assume there are multiple fields in Google Form, which field, would Berrywing fills when we scan a Barcode?
@lowndescountysheriffsoffic5679 2 жыл бұрын
I am wanting to use this to issue out equipment/uniforms to employees. There are times I may have to be issuing equipment out to several employees at a time. Do you have any suggestions how to streamline the work flow? Meaning I want to make sure who I am issuing items out to.
@ristanbo 2 ай бұрын
Hi, great presentation. Does the App support scanning 2 barcodes, for example, scan a user tag, then an item or action. Thanks
@chrisedmonds8992 Жыл бұрын
Is it possible to add a picture of the equipment in the adjacent cell next to the barcode?
@nelbamartinez2310 Жыл бұрын
Thanks for your videos ! I am interested in getting your apps , I would like to know. Is there any way that when scanning each product it shows an image? Thanks
@tsekokhumalo3042 2 жыл бұрын
Thank you looking forward to more information
@yvonneholden8759 3 жыл бұрын
How do I create this showing stock levels and peoples name who has taken the items out of the stores. And the items when they are replenished using the smartphone device.
@bonniesoonosberger6765 3 жыл бұрын
what qr scanning application are you using?
@Teleman01 3 жыл бұрын
Do you know of a way to be able to scan a QR code of an individual item, then in Google sheets it just checks off a check box of that item. Basically I want to be able to scan items, and those items be in a checklist in Google sheets. When I scan the item, It puts a check mark showing that I scanned it. Thanks!
@jumjum517 3 ай бұрын
Hi I'm wondering how to do the output of this, so instead of adding new items it removes them
@myheartbeat6270 2 жыл бұрын
is there any possible way to scan the any receipt and captured the price and directly go to the sheet?
@mariannehislop5158 Жыл бұрын
How do you scan existing codes into sheets. I have pre-printed sheets of barcodes with our logos, so I don't want to generate a code. I would like to scan the code and create an asset for that code. Eg: scan a barcode, populate the asset details and save to sheets.
@eddie_Za 5 ай бұрын
Nice.. really basic. Thank you
@horaciocastle1998 2 жыл бұрын
Hi, I don't understand how scanning works. You open the form, suppose there are many fields, and only one is data from QR code. The cursor enters the Barcode textbox and... what then? how do you trigger the scanning app to start looking for codes? and what app is that? Thanks
@jeffhacker2255 Жыл бұрын
What is the site you use to generate the barcodes?
@user-ps8gh4fi5l Жыл бұрын
Hello, amazing video!!! However, I have a doubt: Is it possible after clearing the answers registered through the form, that the new entries begin to be registered again in the initial fields again?
@leandrikos2606 2 жыл бұрын
Hallo. Our learners have barcodes on their textbooks. Is it possible to first scan the learners' barcode, and then the barcodes of their textbooks? So that in the Sheet I have the learner name and the textbooks they have (not just a list of 300 textbooks, not knowing which book goes with which learner).
@onesupremelife 4 жыл бұрын
Subbed! Keep up the awesome content!
@themobilesalesengineer5688 4 жыл бұрын
Thank you!
@davicito254 2 жыл бұрын
Very well. I just need it to allow me to add 2 additional fields: Username and amount.
@hughwhinnery7630 2 жыл бұрын
When we scan the barcode into Google sheets, the spreadsheet goes to the next row in the same column. How do we get it to go to the next column in the same row?
@8865552 3 жыл бұрын
Hello. I manage a small consignment shop. Do you think it would be possible to use Google sheets and QR codes to automatically calculate the total of a customer's purchase? I am hoping to scan each item's unique QR code to extract pricing information from a Google sheets doc.
@justyasier 4 жыл бұрын
Thank you sir!
@mahmudin9014 2 жыл бұрын
Why Not support to my tablet on android 10 version?
@bonniesoonosberger6765 3 жыл бұрын
what is the qr scan application which you are using? i have 2 qr applications downloaded and I cannot paste the URL into the application setting so that when I scan the qr code to update the google form
@anaklokal5530 2 жыл бұрын
how to record minus stock by scanning the same barcode? please answer
@user-ov9pg6gi5d Жыл бұрын
Fantastic video -- exactly what I needed! Unfortunately hit a glitch when I tried it myself. The "scan to web" app that you show is not working, and its reviews say it has been broken for a few months. Do you have a recommended alternative app for "scan to web/google/whatever"? Thank you!
@stacyscott1378 3 жыл бұрын
Very informative...thanks
@napieboyz91 4 жыл бұрын
thanks, i want ask you, it is free version or has limited scan or limited time for free user?
@MarcoMorselli-d7o 26 күн бұрын
So goood. Is there a simple way to do the same using a windows tablet?
@myriad860 3 жыл бұрын
you are amazing thank you!
@ayadgabbar3086 4 жыл бұрын
can i make a full google form with par code on it
@fabianperez3095 3 жыл бұрын
Great video !!! Thanks so much it really helps.
@themobilesalesengineer5688 3 жыл бұрын
Glad to hear it!
@wonglinghao3622 3 жыл бұрын
Is there any way to scan n safe directly into smartphone
@bronzevillecomics2581 2 жыл бұрын
Which app did you use? I have iphone.
@jlcarr8836 2 жыл бұрын
Gracias , muy bueno el video.... Thank you......
@lorenzovdistefano 4 жыл бұрын
Hello is there a way to prevent duplicate barcodes to be scanned?
@drpanthula 9 ай бұрын
Its nice video, I want to know which app you configure the QR code Thanks in Advace
@ismailmarijani1549 Жыл бұрын
from 2:23 on wards, you left me behind, how do you configure the app, where do I access those settings? kindly help
@babuedits 4 жыл бұрын
thank you so much may god bless you
@zunkman1 Жыл бұрын
Tried to follow along, but you have updated your app and now the instructions don't match up. Can you please update the video so it matches the current version of your app? Looks promising!
@foodkida5306 9 ай бұрын
Very well try to execute this idea. I have used this to scan more than 200 barcodes but 50% of time it records incorrect number. This may occur due to hand moment.
@FaizalHafiz 5 жыл бұрын
You really save me! Thank you
@themobilesalesengineer5688 5 жыл бұрын
Fantastic! Glad we could help you.
@hpkeong Жыл бұрын
Hi sir. It is easy to make Google form but only with manual data entry or drop down. I don't understand how can you use qr scanner in Mobile to scan and enter data automatically. I watched many times but still cannot understand how did you get it scanned. Please guide me thanks so much.
@user-nj7ju3pp2w Жыл бұрын
Hello, I like your application, however I have a problem because when I want to scan continuously the following message appears "No field to set the barcode result was found on this web page" I don't know how to do it. My goal is to scan continuously so that my answer is sent to a google form, then I could use the data on a google sheet. Is there a way to fix this? Or should I make a direct link with the google sheet? If yes how can I do this?
@chasingwhitelines 4 ай бұрын
So I started using the scanner and 9 scans in and the google sheets is not updating! What did I do wrong?
@riiz87 Ай бұрын
What s the android app you used?
@MAYONNAISEMOOSE 6 ай бұрын
Hello i want to be able to scan a barcode more than once, but not let google sheets create seperate entries for the same barcode. But to refer to a pre existing one
@meataddicted 3 жыл бұрын
Wow this is what I want. Thank you sir, one quick question how can I continuously scan barcodes with google form? every time I have to click the submit button. I found setting menu but seems like it doesn't work. be safe ;) Sorry, I think I make you confused. Your automatic submit function greatly works well. However it will be super super great if I can have a function like auto click the "Submit another response"
@gimjuuu6352 3 жыл бұрын
thank you so much! you save me
@tsekokhumalo3042 2 жыл бұрын
You nailed it
@attendantrecord1508 Жыл бұрын
HI, WHAT A BRIILIANT WAY.. I ALSO DOING THE SAME PROJECT.. BUT MY EXPECTATION IS THE GOOGLE FORM WILL BE AUTO SUBMIT AND RECORD AUTO INTO THE SPREADSHEET.. ONLY BUTTON " SUBMIT ANOTHER RESPOSE" NEED TO PRESS. ANY IDEAS?
@so_gerger Ай бұрын
You are life saver!
@david_d178 4 жыл бұрын
Great video thanks so much it really helps. How do I print out a barcode that I scanned to the sheet?
@berrywingllc1523 4 жыл бұрын
Sure thing. You can create them one at a time with our site. Or follow the instructions further down the page to create them in Google Sheets. berrywing.com/barcode/ kzfaq.info/get/bejne/hJudf7p6u9Gzqmg.html
@nitingr8test 2 жыл бұрын
Hi, Is this app free to use or does it have any restrictions?
@QRANIME 3 жыл бұрын
thank you so much
@akothondiek8155 2 жыл бұрын
Hi, thanks for this great video. What if I want only one question to scan a barcode but the rest of the questions to be populated manually?
@themobilesalesengineer5688 2 жыл бұрын
Yes, within the app there is a setting for after barcode scan; set it to do nothing. Then manual enter or barcode scan in the other fields. Tap submit manually to save your entries.
@justinfontes3303 5 жыл бұрын
How can you make is so you would enter the quantity of the barcode? Like scan then type 20 for the number of items as an example. This would be useful for inventory counting year end.
@themobilesalesengineer5688 5 жыл бұрын
Hello Justin. Not that I know of in Google Forms. They are pretty basic. Scan to Web works with all websites. A custom website could be made that does the total. Otherwise you'll have to group and sum in Google Sheets after scanning. webapps.stackexchange.com/questions/25798/sum-values-with-same-name
@hershekissed 3 жыл бұрын
@@themobilesalesengineer5688 couldn't he make another page that totals the scans by using a formula?
@hosonfire 3 жыл бұрын
I own a cabinet manufacturing business. Is it possible to setup to scan a code for an operation (cutting/ assembly/ finishing/ packing) and then scan the product code? For example, if I make a QR code for a cabinet and I want my employee to scan the cabinet code plus a code for assembly to update a spreadsheet showing that cabinet #4 has been assembled. Is this possible?
@themobilesalesengineer5688 3 жыл бұрын
I think so. Make a form with say 3 fields; who, product, and job task. Scan the product code. And then require who did the task. You could make a barcode for the job or make a dropdown list in Google Forms. The nice thing is there will be a date/time stamp automatically added to the spreadsheet.
@HuaLua 2 жыл бұрын
Thanks you so much
@samgardening972 2 жыл бұрын
thank you ...so much
@astigren01 3 жыл бұрын
big help! thanks,, one thing,, can the app be automatically set home after submitting the g.form? so that there's no need to press the Home button..
@themobilesalesengineer5688 3 жыл бұрын
Hi! We have a custom JavaScript after scan that will do this for you. Just use the Scan to Configure barcode here. scantoweb.net/google-forms-and-continuous-scanning/
@GIOVANNYQUIA 4 жыл бұрын
Thanks, im working with my students for review hia task. Perhaps your could be improve this apk with this focus.!
@themobilesalesengineer5688 4 жыл бұрын
Hi! Tap the yellow 1D barcode button to change barcode scanner types. Hope that helps improve preformance!
@mishathecarman4231 2 жыл бұрын
When you scan barcode, can Google sheet search against already inputed part numbers ? For example when I receive automotive parts I need to know if I received all the parts that I ordered. Thank you.
@themobilesalesengineer5688 2 жыл бұрын
Hi! You can do this with a VLOOKUP function. We have another video that covers this in the second half. kzfaq.info/get/bejne/hdqWmM2at7maaWQ.html
@armandolios4561 Жыл бұрын
This was a life saver hack. Thank you so much.
@themobilesalesengineer5688 Жыл бұрын
Glad you found it useful. A few days later, how is it going?
@armandolios4561 Жыл бұрын
@@themobilesalesengineer5688 This solution has been great so far, I'm trying to find some work arounds for better use in my application (taxes).
@ESP95 2 жыл бұрын
This is exactly what I was looking for. I want to use this to pass the attendance in my school where we don't have many resources but we do have Internet. I would have to create 40 forms with their respective QR to have the information of each student, is that possible? thanks for your help and greetings from Chile.
@rubenusina2207 Жыл бұрын
Busco lo mismo ,cómo lo hiciste?
@Angel-sd3in 6 ай бұрын
You sir are amazing
@rickavina14 4 жыл бұрын
Wonderful app! Q. So instead of setting the "home page" to one particular form, is there a way to allow the user to select from multiple forms? For example, the user can choose the 'barcode reader' form now, but later they want to use the app to scan into a totally different form. Thx!
@themobilesalesengineer5688 4 жыл бұрын
Yep, create a Google Site. This will serve as the app home page. You can then put links on the Google Site to your different forms and other pages if you'd like.
@sonicheavengaze6993 4 жыл бұрын
@@themobilesalesengineer5688 Thank you! Is this app also compatible with Microsoft Forms?
@terrynoble984 4 жыл бұрын
Awesome Video. I have only one question, what would I have to do to scan different bar codes and have them entered on the same sheet? Say I wanted to perform nightly rounds in the facility and have 10 different locations to scan confirming I was there what would I have to do to make this work and update on the same sheet? With area locations as well? Thanks in advance!
@themobilesalesengineer5688 4 жыл бұрын
Just share the same form. Any entries in the form get saved to the same Google Sheet. Even if 100 people are using the same URL to the Google Form. It might help to include a "Who are you?" field asking for person's name so you have a record for each entry.
@nurniza4907 Жыл бұрын
how to make QR code to run the LED light
@chiranthagamage4271 5 жыл бұрын
This is good i tryed it thats work for me and i need to 1 help i need to auto enter barcode number with item model how can i fix it
@themobilesalesengineer5688 5 жыл бұрын
Google Forms are good for 1 way collecting barcode scans. It will not return any lookup result after scanning a barcode. Email us, there are other options if I understood your question correctly. softwaresupport@berrywing.com
@susanavieira2396 3 жыл бұрын
Hello, thank you for the great video. My problem is that the app “scan to web” is paid.
@themobilesalesengineer5688 3 жыл бұрын
Hello Susana, yes Scan to Web requires a payment after the trial period is over. If this is a hardship, you are working with a non-profit and/or school system; please email us. We can work on a fair pricing arrangement. softwaresupport@berrywing.com
@sanikalande3694 3 жыл бұрын
how long this will work ..
@patelnirajkumar1 4 жыл бұрын
Hello there, I love this concept. I may be late to explore this but I would like to use it to capture my customers data. While offering them to register for warranty using a QR Code which will be unique (if possible) for each different model that we sell. So Customer Receive the product, we insert a small card with QR Code and ask them to scan it to register for 1 year warranty. And ask them to provide their Order Number and Email address. Is this possible? how it would work? If you can help me with this, that would be a game-changer.
@berrywingllc1523 4 жыл бұрын
Hi Niraj, certainly we can help with that. Contact our sales team, we can cover the requirements and pricing. sales@berrywing.com
@kidstuffsale 3 жыл бұрын
This is awesome! I need help, is there a way to create a form for each person scanning, and a break per order? I need 30 people to scan 50 orders each to make sure all items (barcodes) are accounted for.
@themobilesalesengineer5688 3 жыл бұрын
With Google Forms you are limited. Could you add a dropdown list with the people's name. Or provide them a barcode; so you scan the order # and then the person?
@hotfiya321 2 жыл бұрын
It doesn't work as well for android, but definitely works!
@melmarshall8176 4 жыл бұрын
Hi, I don’t know what I’m doing wrong, the responses don’t seem to pick up my text. I get a time stamp but no text. Short answer and text are selected on the Google form. Any help will be much appreciated.
@themobilesalesengineer5688 4 жыл бұрын
We are sorry to report there is an issue right now with how Scan to Web integrates with Google Forms. We are working on the issue. Google Drive has made several updates and changes to Google Forms. These changes are preventing Scan to Web from working properly. We expect to have an update for both Android and iOS ready early next week that corrects the problem. Sorry you are experiencing this. It was a surprise for us as well. (replied July 2, 2020)
@brcleaningcompany2566 4 жыл бұрын
Is there a possible way to bring up product into not just the barcode number,,, for example if i scan a book into excel, how can i get it to bring up the book name and info and not just the ISBN numbers,,,,
@themobilesalesengineer5688 4 жыл бұрын
Google Forms are one way only (at the moment). So you can only record the barcode number. It is possible using VLOOKUP to compare the barcode scanned spreadsheet against a master list to get the book name. Skip ahead to the second part of this video to see how VLOOKUP works. kzfaq.info/get/bejne/hdqWmM2at7maaWQ.html
@actiondoorslubbock 4 жыл бұрын
Where do you go to make these awesome QR codes that are loaded with the right information?
@themobilesalesengineer5688 4 жыл бұрын
Here is our site with a barcode generator to create one at a time. berrywing.com/barcode/ Scroll down on the page for instructions on how to create many of them with Google Sheets. If you need help, email softwaresupport@berrywing.com
@winefoodmart5719 4 жыл бұрын
Hello, I am a small business owner and have developed a google sheet to calculate inventory and sales. However, right now we are having to enter data manually. I'd like to pick your brain to see if you can help me create a setup where the scanned barcode can be fed automatically into my existing worksheet in google sheets... I can manage the rest I think. can you help?
@berrywingllc1523 4 жыл бұрын
Hello, please email us. We do our best support via email because we can include instructions and screen shots. softwaresupport@berrywing.com
@cackleberryfarm4598 4 жыл бұрын
HI Berry. Question: I noticed in the video by scanning the only thing that goes into the google sheets is the barcode number. Is there a way to have the barcode number, and then in the next column the name of the product that got scanned in? AND-- we want to use it for the inventory of our product cases wen they get packaged. But also, when we load the truck we'd like to scan the QR Code on the box and have it take it OUT of our inventory. Is there an easy way to both the input and also the output? Thank you, Rick
@berrywingllc1523 4 жыл бұрын
Not that we know of. Google Forms are very simple and one way only. Logic to return a result is not available. You'll need an inventory system or other web server application to do what you describe. That said, once you scan in barcodes with a Google Form and Scan to Web. you can do lookup, counts, inventory, etc with the Google Sheet. But only after you have done the scanning.
@cackleberryfarm4598 4 жыл бұрын
@@berrywingllc1523 Okay. SOOOOO... let's say we scan in a case with a barcode and that goes to the Google Sheets in a column comes up the barcode number. IS IT POSSIBLE in Google Sheets for the next column to the right to have a IF/THEN string that would state: IF B2=12345 THEN "Spring Mix"; If B2=12344 THEN "Spinach" And so on...
@berrywingllc1523 4 жыл бұрын
@@cackleberryfarm4598 Hi there, I understand now. Yes there is. You want to use a VLOOKUP function. It is too complicated to explain in a KZfaq comment. There are plenty of instructional guides out there on how to use the VLOOKUP correctly in Google Sheets. Or email us; softwaresupport@berrywing.com Watch the second half of this video for a demonstration. kzfaq.info/get/bejne/hdqWmM2at7maaWQ.html
@steved.5444 4 жыл бұрын
First off, thank you for this video! Great work!! Secondly, when I scan a code, it will not submit to the spreadsheet. I have to get out of the scanner part and hit "submit" then it will load to the spreadsheet. What am I doing wrong?
@themobilesalesengineer5688 4 жыл бұрын
Hello and thank you. Not sure about the issue. In the app settings, there is the after scan setting; Do Nothing or Submit after scan. What is that set to? Feel free to email for more tech support; softwaresupport@berrywing.com
@steved.5444 4 жыл бұрын
@@themobilesalesengineer5688 Thank you. That was it. I had it on "tab to next field"
@ednaldosouza3691 4 жыл бұрын
good morning I did the same procedures in the video but the message does not arrive in the spreadsheet
@berrywingllc1523 4 жыл бұрын
Sorry to hear that. Email us a softwaresupport@berrywing.com Share details of what happened and a clear picture of the barcode for us to test scan.
@manueldejesusarechigabarra881 4 жыл бұрын
i hace a quetion. When i scan de barcode doesnt appear the info about de QR (name of the barcode) in teh sheet
@berrywingllc1523 4 жыл бұрын
The app only returns the content of the QR Code. What other information are you expecting? Please email us at softwaresupport@berrywing.com We'll do our best to help.
@jma1014 3 жыл бұрын
How can I use this to track inventory that is checked in and out
@themobilesalesengineer5688 3 жыл бұрын
That is a popular request. We'll make a video blog about how to do so. Email me and I will send you the procedure so you can test it for us. softwaresupport@berrywing.com
@talibabbas4417 3 жыл бұрын
Thanks for the video, but the responses are not being captured in google from even after scanning the qr code.
@themobilesalesengineer5688 3 жыл бұрын
Hello Talib, Google Forms always show a Thank you or Your Response has been submitted page. This page has no text fields so there is no where for the barcode scan to go. You need to tap the Submit another response link on the page to go back and enter your form again. For more information, see this article. scantoweb.net/google-forms-and-continuous-scanning/
POSCatch
Рет қаралды 1,1 МЛН
TEC-IT Software
Рет қаралды 189 М.
Shafi Kandoth
Рет қаралды 157 М.
Морозовы
Рет қаралды 4,5 МЛН