Check in / out Google Sheets

Full step by step instructions here; scantoweb.net/check-out-and-c...
Using barcodes and a little creating spreadsheet formula; you can have a powerful Google Sheets based check in and out process.
Create barcodes; scroll down on this page for the Google Sheets formula.
berrywing.com/barcode/
Formulas;
=IF(ISBLANK(CHECKEDOUT),"--NA--", IF(COUNTIF(SCANNEDIN, CHECKEDOUT)=0, "OUT: "&CHECKEDOUT & " STILL OUT " & OUTWHO,CHECKEDOUT&" IS IN"))

[@malachydonaghy]

This looks great.....Im going to try it over the next few days.

[@alazyteacher7551]

Thank you for the superb video, it is very informative. Will be using this in my next project.

[@rossarroyo1156]

Thank you for taking the time to share

[@djplopez89]

This is great! Have you thought of adding to your app something like this with NFC tags?

[@austinbrant3121]

This is so helpful, thanks

[@Clarabellelaisswon]

Thank you very much for your sharing. my boss just wanted me to get the qr code for meeting attendance today and i found your vdo. it really works! thank you for saving my life 5555 (hahaha) 🙏🏻🥰😊🤗👍

[@abhinavsheth8170]

Thank you so much!

[@nemesis17592]

I am having an issue. This works for an item only one time for me. After it goes through a check out, check in cycle. It will always just say ("is in") not matter if its checked out or in.

[@danielopezg2007]

My man is a genius. Hope he makes more content

[@hammad8986]

Thank you so much.. i needed that to know the status of the ventilators at the hospital.

[@themobilesalesengineer5688]

Wow! Thank you. We are humbled to learn that our idea is helping in this important COVID effort.

[@orkin.itadmina2072]

this is indeed intuitive and simple kudos G master TMSE

[@user-wz5uo5vf1w]

This is great! How do I make it so that this process will continue. Like if we check out the same item? It doesn't show the "OUT: ...." when the same item is checked out again.

[@ginadelacruz8154]

ground in just 17 minutes, amazing.

[@kristanblackledge2295]

Is there a way to modify this to make it a sign-in/out sheet for students to use for hall passes? If so, how could the tracking for different grade levels be sent to a different tab? For example, one tab for 6th grade, one tab for 7th grade, etc.

[@johng5295]

Thanks in million.

[@mystreteacher]

Pretty Cool. I've have it working. I'm actually only using one form with a option to Check-in or Check-out and then performing queries. The one thing I have noticed is if I'm creating a QR code for an inventory item using the "Text" option it doesn't want to scan. It does scan if I use the "URL" option. Purchased - will be pretty handy for me.

[@cindysmidt3160]

Hi Dale, I was wondering how you had all the details go to one form? I would prefer this as well.

[@mystreteacher]

@@cindysmidt3160 Hi Cindy, I had to move to a free/paid service called Librarika. The performance of the sheet really started bogging down when I started adding items. Librarika is more for books, but it does a good enough job with equipment for my purposes.

[@ai_dividend_daily_1]

Nice stuff

[@colettemeaux2434]

Is there a video on inventory reordering , like notifications of low stock and checking out as used?

[@_._r_z_3_._]

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.

[@ErricsonBlair]

Hi there, I enjoyed the video and the detail to getting things up and running. I do have more questions about QR codes and computer site add on with coding. Can you help?

[@elemenopi5702]

this is very interesting but i like to know if it is possible to use web camera and does scan-to-web have pc app?

[@BankruptNomad]

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 ?

[@user-fd8we4we4z]

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?

[@nnngonzales8276]

respect for you

[@Teleman01]

Hi, I'm just trying to make a simple checklist. If I have a piece of gear that has a QR code, and I scan that code, it basically just checks the checkbox in Google sheets. Is there an easy way to do this?

[@bonniesoonosberger6765]

what is the qr scanner application which you are using. I cannot paste the qr code created in my form to the scan application

[@elody_createyourownlife4485]

I just follow this tutorial , it is interesting

[@MarkLambertJr]

This is great! I would like to be able to take a tool out of service for repair and then put back in service upon completion..... can you help out with the formula? Thanks!

