Setup0 of 7 done · about 14 minutes left
Your clients and check-ins
Bring your roster across, and connect the check-in form you already use.
Bring your client roster across from the sheet you keep it in now, then connect the Google Form your clients already fill in. There is no Google account to connect and nothing to authorise — you paste a short script into your form's response sheet, and it sends us who submitted and when, and not their answers.
What connecting your form involves
- 1Open your check-in form's response sheetIn Google Forms, open the Responses tab and click the green Sheets icon. That opens the spreadsheet your answers already go into.
- 2Open Extensions → Apps ScriptFrom that spreadsheet's menu. A code editor opens in a new tab with an empty function in it.
- 3Replace everything there with the code belowSelect all of it, paste this over the top, and save. Your dashboard address is already in it — there is nothing to fill in.
- 4Add the trigger that runs itIn the Apps Script editor, click the clock icon (Triggers) in the left sidebar, then Add Trigger. Choose sendCheckInToDashboard, pick 'From spreadsheet' and 'On form submit', and save. Google will ask you to allow the script — it is your own script, running in your own account.
- 5Submit a test check-inFill in your own form once. It should appear on the Check-ins tab within a few seconds. If it does not, the Apps Script editor's Executions tab says why.
Not tracking check-ins yet? Skip — the Clients tab is there whenever you are.