Asset Register — IPAV
Syncing…
0Total
0Available
0Out
0Issues
0Archived
Not connected ⚙
Active Assets
Checkout Log
#AssetConditionTechnicianVehicleOutReturnedNotesStatus
⚠️
Assets Requiring Attention

Assets marked Damaged or Faulty. Update condition once repaired.

Archived Assets

Hidden from inventory but kept in the checkout log.

➕ Add New Asset

All Assets
IDNameCategoryTypeConditionSerialStatusActions

👷 Technicians

#NameActions

🚗 Vehicles

#NameActions

🔗 Google Sheets Connection

Paste your Google Apps Script Web App URL. Saved in your browser automatically.

📊 Asset Status Overview

Live summary across all conditions and availability states.

🚗 Default Vehicles per Technician

Auto-selects the technician's default vehicle on checkout. Can still be changed manually.

➡ Check Out Asset

↩ Return Asset

✏️ Edit Asset

📋 Asset History

✏️ Edit Technician

✏️ Edit Vehicle

🔒

Settings

Enter the passcode to continue

📋 Google Sheets Setup Guide

This app stores all data in a Google Sheet you own. Follow the steps below to connect it.
1Create a Google Sheet
Go to sheets.google.com and create a new blank spreadsheet.
Name it IPAV Asset Register. The script auto-creates the required tabs:
Assets Log Workers Utes
2Open Apps Script
Click Extensions → Apps Script. Delete any existing code.
3Paste the Script & Save
Paste the full Apps Script code and save. Name the project e.g. Asset Register.
4Deploy as a Web App
Click Deploy → New deployment → ⚙️ Web app.
Execute asMe Who has accessAnyone ⚠️ Not "Anyone with Google account"
Click Deploy and authorise if prompted (one-time only).
5Copy & Paste the URL
Copy the Web App URL and paste it into the Settings page URL field.
https://script.google.com/macros/s/AKfycb…/exec
6Updating the Script Later
Always create a New Version when redeploying — never just save.
Deploy → Manage deployments → ✏️ Edit → New version → Deploy. URL stays the same.
⚠️ Important: "Who has access" must be "Anyone" — not "Anyone with a Google account". JSONP cannot send Google login credentials and will silently fail otherwise.