> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firstrespondershub.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Replace a Google registration form

> See what FirstRespondersHub collects at sign-up, build a form for anything else, and keep your records in a Google Sheet.

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.

| Step | What the student gives you |
| - | - |
| **Sign in or create an account** | Email and password |
| **Your details** | Legal first and last name, mobile phone, street address, apt or unit (optional), city, state, ZIP |
| **Payment** | Card details, handled by Stripe, plus any [agreements](https://docs.firstrespondershub.com/enrollment/agreements.md) you require |

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**](https://www.firstrespondershub.com/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**.

> [!TIP]
>
> Skip the name, email, phone, and address questions. Students already gave you those, and your export includes them.

See [Sections and questions](https://docs.firstrespondershub.com/enrollment/applications-sections-fields.md) 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**](https://www.firstrespondershub.com/program-dashboard/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**.

| Choice | What the student does | Best for |
| - | - | - |
| **As part of enrollment** | Fills out the form, then pays, all in one sitting. | Most programs. You never chase a missing form. |
| **Post-Enrollment** | Pays, then fills out the form. | Matching a pay-first process like the one you have today. |
| **Needs Approval** | Fills out the form, waits for you to approve, then pays. | Screening students before you take money. |

## 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.

| Columns | Included |
| - | - |
| Student | Email, first name, last name, phone, address, city, state, ZIP |
| Answers | One column for each question on your form |
| Tracking | Submission ID, submitted date, class, and status |

Uploaded files and photos are not in the CSV. Open the submission in your dashboard to see those.

> [!NOTE]
>
> **Replace current sheet** erases that tab. If you add your own notes or formulas beside the data, import to a new tab instead.

## 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](https://docs.firstrespondershub.com/plans-and-billing/plan-tiers-and-limits.md).

## See also

* [Applications overview](https://docs.firstrespondershub.com/enrollment/applications.md) — Reviewing and approving submissions.
* [Students and invites](https://docs.firstrespondershub.com/cohort-management/students-and-invites.md) — Inviting students you already enrolled elsewhere.
* [Agreements](https://docs.firstrespondershub.com/enrollment/agreements.md) — Refund policies and waivers students must accept.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.