[@joseluispadilla3617]

Amazing

[@abizerbohra6725]

hi nice information and very well explained but i am unable to initiate my barcode scanner through qwerty key paid how i can work it out ?

[@mtoleezy8531]

Hi. I hope you have been well. We want to host an event this December where people buy e-tickets with QR Codes. Those QR Codes will be scanned at the entrance. Also, like in the video, we'd like to know who still checked in at the event and who checked out. Can you suggest us methods? Hoping for a response soon. Thank you

[@juvysalem1715]

Is there a way to check out multiple items/inventories one time?

[@sjnhs2464]

This video is great! Is it possible to add timestamp on the check in and check out of the item? Please do a video of this with added timestamp.

[@randonimewiz3391]

Timestamps is automatically added in first column as it populates the spreadsheet.

[@cww4437]

If I already have a list of attendee for my event, will the attendees name be tracked on the excel sheet when I scan theiir QR quote? Is there a video just for attendee registration?

[@cesarrivera76]

si funciona!! gracias

[@oliviasalinas7504]

Can I use a handheld scanner if using the app on a chromebook?

[@krimmelcte6068]

Anything that is PC based, where I can do this with a USB scanner and feed the check-in check-out data to a google spreadsheet?

[@InspirationBakingMixes]

Can this be modified for NON public "site" so that I can use it for internal inventory?

[@algervideodesign6383]

Has anyone figure out how to sign something out again after its been checked it without deleting previous entries?

[@chelseam7407]

Thank you for creating this! I am very excited to start using it! I tried starting with the barcode generator, but when I copy/paste the formula into B1 and enter a value in A1, it comes up with an error . Do I need to enable something outside of sheets first?

[@themobilesalesengineer5688]

Wonderful, we hope you find it useful. Report back when you have it working. For the barcodes, we found that the formula in the KZbin description does not copy paste correctly because of the way KZbin overrides links. Go to our barcode site. You can create barcodes here. Or scroll down to get the correct formula. berrywing.com/barcode/

[@themobilesalesengineer5688]

Also, you can contact us directly at [e-mail] We'll be happy to help troubleshoot what is happening.

[@gerardomyles1151]

i guess im asking randomly but does someone know of a tool to get back into an Instagram account..? I was stupid forgot the account password. I would love any tricks you can offer me!

[@calvinbriggs3798]

@Gerardo Myles Instablaster =)

[@gerardomyles1151]

@Calvin Briggs thanks for your reply. I got to the site thru google and im in the hacking process now. Takes a while so I will get back to you later with my results.

[@hirenchauhan4862]

I want to ask you which app using for Scanning

[@AaronZumbahlen]

Has anyone figured out the issue with checking the same item out and in back to back. It seems to only work once. The second time it acts like it is checking the item out, but on the status, it keeps saying "item IS IN" I basically just want the see the items that are OUT show up on the status. If they are checked back IN, I would like it to remove itself from the status. Is this possible?

[@3pksabah544]

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

[@davidsanchezaraiza9889]

if you scan on check out twice it will appear "is in"

[@melissamyles6166]

It worked well but when I scanned items back in instead of saying they were in, they dropped off the list altogether.

[@ownernyacutie]

Hi, I'd like to know more about this. I need this for my event. Could you help me?

[@sterlingrosenbaum3681]

Awesome program, using it to check in/out tablets throughout the day at my work. One issue that I'm running into is when i check a tablet back in, then I have to check it back out later on in the day, it shows as returned even though I just checked it out. Is there a way I could put a counter on how many times each one was checked out and check it to see how many times its been checked back in, then display who the most recent one to check it out was? Or maybe a script that deletes the data if its been turned in so that it cant pull that data to check against again?

[@StepOneAutomotiveGroup]

Did you have a success in finding your solution? I am running into a similar issue.

[@DW-bm2gc]

@@StepOneAutomotiveGroup Any Solution to this?

[@tyisit3931]

