Full step by step instructions here; https://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.
https://berrywing.com/barcode/
Formulas;
=IF(ISBLANK(CHECKEDOUT),"--NA--", IF(COUNTIF(SCANNEDIN, CHECKEDOUT)=0, "OUT: "&CHECKEDOUT & " STILL OUT " & OUTWHO,CHECKEDOUT&" IS IN"))
Watch video Check in / out Google Sheets online without registration, duration hours minute second in high quality. This video was added by user The Mobile Sales Engineer 23 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 201,40 once and liked it 1.9 thousand people.