Coaches CornerCoaches Corner KPIs
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
  1. 1
    Open your check-in form's response sheet
    In Google Forms, open the Responses tab and click the green Sheets icon. That opens the spreadsheet your answers already go into.
  2. 2
    Open Extensions → Apps Script
    From that spreadsheet's menu. A code editor opens in a new tab with an empty function in it.
  3. 3
    Replace everything there with the code below
    Select all of it, paste this over the top, and save. Your dashboard address is already in it — there is nothing to fill in.
  4. 4
    Add the trigger that runs it
    In 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.
  5. 5
    Submit a test check-in
    Fill 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.