Connect to Google Sheets for persistent data — takes about 5 minutes.
1. Create Sheet
2. Add Script
3. Deploy
4. Connect
Step 1: Create a Google Sheet
1. Go to sheets.google.com and create a new blank spreadsheet.
2. Name it something like "Field Trip Manager DB".
3. That's it — the script will create all the tabs automatically.
💡 Don't have Google Workspace? You can also use the app offline with demo data — click "Use Offline" below.
Step 2: Add the Apps Script
1. In your Google Sheet, click Extensions → Apps Script.
2. Delete everything in the editor.
3. Copy and paste the code below, then click 💾 Save (Ctrl+S).
Loading...
Step 3: Deploy as a Web App
1. In the Apps Script editor, click Deploy → New deployment.
2. Click the gear ⚙️ next to "Select type" and choose Web app.
3. Set "Execute as" to Me.
4. Set "Who has access" to Anyone.
5. Click Deploy and authorize when prompted.
6. Copy the Web app URL — it looks like: https://script.google.com/macros/s/ABC.../exec
⚠️ Also run Setup once: In Apps Script, click the function dropdown, select setup, then click ▶ Run. This creates your sheet tabs.
Step 4: Connect & Test
Paste your Web App URL here:
After a successful test, click Save & Launch to open the app. Your URL is saved in your browser for next time.