No client selected — please select a client before submitting. Add clients in the Setup tab.
Inspection Info
Container & Location
Kit Class
Class A covers common workplace injuries. Class B provides broader supply for complex environments. Minimums shown reflect the selected class.
ANSI/ISEA Z308.1-2021 Inventory
0 of 24 items checked
Inspector Notes
Photo Documentation
📷
Tap to add photos
Document kit condition or deficiencies (up to 10)
Inventory Result
Check all items above
Mark each item to generate a result
🛒 Reorder List
* Required — logs to Google Sheet for real-time client monitoring
Client Management
Add each company you service here. Select them from the dropdown at the top of the form before starting an inspection. The correct Google Sheet URL will be used automatically.
✓ Client list saved
Backup / Restore Client List
If clients disappear after refresh, copy the backup text below and paste it back to restore.
Google Sheet Setup
Follow these steps once to connect this form to a dedicated inventory Google Sheet. Each submission logs in real time so clients can monitor their kit status.
Step 1 — Create a new Google Sheet
Go to sheets.google.com and create a new sheet named e.g. Metallus Kit Inventory Log. Add these headers in row 1:
Date | Location | Inspector | Kit Class | Result | Failed Items | Container Issues | Expiring Items | Notes | Photos
Step 2 — Open Apps Script
In your Sheet click Extensions → Apps Script. Delete any existing code, paste the script below, and click Save.
function doPost(e) {
try {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
sheet.appendRow([
data.date, data.location, data.inspector,
data.kitClass, data.result, data.failedItems,
data.containerFails, data.expiring,
data.notes, data.photoCount + " photo(s)"
]);
return ContentService.createTextOutput(JSON.stringify({status:"ok"})).setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService.createTextOutput(JSON.stringify({status:"error",message:err.toString()})).setMimeType(ContentService.MimeType.JSON);
}
}
function doGet(e) {
return ContentService.createTextOutput(JSON.stringify({status:"ok"})).setMimeType(ContentService.MimeType.JSON);
}
Step 3 — Deploy as Web App
Click Deploy → New deployment. Type: Web app. Execute as: Me. Who has access: Anyone. Click Deploy and authorize. Copy the Web App URL.
Step 4 — Add URL to Client above
Copy the Web App URL after deploying and paste it into the Script URL field for that client in the Client Management section at the top of this Setup tab. The form will automatically use the correct URL when you select that client.
