ð How to sync with 4 users:
1. Deploy the Apps Script code below in your Google Sheet.
2. Paste the Web App URL and click "Connect & Sync".
3. Share the same URL with the other 3 users â they paste and connect too.
4. Any change by one user will auto-update others within 8 seconds. ðĄ Google Sheets acts as the shared database â no server needed.
â ïļ When deploying: set "Execute as: Me" and "Who has access: Anyone".
ð Deleted Items
LAN Equipment
ðĩ UTP Cable
ðĄ RJ-45 Connector
ðĶ Others
ðĩ UTP Cable â In Store
ðĩ
Total In Store
0
Meters
ð Transaction History
ðĄ RJ-45 Connector â In Store
ðĄ
Total In Store
0
Pieces
ð Transaction History
ðĶ Others â In Store
âïļ Mark as Done
âïļ Manage Item Names
ïž ADD NEW ITEM
ð DELETE EXISTING ITEM
0
ðŽ
No items yet. Add one above!
â Mark as Provided
Link3
The Service Company
ð
Inventory Dashboard
Please enter your Username and Password to login.
ð Change Password
ð Change Password
Google Apps Script Web App URL
â ïļ Deploy with "Execute as: Me" and "Who has access: Anyone".
âĐ Restore Item
ðĪ
Restore to original engineer's list
ð
Send to Unassigned
Move to unassigned pool instead
ð Delete Item
Why is this item being deleted? Please select a reason.
â ïļ Damaged / Defective Device
â Lost or Missing
âĐ Returned to Stock / Vendor
ð Duplicate Entry
âïļ Other (write reason...)
ðĨ Add Stock â
â Provide â
ðĨ Add Others Stock
â Provide â
ð History â
ð PDF Export
Select which section to export as PDF
Choose Report Type
ðïļ
All Equipment
Full inventory with stats & LAN stock
âïļ
Done List
Completed jobs with client & ticket info
ðĪ
Rupchan
Rupchan's assigned devices
ðĪ
Amit
Amit's assigned devices
ðĪ
Tamim
Tamim's assigned devices
ðĪ
Nazrul
Nazrul's assigned devices
ð
Unassigned
Devices not yet assigned
ð
LAN Equipment
UTP Cable, RJ-45 & Others stock
ð
Full Report â All Sections
Complete inventory report including all engineers, done list, LAN stock & deleted items