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.
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?
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 ?
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!
This is great - thank you for sharing! Is there a way to enter multiple quantities of the one product (say grocery items) or do you have to scan every product to get it into google sheets?
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
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!
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
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.
@@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...
@@cackleberryfarm4598 Hi there, I understand now. Yes there is. You want to use a VLOOKUP function. It is too complicated to explain in a RUclips 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. ruclips.net/video/OtfejiRS690/видео.html
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.
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).
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?
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/
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!
No you shouldn't have to. A Google Form is a way of creating new rows in a spreadsheet. So 1 form to 1 spreadsheet is the best way to think of it. For the 300 items would you need 300 spreadsheets for any reason? Just wanted to make sure I was not missing something.
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.
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
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
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?
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
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.
@@themobilesalesengineer5688 Thanks for your reply, but what I ment is if there was a way to use the options at the same time?, that de app would submit the answer and then automatically append a URL.
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.
Yes the app is free to test with 50 barcode scans. You can then purchase in Google Play or the Apple app store. We also offer Enterprise and Non-Profit pricing. Contact our sales team for more information. Are you a web developer? We can also offer assistance during your design process. berrywing.com/white-label/ scantoweb.net/unlimited-use-subscription/
The app looks interesting. It appears to be able to write to any single field web form? It appears to add a date stamp as part of the text it sends? Is there an opportunity to also add the last 4 digits of the phone number, or for it to remember some entered code that it repeats every time it scans a barcode? In conjunction with a timestamp that would permit writing the barcode into a web application then matching the entry with the application that person was using at the time. How much does the app cost?
Great questions! They fit your user name "Ron_the_Skeptic". Yes, scan to text boxes on a web page. You can scan to specific ones, or use a feature "Tab to Next Field" which will advance the barcode scanner automatically to the next available field. The date and time stamps are a feature of Google Sheets and the Google Form. Unfortunately no, the app cannot get the device phone number. You'd need to add a "name" field to the Google Form to record who did the scanning. These are limitations of using a Google Form. Having a dedicated website with a login and then a web page to scan barcodes into will solve your requests.
@@themobilesalesengineer5688, thank you for your reply. I see you did not answer the question of price; I assume that will become clear if I install the app. I have one more question: Is the Internet required or will it work with the phone's data turned off and Wi-Fi connected to the subnet provided by the router if the server and browsers are all on that same subnet?
@@Ron_the_Skeptic Yes it is best to check in the app so you see the correct regional pricing. The app is free to trial so you can confirm it will work for you before needing to make a purchase. Yes the app will open web pages served on a local intranet, even protected behind a firewall. This is a common use of Scan to Web by businesses & non-profits of all sizes.
@@themobilesalesengineer5688, thank you, again, for your reply. The application I'm writing will eventually be connected to the Internet, but for the moment, it is isolated in my lab. I spent some time this afternoon writing a web page and cgi program to write a scan to a database table. Tomorrow I will make a slight change to a router and see if I can get it all to work. Then I will know if I really understand.
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
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.
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?
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"
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?
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!
Yes, there is a configuration for the app that will do this. The home page needs to be the Google Form. Instructions here "Google Forms and Continuous Scanning" scantoweb.net/google-forms-and-continuous-scanning/
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?
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.
This has helped me somewhat, but I have QR codes from a sight that my students use. I wanted to see if there is a way to use those barcodes for them to sign into school with, i don't want to create 400 individual QR codes... any suggestions?
Sorry it took a while to reply. What are the contents of the QR Codes? If it is just an ID #, you'll need to cross reference with a VLOOKUP in Google Sheets.
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.
You skipped an entire step? What app are you using to connect the form and HOW DO YOU set that up and use it? I have an apple and its giving me a Java script error?
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.
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?
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.
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.
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?
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/
Hello. I want to do this for an event whereby when I check people in - their name and credentials appear on the spreadsheet instead of a random number. Can I do that? If so can you help me?
Sure, first Try the Check in / Check out video to see if that will help. ruclips.net/video/0PtnVvrVTCY/видео.html Otherwise, you'll need to use a VLOOKUP formula to fill in the name columns. Lastly, could you just add the name into the barcode? You can create QR Codes here berrywing.com/barcode.
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
Hello and thak you for your effort. Can this app scan barcodes instead of qr codes ? I try to scan bar codes but it doesn't work. Thank you in advance. Nick
Hello! Yes it can. Android or iOS? On Android tap the yellow button on the top of the barcode scanning screen and try again. Reach out to softwaresupport@berrywing.com Send clear pictures of the barcodes you are scanning. Sometimes it can happen that barcodes are printed wrong or have been cut off. There is no way to tell by eye.
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.
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
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. An update will be ready on or before July 1st, 2020
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,,,,
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. ruclips.net/video/OtfejiRS690/видео.html
Sure, give these links a try. berrywing.com/products/ berrywing.com/scan-to-web-app/ play.google.com/store/apps/details?id=com.berrywing.scantoweb&hl=en
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Here is Chapter Two!
Check in and Check out using Google Sheets.
ruclips.net/video/0PtnVvrVTCY/видео.html
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.
Which app did you use? I have iphone.
Thankyou SOOOO much!!! This has saved me an incredible amount of time when scanning in and out inventory!! life saver!
Happy to hear that!
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?
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 ?
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?
what qr scanning application are you using?
from 2:23 on wards, you left me behind, how do you configure the app, where do I access those settings? kindly help
I don’t even know what to say. This 80% of what I what I was looking for. Thank you!!!
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.
What s the android app you used?
that attempt form submit was so brief. I was going back and forth what to input.
but i got it in the end.
This is great - thank you for sharing! Is there a way to enter multiple quantities of the one product (say grocery items) or do you have to scan every product to get it into google sheets?
Hi, great presentation. Does the App support scanning 2 barcodes, for example, scan a user tag, then an item or action. Thanks
Assume there are multiple fields in Google Form, which field, would Berrywing fills when we scan a Barcode?
Is it possible to add a picture of the equipment in the adjacent cell next to the barcode?
is there any possible way to scan the any receipt and captured the price and directly go to the sheet?
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
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!
This was a life saver hack.
Thank you so much.
Glad you found it useful. A few days later, how is it going?
@@themobilesalesengineer5688 This solution has been great so far, I'm trying to find some work arounds for better use in my application (taxes).
What is the site you use to generate the barcodes?
Its nice video, I want to know which app you configure the QR code Thanks in Advace
So goood. Is there a simple way to do the same using a windows tablet?
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
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.
@@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...
@@cackleberryfarm4598 Hi there, I understand now. Yes there is. You want to use a VLOOKUP function. It is too complicated to explain in a RUclips 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.
ruclips.net/video/OtfejiRS690/видео.html
does it work when in offline?
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.
amazing, nice tutorial
Thank you!
Hi, Is this app free to use or does it have any restrictions?
Thank a lot i was looking at a paid subcription app to do this. Thanks for free solution
Hi I'm wondering how to do the output of this, so instead of adding new items it removes them
Sir Please tell the Android app name.
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).
Thank you for this wonderful information, in google sheets, is there to convert barcode to its actual text?
to convert the barcode number generated to its product name
So I started using the scanner and 9 scans in and the google sheets is not updating! What did I do wrong?
Is there any way to scan n safe directly into smartphone
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?
You really save me! Thank you
Fantastic! Glad we could help you.
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..
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/
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!
Good Evening... May I ask, if i have 300 items does it mean i have to create 300 google forms?
No you shouldn't have to. A Google Form is a way of creating new rows in a spreadsheet. So 1 form to 1 spreadsheet is the best way to think of it. For the 300 items would you need 300 spreadsheets for any reason? Just wanted to make sure I was not missing something.
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.
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
Great video !!! Thanks so much it really helps.
Glad to hear it!
Thank you looking forward to more information
An excellent presentation Sir. Wish you good luck Sir.
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
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?
this is very usefull to check existing item in your inventory
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 🙏🏻
Hello, thank you for the great video. My problem is that the app “scan to web” is paid.
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
how long this will work ..
At the 2:26 time mark .... you lost me. Up till that point fine. I do not understand "scan to Web"
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?
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.
how to record minus stock by scanning the same barcode? please answer
Is there a way to " attempt a form submit" and then "append a url"?.
Thanks.
Yes, the app has that feature among others in After scan. Such as submit, append the URL, or run Javascript. scantoweb.net/after-barcode-scan/
@@themobilesalesengineer5688 Thanks for your reply, but what I ment is if there was a way to use the options at the same time?, that de app would submit the answer and then automatically append a URL.
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.
Subbed! Keep up the awesome content!
Thank you!
Thank you so much, it works wonderfully.
Nice.. really basic. Thank you
it is free version or has limited scan or limited time for free user?
Yes the app is free to test with 50 barcode scans. You can then purchase in Google Play or the Apple app store. We also offer Enterprise and Non-Profit pricing. Contact our sales team for more information. Are you a web developer? We can also offer assistance during your design process.
berrywing.com/white-label/
scantoweb.net/unlimited-use-subscription/
The app looks interesting. It appears to be able to write to any single field web form? It appears to add a date stamp as part of the text it sends?
Is there an opportunity to also add the last 4 digits of the phone number, or for it to remember some entered code that it repeats every time it scans a barcode? In conjunction with a timestamp that would permit writing the barcode into a web application then matching the entry with the application that person was using at the time.
How much does the app cost?
Great questions! They fit your user name "Ron_the_Skeptic".
Yes, scan to text boxes on a web page. You can scan to specific ones, or use a feature "Tab to Next Field" which will advance the barcode scanner automatically to the next available field.
The date and time stamps are a feature of Google Sheets and the Google Form.
Unfortunately no, the app cannot get the device phone number. You'd need to add a "name" field to the Google Form to record who did the scanning.
These are limitations of using a Google Form. Having a dedicated website with a login and then a web page to scan barcodes into will solve your requests.
@@themobilesalesengineer5688, thank you for your reply. I see you did not answer the question of price; I assume that will become clear if I install the app. I have one more question: Is the Internet required or will it work with the phone's data turned off and Wi-Fi connected to the subnet provided by the router if the server and browsers are all on that same subnet?
@@Ron_the_Skeptic Yes it is best to check in the app so you see the correct regional pricing. The app is free to trial so you can confirm it will work for you before needing to make a purchase.
Yes the app will open web pages served on a local intranet, even protected behind a firewall. This is a common use of Scan to Web by businesses & non-profits of all sizes.
@@themobilesalesengineer5688, thank you, again, for your reply. The application I'm writing will eventually be connected to the Internet, but for the moment, it is isolated in my lab. I spent some time this afternoon writing a web page and cgi program to write a scan to a database table. Tomorrow I will make a slight change to a router and see if I can get it all to work. Then I will know if I really understand.
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
Gracias , muy bueno el video.... Thank you......
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.
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?
Why Not support to my tablet on android 10 version?
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"
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?
Hello, please email us. We do our best support via email because we can include instructions and screen shots.
softwaresupport@berrywing.com
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!
Is there a way to have the app jump straight into the scanner after clicking "submit another response"?
Yes, there is a configuration for the app that will do this. The home page needs to be the Google Form. Instructions here "Google Forms and Continuous Scanning" scantoweb.net/google-forms-and-continuous-scanning/
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?
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.
This has helped me somewhat, but I have QR codes from a sight that my students use. I wanted to see if there is a way to use those barcodes for them to sign into school with, i don't want to create 400 individual QR codes... any suggestions?
Sorry it took a while to reply. What are the contents of the QR Codes? If it is just an ID #, you'll need to cross reference with a VLOOKUP in Google Sheets.
ruclips.net/video/n01PvnFniX8/видео.html
Can you track inventory and the quantity?
wondering the same
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.
Hi! You can do this with a VLOOKUP function. We have another video that covers this in the second half. ruclips.net/video/OtfejiRS690/видео.html
You skipped an entire step? What app are you using to connect the form and HOW DO YOU set that up and use it? I have an apple and its giving me a Java script error?
Hello Erin, the scanning app is Scan to Web. scantoweb.net
What Java script error?
thanks, i want ask you, it is free version or has limited scan or limited time for free user?
Have you found free app for this?
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.
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?
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.
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.
Hello is there a way to prevent duplicate barcodes to be scanned?
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?
Did you find out how to do it?
Thanks for the video, but the responses are not being captured in google from even after scanning the qr code.
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/
Can i scan then entri other field using this??
Yes you can. Place the cursor in the text field you want to scan into.
Hello. I want to do this for an event whereby when I check people in - their name and credentials appear on the spreadsheet instead of a random number. Can I do that? If so can you help me?
Sure, first Try the Check in / Check out video to see if that will help.
ruclips.net/video/0PtnVvrVTCY/видео.html
Otherwise, you'll need to use a VLOOKUP formula to fill in the name columns.
Lastly, could you just add the name into the barcode? You can create QR Codes here berrywing.com/barcode.
How can I use this to track inventory that is checked in and out
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
Very well. I just need it to allow me to add 2 additional fields: Username and amount.
Hello and thak you for your effort. Can this app scan barcodes instead of qr codes ? I try to scan bar codes but it doesn't work. Thank you in advance. Nick
Hello! Yes it can. Android or iOS? On Android tap the yellow button on the top of the barcode scanning screen and try again.
Reach out to softwaresupport@berrywing.com
Send clear pictures of the barcodes you are scanning. Sometimes it can happen that barcodes are printed wrong or have been cut off. There is no way to tell by eye.
@@themobilesalesengineer5688 thank you for your reply. will try this out.
Thank you sir!
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.
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
@@themobilesalesengineer5688 couldn't he make another page that totals the scans by using a formula?
i did the process and it said Scan to web error. no field to set the barcode result was found on this web page.
what is the problem?
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. An update will be ready on or before July 1st, 2020
The Mobile Sales Engineer i see. Looking forward on it. This app will be really good for me to do my students attendance check. Thank you very much.
You are life saver!
you are amazing thank you!
good morning I did the same procedures in the video but the message does not arrive in the spreadsheet
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.
thank you so much
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,,,,
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. ruclips.net/video/OtfejiRS690/видео.html
Very informative...thanks
can i make a full google form with par code on it
Hi! i cant find in google app store the scan to web app
Sure, give these links a try.
berrywing.com/products/
berrywing.com/scan-to-web-app/
play.google.com/store/apps/details?id=com.berrywing.scantoweb&hl=en
on the app "scan the web QR Code" then press what?
Yes I am lost at that point too, at 2:23