วีดีโอ

What app is on the phone. Is it on apple store

Can you add other data to populate the google sheet. IE: Asset name, type, number etc.?

Can the form accept multiple barcode?

This is 5 years old that the instructions are no longer valid

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?

does it work when in offline?

The scan to web application no longer works. What would you recommend as the replacement.

Thanks great video

I need the formula of how to associate the barcode number with each student

So goood. Is there a simple way to do the same using a windows tablet?

You are life saver!

What s the android app you used?

@7:29, What app are you using? I didn't see the name of it. Thanks

My man is a genius. Hope he makes more content

I am struggling to get the QR Code function to work; however when I use the barcode one provided, the timestamp tracking is only linked to classroom and not student name. Can you advise?

Hi, great presentation. Does the App support scanning 2 barcodes, for example, scan a user tag, then an item or action. Thanks

when i scan the qr code on the app after hitting the cog wheel it does nothing, I have a google pixel 8, is it something with the operating system?

I am struggling with the formula on the status page - I am only getting a black box when I have entered the formula (copied and pasted from above). Any ideas?

Hi I'm wondering how to do the output of this, so instead of adding new items it removes them

So I started using the scanner and 9 scans in and the google sheets is not updating! What did I do wrong?

At the 2:26 time mark .... you lost me. Up till that point fine. I do not understand "scan to Web"

Will this work for code 39 barcodes.. we dont use qr codes

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?

Nice.. really basic. Thank you

I want to ask you which app using for Scanning

You sir are amazing

ilove bud

Assume there are multiple fields in Google Form, which field, would Berrywing fills when we scan a Barcode?

Thank you for taking the time to share

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

Watch now

si funciona!! gracias

How can we set this up if one person is checking out several items at one time, without having to reenter their name over and over?

Anyone find a solution to the checkin and checkout, when you check it out again it still says checked in

Thank a lot i was looking at a paid subcription app to do this. Thanks for free solution

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.

Its nice video, I want to know which app you configure the QR code Thanks in Advace

The formula is no working. when i copy it into A1 on status tab it give me an error and turns that box black. Can anyone help

What would this be used for ?

hi can I make it that users can check out/in multiple items? thanks!

Hello This is a great video and I am using this method for a while now. I have one issue though. Sometimes when I scanned to check out, it automatically checked that thing back in. Any suggestion ?

Can you please explain the Barcode system page at the beginning of the video? How did you choose to set it up and how did you choose the barcodes that are actually there? Where did not barcodes come from and how does it work that the barcodes change just by copy and past?

At 7:24 in the video, I click QR button on upper-right and scan my Google site QR (generate from Berrywing) but the sample URL didn't change after scan. Scan to web version 6.1.3 on Android. Could you confirm this issue? Many thanks

Thank you for such a great video! This has been incredibly helpful in setting up a inventory tracking system for my music room. I too was having issues with the status page as others have mentioned but stumbled upon this solution from the stackoverflow website. 1. Create a new sheet called Status. 2. You're going to insert two formulas. The first goes into cell A2: =query({SignOut!A2:E;SignIn!A2:E},"select Col3, count(Col3), max(Col1) where Col2 is not null group by Col3 label Col3 'Barcode', count(Col3) 'Barcode count', max(Col1) 'Out-Timestamp'") *replace SignOut and SignIn with whatever you've named the spreadsheet that receives your Sign Out or Sign In info from your Google Forms. 3. Write the following words in cell D1, E1 and F1; Barcode, Date, Name 4. Paste the second formula into cell D2: =arrayformula(if(isodd(B3:B),arrayformula(vlookup(C3:C,SignOut!A2:E,{3,1,2},0)),"")) The way this solution works is it counts the number of times the instrument has been signed out. If the number of times is odd it "flags" the instrument as signed out (ie it will appear in column D-F). If the instrument is signed in it will not appear in those columns. It's quite a simple but effective solution. I hope that helps. I had thought I had posted this yesterday but couldn't find it when I returned to the video today. I'm not sure if I accidentally didn't post it or if it was deleted. If I have broken some kind of posting rule I apologize. I just thought this solution would be helpful.

First of all thank you so much for such a great video. I have one error though. While creating Barcode it work only when I have one word, but when I hit space and type another work the bar code disappear. Any suggestion here ?

Is it possible to add a picture of the equipment in the adjacent cell next to the barcode?

That is a QR code

HI! I was wondering what the formula would look like if I wanted to have the STATUS TAB show an additional named range? ie: location of store where an item was checked out. Status would show, OUT 'CHECKED OUT' STILL OUT 'OUT WHO' AT 'LOCATION'. Can the formula be modified to get that added piece of Information captured from the check out tab? Thank you for the thorough walk through.

can anyone help. i want to create some type of system for kids who leave classroom for what ever reason

I have 5 qr codes at the same time that are used in different places, the question is how to combine all the information in one spreadsheet