Full step by step instructions here; [ Ссылка ]
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.
[ Ссылка ]
Formulas;
=IF(ISBLANK(CHECKEDOUT),"--NA--", IF(COUNTIF(SCANNEDIN, CHECKEDOUT)=0, "OUT: "&CHECKEDOUT & " STILL OUT " & OUTWHO,CHECKEDOUT&" IS IN"))
Ещё видео!