Replace a Google registration form

Many programs take a payment, then send the student to a Google Form, then track the answers in a Google Sheet. You can move all of that here and still keep a spreadsheet. The student gets one sign-up instead of two separate steps. You get every answer attached to the student and the class.

​

What is collected without a form

Every student gives you this at sign-up. You do not need to build a form for it. Date of birth, emergency contact, certification number, and shirt size are not on this list. Ask for those in a form.

​

Build a form for everything else

Add only the questions that are missing. For example, an EMT class might ask for date of birth, how the student heard about you, and a copy of their CPR card.

1. Go to Program Dashboard → Applications.
2. Click Create New Application.
3. Enter a Form Name and a Form Title, then create the form.
4. Click Add Section and pick Custom Section. Pick Emergency Contact Information instead if you want that ready-made.
5. Click Add question, pick a question type, and type your question.
6. Click Save.

See Sections and questions for every question type.

​

Attach the form to your program

A form does nothing until you attach it to a program.

1. Go to Program Offerings and open your program.
2. Open the Settings tab.
3. Pick Required Applications in the left menu.
4. Check your form.
5. Pick when students fill it out.
6. Click Update Program Offering.

​

Get your answers into a Google Sheet

There is no live link to Google Sheets. You download a CSV file and import it. Do this whenever you want fresh numbers. Step 1: Download the file

1. Go to Applications.
2. Open your form’s menu and click View Submissions.
3. Filter by class or status if you want. The download follows your filters.
4. Click Export CSV.

Step 2: Import it into Google Sheets

1. Open your Google Sheet.
2. Click File → Import → Upload and pick the file.
3. Under Import location, pick Replace current sheet to refresh a tab. Pick Insert new sheet(s) to keep the old copy.
4. Click Import data.

​

What is in the file

The file has one row per submission. Uploaded files and photos are not in the CSV. Open the submission in your dashboard to see those.

​

Download a class roster

You can also download everyone who enrolled in a class, whether or not they filled out a form.

1. Open the class and go to its Students tab.
2. In the People card, click Download, then Roster.
3. Turn on Include application responses if you want their answers too.
4. Download the CSV or Excel file.

Roster exports are on the Growth and Scale plans. See Plan tiers and limits.

​

See also

• Applications overview — Reviewing and approving submissions.
• Students and invites — Inviting students you already enrolled elsewhere.
• Agreements — Refund policies and waivers students must accept.