You need to delete the checked-in item specifically in two places: the first is to delete the name of the checked-in item in "Form Responses 1", and then delete the same in "Form Responses 2" (don't touch STATUS). After doing these two procedures, you will be able to check-out the same item again.

[@vingua6890]

@@tyisit3931 This solution is essentially like starting the system from the beginning again and gets rid of the pivotal status sheet data. Surely there is a more permanent solution

[@WarriorWoodshop]

got it to work for the first checkout. however to recheck out the same item, it still shows as in because of the way the formula is written. any suggestions? Is there any way to just show what is out, since I would be using this for tools in a school shop and with 50 students per hour x 4 hours per day, we only need to know what's out in the status tab

[@simongonzalez1793]

see another video named "Inventory managemnt system with QR codes ( IN/OUT/STOCK)"

[@JNTXTravel]

Such a great video. Does anyone have a code to fix the status or have an alternate solution? I’m going to use this to scan binders for 30 people every week that they will be trading in and out.

[@1jbegic]

How do you prevent from Checking in if the item is not checked out? I would like to see some type of message like "item is not checked out, unable to check-in". Or perhaps to avoid checking out an item that is already checked out to someone else?

[@drew5834]

Go to app settings and turn on Duplicate scan check, by checking the box.

[@darkmatterloudspeakers]

This was very helpful. If I were to use this for event attendance is there a way to flag or indicate a code has already been scanned?

[@themobilesalesengineer5688]

Hi, yes you can do a count formula over the check in column. Look for > 1 (greater than 1) Google Forms are one way only. You cannot send feedback to the form if a previous value is entered. The app Scan to Web has a duplicate scan setting. So you can present an error if the barcode is scanned twice on the same tablet or phone.

[@darkmatterloudspeakers]

@@themobilesalesengineer5688 Thank you so much. This is very helpful.

[@Pipe.007]

Can a single person check out multiple items at once?

[@alokkrsinha]

I HAVE ALL THINGS DONE but when clink link out and in button page open but how to scan barcode fields in required tabe pls help me

[@josephjohnrobles8074]

Please help me, I used to check out and check in a particular item multiple times in a day, on first check out, and check in, it works smoothly, but by the second time I scanned or check out this same item, it appears it's already In. Thank you very much

[@user-br1yn9fm5z]

I think we need a script to archive previous scanned items!

[@carolinacastrill]

How can I scan multiple barcodes without sending several answers ?

[@pawnchoh8623]

What would this be used for ?

[@mpsmanger4713]

How could I program NFC tags to do the same thing? Is it possible?

[@BankruptNomad]

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 ?

[@theoriginalpsychocharlie]

The QR code is disappearing because you cant use spaces. Example: Red Impact Drill (Wrong) Redimpactdrill (Correct)

[@stixnstonzpv19]

My status tab was working, but is not showing what is out anymore. Any ideas why?

[@matthewmcmullan7428]

Could this be used to determine how much inventory is left? I want to make a system very similar to this where you scan the barcode and can input how much you've taken or put back. If anyone has any suggestions that'd be awesome.

[@mrbargain3175]

I am also working on similar project. would love your update too.

[@kepopol8556]

Exactly what I was thinking about

[@pushmedia8790]

you can you google sheets to send email when inventory hits the value (youtube google sheets alerts)

[@BrieCrump-ig5hx]

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?

[@khaliddanoun3001]

Hello after I scan the QR-code (homepage) the home page doesn't appear on the app. can you help me?

[@rebeccabourland5426]

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?

[@danielrizzle4865]

Thanks for make this video, can you help me with the status, I want to multiple scan it, but the status "STILL IN". Is it possible to make it " STILL OUT" again.

[@themobilesalesengineer5688]

Yeah, the spreadsheet is not going to handle all possible scenarios. Perhaps you could, at the end of the day, erase all the records from the IN and OUT sheets to start over for the next day. After you have made a record of anything still out for follow up.

[@tyisit3931]

You need to delete the checked-in item specifically in two places: the first is to delete the name of the checked-in item in "Form Responses 1", and then delete the same in "Form Responses 2" (don't touch STATUS). After doing these two procedures, you will be able to check-out the same item again.

[@danielrizzle4865]

@@tyisit3931 Thanks for enlighten me Sir 👍

[@sparklingclean8470]

@@tyisit3931 CAN YOU PLEASE MAKE A VIDEO OF THIS B/C THIS IS DRIVING ME CRAZY~!

[@laraj]

@@sparklingclean8470 if you can wait till next week, Monday, I’ll be happy to do it.

[@chhansambath5244]

what app did you use to scan the check in or out qr ?

[@chhansambath5244]

yes both if i check in or out after i got a lot of data then i tested to deleted all data(1 to 10) that i was scan in or out, later i try to scan again it run to number 11 not number 1 again,so the problem is can use 1 time only?

[@user-kj7fu6xt6e]

Has anyone figured out a way to solve the STATUS TAB ISSUE from saying AS IN upon checking out a second time?

[@user-br1yn9fm5z]

Just delete information of the device and username in the "Checkout/checkin" tabs and it should reset it!

[@pamx4038]

How can i put the qr in the box

[@b1gwayne377]

Is it possible for google sheets to generate a sheet that only shows the unresolved check outs? I want a sheet that only shows what items were never checked back in

[@b1gwayne377]

Also, the formula seems to fail when the same item is checked out/in more than once a day.

[@deeppatel4591]

hey why dont you just link a copy of this template in your description would be really help ful

[@chhansambath5244]

it doesn't work very well, because when i insert data 1 to 10 for example so when delete it it not refill data from 1 instead it continues to number 11.

[@lloorrii67]

I cannot get the STATUS sheet to work-I get this error...Unknown range name: 'CHECKEDOUT' and it shows #NAME? in column A. What did I do wrong?

[@digitalupgraded]

How can i adjust the formula for multiple items, I run a delivery company and we supply, keys, devices and fuel cards. So I need each driver to checkout and check in these 3 items daily

[@jaredyanez4273]

Change the A1 and other A1 portions of the formula to A2 and A3 and so on for each new item in its corresponding cell.

[@user-kj7fu6xt6e]

​@@jaredyanez4273 Can you elaborate on this please?

[@emmanuelcontreras4608]

los codigos no funcionan cuando se escanean, debe haber un herror en la api creada

[@hinnpetit]

Have any idea on how to do daily attendance without keeping all the history in the spreadsheet?

[@tonypeavler6929]

I would not recommend deleting…history is data…data is valuable. You can use the data to create various reports and summaries such as one persons attendance over a specific time period.

[@hishamuddinshafie]

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

[@berrywingllc1523]

Oh thank you for that! We did not realize there was an issue in 6.1.3; we are working on an app update that will fix this problem and it will be ready in less than 48 hours.

[@hishamuddinshafie]

​@@berrywingllc1523 Thanks a lot sir.. Much appreciate.

[@user-xs2wp8hm4x]

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

[@barhasbarhas2905]

ilove bud

[@robpowell254]

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?

[@themobilesalesengineer5688]

Hello @robpowell254 We are aware the barcode creation formula is not working any longer. We'll publish a new formula soon. I'll comment here when it is ready too.

[@tee856]

@@themobilesalesengineer5688 Having the same issue. Thank you for helping

[@ShaunPilbrow]

Hey, I have also just tried this and took me a minute, but I figured it out. For some reason, the code auto sets the FILL option for the cell to be BLACK. If you switch the FILL option back to TRANSPARENT - you can see the words. Hope this helps.

[@robpowell254]

Thank you

[@robpowell254]

@@ShaunPilbrow Thanks for this Shaun, Just one more little thing, it seems to be working but now when I sign something out it goes red, then sign it back in it goes green, if I then sign the same item out again it stays green and says in? I seem to have followed all the instructions correctly and checked the codes multiple times. Do I need to delete the data in the forms each time to reset? Not sure how to overcome this? thanks

[@efe1833]

Hey Bro Can I get in Touch with you

[@thefandomrealm]

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

[@matthewhollis8514]

Did anyone find a fix for this?

[@adrianbitsinnie1537]

I'm curious myself, I've tried my own solutions but sadly I don't understand Sheets enough and doesn't seem to work like other languages haha have you found one?

[@coapa_760]

any other way to scan without using the berrywing.. thing

[@user-wt2ep5es3e]

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