No client selected — please select a client before submitting. Add clients in the Setup tab.
AED Information
Inspection Checklist
0 of 0 items checked
Consumable Expiration Dates
Pad / Electrode Expiration
Battery Expiration
Items expiring within 90 days will be flagged. Expired items require immediate replacement before the AED is considered operational.
Rescue Kit Contents
Tap each item to mark as present. Tap again to mark missing.
Inspector Notes
Photo Documentation
📷
Tap to add photos
Document AED condition or deficiencies (up to 10)
Inspection Result
Complete checklist above
Mark all items to generate a result
Logs to your dedicated AED Inspection Google Sheet
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
Connect this form to a dedicated AED Inspection Sheet. Each submission logs automatically for real-time monitoring.
Step 1 — Create a new Google Sheet
Go to sheets.google.com and create a new sheet named e.g. Metallus AED Inspection Log. Add these headers in row 1:
Date | Location | Inspector | Model | Serial | Result | Failed Items | Missing Rescue Items | Pad Exp | Battery Exp | 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.model, data.serial, data.result,
data.failedItems, data.missingRescue,
data.padExp, data.batExp,
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.
