Transform your Google Spreadsheet™ into a professional Inventory and Asset Tracking system.

Smart Check-In System eliminates the need for expensive handheld scanners or complex software. It turns any smartphone into a powerful barcode and QR code scanner that syncs directly with Google Sheets™ in real-time.

Designed for schools, libraries, and IT departments, this add-on simplifies the process of checking items in and out. Whether you are managing a school library, tracking Chromebooks™, or lending equipment, Smart Check-In System provides a seamless, mobile-first workflow.

Key Features:
- Mobile Scanner Web App: Instantly generate a secure QR code to launch a mobile-friendly scanner on any device (iOS or Android™). No app installation required for staff.
- Check-In / Check-Out: Easily toggle between "Issue" and "Return" modes. Scan a User ID once, then scan multiple items in a batch.
- Real-Time Dashboard: Automatically calculates inventory status. Know exactly which items are "Checked Out" and who is holding them directly inside your Google Sheet™.
- Smart Metadata: The scanner displays item details (like Book Title or Device Model) and User Names instantly upon scanning for verification.
- Audit Logs: Keeps a permanent, timestamped log of every transaction, including the email of the staff member who performed the scan.
- Secure Access: Uses Google Drive™ permissions to ensure only authorized staff can scan items into your database.

Perfect for:
- School Libraries: Manage book lending and student returns.
- IT Asset Management: Track Chromebooks, iPads, and AV equipment distribution.
- Equipment Cribs: Monitor tools and machinery checkout.
- Event Management: Track attendee check-ins.

How it works:
1. Install the add-on and click "Setup Sheets" to generate your database.
2. Paste your Inventory and User lists.
3. Generate the "Scanner QR" and let your staff start scanning immediately!

Note: Google Drive™ and Google Sheets™ are trademarks of Google LLC