# Formfacade documentation
> Every Formfacade guide in reading order: start a form, pick a product, build it, add formulas, share and embed it, work with responses, and fix problems.
## Chapter 1: Get started
### What Formfacade does
> Formfacade turns any Google Form into a branded, embeddable experience, with custom layouts, CSS, and response sync to Google Forms and your linked Google Sheet.
Chapter 1: Get started
Source: https://docs.formfacade.com/getting-started/what-is-formfacade
**What is Formfacade?**
Formfacade is a no-code tool that turns any Google Form into a professional, branded form with custom layouts, CSS, and thank-you pages, while every response keeps flowing into Google Forms and your linked Google Sheet.
> **New here? Start with the 15-minute Quickstart:**
> The fastest way to see the value is to do it: [**Quickstart → build your first
> branded form**](https://docs.formfacade.com/getting-started/quickstart) walks you from a plain Google
> Form to a branded form embedded on your site, with responses in Sheets.
Formfacade sits on top of Google Forms. Instead of replacing the form engine you
already trust, it wraps your form in a customizable presentation layer: your
brand colors, your fonts, your layout, and your domain, while Google Forms
continues to store and process every response.
This page is the fastest way to understand what Formfacade does, how the
data flows, and where to go next.
#### Why teams use Formfacade
Google Forms is reliable and free, but it looks like Google Forms. Formfacade
keeps the reliability and removes the constraints. The four capabilities below
are the ones teams reach for first.
#### Google Forms vs. Formfacade
The table maps common needs to what each tool offers. Formfacade never removes a
Google Forms capability. It adds a design and embedding layer on top.
| Capability | Google Forms | Formfacade |
| --- | --- | --- |
| Response storage | ✅ Google Forms & Sheets | ✅ Same, synced through Google Forms |
| Custom branding & CSS | ❌ Limited themes | ✅ Full CSS, fonts, colors |
| Embed on your own site | ⚠️ Basic iframe | ✅ Embeds for WordPress, Squarespace, Google Sites, and more, plus a React package |
| Custom thank-you / redirect | ⚠️ Custom text only | ✅ Personalized messages & conditional redirects |
| File uploads without login | ❌ Requires Google sign-in | ✅ Guest uploads to Drive |
| Kanban response board | ❌ Not available | ✅ Built-in workflow board |
#### Import your first form
Importing takes about a minute. Formfacade creates a managed copy of your
Google Form, so your original form and its existing responses stay exactly as
they are.
> **Your original form is safe:**
> Importing never edits your source Google Form. Formfacade works from a copy it
> manages, and you can relaunch the underlying Google Form at any time from
> Formfacade interface.
#### Embed anywhere
Once a form is styled, you can put it on almost any website or app. Each
platform works a little differently (a plugin for WordPress, a URL for Google
Sites, a package for React), so pick yours below to open its step-by-step guide.
#### Watch it in action
Prefer to see it in action? These short walkthroughs show Formfacade forms
collecting file uploads without a login and embedded in React and Google Sites.
#### Next steps
- Try it end to end: [Quickstart](https://docs.formfacade.com/getting-started/quickstart).
- Bring your form in: [Start a form](https://docs.formfacade.com/getting-started/start-a-form).
- Find the product for your job: [Customize UI](https://docs.formfacade.com/products/customize-ui) and the other product pages.
---
### Quickstart
> Go from a plain Google Form to a branded form embedded on your website with responses in Google Sheets, in about 15 minutes.
Chapter 1: Get started
Source: https://docs.formfacade.com/getting-started/quickstart
**What can I do with Formfacade in 15 minutes?**
Take any Google Form, restyle it to match your brand, embed it on your website, and analyze responses in Google Sheets. No code, no migration. Import your form, customize its look, grab the embed snippet, and your responses keep flowing into Google Forms and your linked Sheet.
This is the fastest way to see what Formfacade does. In about **15 minutes**
you'll turn a plain Google Form into a **branded form on your own website**,
and your responses can still land in **Google Sheets**, through Google Forms.
The whole value in one line:
> **Enhance** your Google Form → **customize** the look → **embed** it on your
> site → **analyze** responses in Sheets.
> **What you'll need:**
> A Google Form you own (new or existing) and a website you can paste a snippet
> into. That's it. No code and no account migration.
#### The 15-minute path
Each step below is the short version. The **full guide** link on each one has the
click-by-click screenshots when you want them.
1. **Import your Google Form (~3 min)**
Go to [formfacade.com/enhance](https://formfacade.com/enhance/), choose
**Customize your Google Forms**, and paste your form's responder link.
Formfacade makes a managed copy. Your original form and its responses are
never touched.
→ Full guide: [Start a form](https://docs.formfacade.com/getting-started/start-a-form)
2. **Customize the look (~4 min)**
In the **Preview** tab, pick a **Minimal** or **Colorful** theme, set your
brand colors and fonts, and add your logo. Click **Apply**.
→ Full guide: [Design](https://docs.formfacade.com/guides/design)
3. **Embed it on your website (~3 min)**
Open the **Share → Embed** tab, pick your platform, and follow its method:
the official plugin for WordPress, a URL for Google Sites, the embed code for
Squarespace and most other sites, or the package for React. Your branded form
is now live on your own site.
→ Full guide: [Embed & Website](https://docs.formfacade.com/products/embed)
4. **Analyze responses in Sheets (~5 min)**
Responses collect automatically. To stream them into a spreadsheet, confirm
**Submit to Google Forms** is on, then link the underlying form to
**Google Sheets**. Every submission appends as a new row.
→ Full guide: [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets)
#### That's the whole loop
You just took a Google Form and made it a **branded, embedded, analyzable**
experience without leaving Google Forms as your data store. Everything else in
these docs is depth on top of this loop.
#### Next steps
- Bring in your own form: [Start a form](https://docs.formfacade.com/getting-started/start-a-form).
- Find your forms later: [Your dashboard](https://docs.formfacade.com/getting-started/your-dashboard).
- Pick a product for your job, such as [Customize UI](https://docs.formfacade.com/products/customize-ui) or [File upload](https://docs.formfacade.com/products/file-upload).
---
### Start a form
> Start a Formfacade form three ways. Import your Google Form, enter a form name and let Formfacade build it, or upload a PDF to convert it.
Chapter 1: Get started
Source: https://docs.formfacade.com/getting-started/start-a-form
**How do I start a form in Formfacade?**
Click Try it free on any formfacade.com product page. It opens a short wizard that starts with Import Google Form: paste your Google Form's link (or click Browse) and click Next. To build a new form instead, click ← Back and choose Enter your form name, or Upload a PDF to convert a document into a form.
Every Formfacade product starts the same way. You bring a form in, Formfacade
makes a copy of it, and the copy opens in the Formfacade app, where you edit,
design, share, and see responses. There are three ways to bring a form in:
| Way to start | Use it when | You provide |
| --- | --- | --- |
| **Import your Google Forms** | You already have a Google Form | Its link, or pick it with **Browse** |
| **Enter your form name** | You're starting from nothing | A name, like "Workshop feedback" |
| **Upload a PDF** | You have the form on paper or in a document | A PDF, DOC, PNG, or JPG file |
#### Where do I start?
Click **Try it free** on the page of the product you want, such as
[Customize UI](https://formfacade.com/website/) or
[File upload](https://formfacade.com/file-upload/). It opens a wizard with
**Import Google Form** as step 1.
To create a form instead, click **←** above the steps. You'll see all three
ways to start. The [Formfacade home page](https://formfacade.com/enhance/)'s
**Try it free** opens the same three choices.
*Figure: How do you want to customize your Google Form? with three choices: Import your Google Forms, Enter your form name, and Upload a PDF to create a custom form. The three ways to start. Each product words them for its own job.*
The steps after the first one depend on the product:
| Product | Wizard steps |
| --- | --- |
| Customize UI | Import Google Form → Choose a layout → Preview and share |
| Embed in website | Import Google Form → Get the embed code |
| Sheets Lookup | Import Google Form → Connect Sheets → Configure |
| Assign points | Import Google Form → Assign points → Preview and share |
| File upload | Import Google Form → Preview → Share form |
| Email notification | Import Google Form → Set up email notifications → Preview and share |
| Prefill & email | Import Google Form → Prefill this form → Send prefilled links |
#### How do I import my Google Form?
1. **Copy your Google Form's responder link**
In Google Forms, make sure the form is **published** and **accepting
responses**. Click **Published**, then **Copy responder link**, then
**Copy**.
*Figure: Google Forms Published options dialog: 1 Accepting responses, 2 Anyone with the link, 3 the Copy responder link button, 4 Copy. 1 Accepting responses is on, 2 responders are Anyone with the link, 3 Copy responder link, 4 Copy.*
The responder link starts with `https://docs.google.com/forms/d/e/`. Don't
use the editor link from your browser's address bar.
2. **Paste the link and click Next**
On step 1, **Import Google Form**, paste the link into **Paste a link, or
pick from Drive**. Or click **Browse** to pick the form from Google Drive.
Click **Next**.
*Figure: Step 1 of 3, Import Google Form: 1 the Google Form's link field, 2 Browse, 3 Next. 1 Paste the link, or 2 Browse your Drive, then 3 Next.*
Formfacade shows **Copying your questions…** while it makes the copy. It
takes a few seconds.
3. **Finish the product's steps**
The wizard moves to the product's next step, for example **Choose a
layout** in Customize UI. When you finish, the form opens in the
Formfacade app. You can come back to it any time from
[your dashboard](https://docs.formfacade.com/getting-started/your-dashboard).
> **Your original form is safe:**
> Formfacade works on a copy. It never edits your original Google Form, and
> the original keeps its own responses.
#### How do I create a form from its name?
Choose **Enter your form name**, type a name such as "Workshop feedback", and
click the button below it (**Build form** or **Create form**, depending on
the product).
Formfacade suggests sections and questions for that name. Click **Make
changes** to adjust them in plain English, or **Next** to create the form.
**Discard** starts over. The [Prefill & email](https://docs.formfacade.com/products/prefill-and-email)
and [Assign points](https://docs.formfacade.com/products/assign-points) guides walk through this route.
#### How do I convert a PDF into a form?
Choose **Upload a PDF**, drag a PDF, DOC, PNG, or JPG file onto the upload
box (or click to browse), and click **Convert**. Formfacade turns the
document's fields into questions in a new Google Form. Check the questions in
[the editor](https://docs.formfacade.com/guides/editor) before you share it.
#### Troubleshooting
| Problem | Likely cause | Fix |
| --- | --- | --- |
| Nothing imports, or "form not found" | You pasted the **editor link** from the address bar | Copy the **responder link** from **Published** in Google Forms |
| Import fails or questions are missing | The form isn't published or isn't accepting responses | Publish the form and turn on **Accepting responses** |
| "You need access" | Responders are limited to your organization or to named people | Set responders to **Anyone with the link** |
| New questions don't show | You changed the Google Form after importing it | See [Troubleshooting](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails#how-to-sync-google-forms-changes-with-formfacade) |
#### Next steps
- Make it look like your brand: [Customize UI](https://docs.formfacade.com/products/customize-ui).
- Change questions and settings: [The editor](https://docs.formfacade.com/guides/editor).
- Find where responses go: [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
---
### Your dashboard
> Log in to Formfacade and use your dashboard (the home base for all your forms, responses, and contacts) with Home, Forms, Inbox, Contacts, and Account tabs.
Chapter 1: Get started
Source: https://docs.formfacade.com/getting-started/your-dashboard
**What is the Formfacade dashboard?**
Click Login on any formfacade.com page and choose your Google account to land on your dashboard, the home base for your whole account. Home shows your account at a glance with quick actions; Forms lists every form; Inbox collects incoming responses; Contacts holds the people you've saved; and Account has your details and plan. Click any form to open it in the Formfacade interface.
When you log in to Formfacade, you land on your **dashboard**, the home base
for your whole account. It's where you find all your forms, responses, and
contacts, and where you open any form to work on it.
#### Signing in
The **Login** button is in the top-right corner of every page on
[formfacade.com](https://formfacade.com/). Click it, choose your Google account,
and you'll arrive at your dashboard.
*Figure: The Formfacade homepage with the Login button in the top-right corner. Click Login on any formfacade.com page, then choose your Google account.*
#### The dashboard at a glance
The top navigation moves you between the five areas of your account:
| Tab | What it's for |
| --- | --- |
| [**Home**](#home) | Your account at a glance, with quick actions |
| [**Forms**](#forms) | Every form in your account |
| [**Inbox**](#inbox) | Incoming responses across all your forms |
| [**Contacts**](#contacts) | The people you've saved |
| [**Account**](#account) | Your account details and plan |
#### Home
Home opens with four cards: a snapshot of your account, each with a one-click
action:
| Card | Shows | Action |
| --- | --- | --- |
| **Forms** | How many forms you have | **Create new form** |
| **Contacts** | How many contacts you have | **Send email campaign** |
| **Responses** or **Orders** (this month) | Responses or orders received this month | **View responses** or **View orders** |
| **Current plan** | Your plan (e.g. Team) | **Manage plan** |
Below the cards, **Recently edited** lists your recent forms and when they were
last edited (**See more** opens the full list).
**Recent submissions** lists the forms with the latest responses.
**My website** has your website settings.
At the bottom, the **Need support** card links you straight to Formfacade support.
*Figure: The dashboard Home tab: 1 Forms, Contacts, Responses, and Current plan cards, 2 the Recently edited list. Home: 1 account snapshot and quick actions up top, 2 recently edited forms below.*
#### Forms
**Forms** shows every form in your account as a card, with its title, its
response count (or when it was last edited), and its status (for example
**Active**). Use the **⋮** menu on a card for more options, or click the card
to open the form in the **Formfacade interface**, where you can
[edit](https://docs.formfacade.com/guides/editor),
[customize](https://docs.formfacade.com/guides/design),
[share](https://docs.formfacade.com/guides/share), and review
[responses](https://docs.formfacade.com/guides/responses).
The **New Form** card at the start of the grid creates a form, and shows how
many more forms your plan allows.
*Figure: The Forms tab showing a New Form card with forms remaining, followed by form cards with titles, response counts or last-edited times, and Active status. Forms: every form as a card; New Form shows how many more your plan allows.*
#### Inbox
**Inbox** collects incoming responses from all your forms in one place, newest
first. Each row shows who submitted, which form and response number, a preview of
their answers, and the date. If you've set a custom subject in
[Email notification](https://docs.formfacade.com/products/email-notification),
it appears here too.
Responses are organized into **Submitted**, **Completed**, and **Trash**, the
same statuses you use on a form's
[Responses board](https://docs.formfacade.com/guides/responses). Use the
refresh button to check for new responses, and the arrows to page through older
ones.
*Figure: The Inbox tab with Submitted, Completed, and Trash folders and a list of responses showing respondent, form name, answer preview, and date. Inbox: every response across your forms, sorted into Submitted, Completed, and Trash.*
#### Contacts
**Contacts** lists the people you've saved, with their name, email, phone, and
**source** (the form or forms they came from). Search by email to find someone,
or use **Add contact** to add more. Contacts are who you send to with
[Prefill & email](https://docs.formfacade.com/products/prefill-and-email) and email campaigns.
*Figure: The Contacts tab with a search-by-email box, an Add contact button, and a table of names, emails, phones, and source forms. Contacts: everyone you've saved, and which form they came from.*
#### Account
**Account** shows your account details and plan. You can also reach plan
settings from the **Manage plan** button on Home.
#### Next steps
- Create your first form by [Start a form](https://docs.formfacade.com/getting-started/start-a-form).
- Learn where submissions go in [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
- Manage a form's responses as a team on the [Responses board](https://docs.formfacade.com/guides/responses).
---
## Chapter 2: Products
### Customize UI
> Make Google Forms look like your brand. Change the layout, theme, colors, fonts, and logo, hide or lock fields, and choose what happens on submit, while responses still go to your Google Form.
Chapter 2: Products
Source: https://docs.formfacade.com/products/customize-ui
**How do I customize the look of my Google Form?**
Click Try it free on formfacade.com/website, paste your Google Form's link, and click Next. Choose a layout (Compact, Comfortable, or Default), then open the Preview tab to set the theme, colors, fonts, and logo. Hide fields and change the Submit button and thank-you message on the Edit tab. Responses still go to your Google Form.
Google Forms lets you change a header image, a color, and a font. Customize
UI changes the rest: the layout, the look of every question, which fields
people see, and what happens after they submit. Formfacade works on a copy of
your form, so the original stays as it is.
#### How do I start?
Click **Try it free** on the [Customize UI page](https://formfacade.com/website/).
The wizard has three steps: **Import Google Form**, **Choose a layout**, and
**Preview and share**. To build a new form instead, click **←** and see
[Start a form](https://docs.formfacade.com/getting-started/start-a-form).
1. **Import your Google Form**
Paste your Google Form's link (or click **Browse**) and click **Next**.
2. **Choose a layout**
Pick how many questions sit side by side on a computer screen.
*Figure: Step 2 of 3, Choose a layout: 1 Compact, 3 columns on desktop, 2 Comfortable, 2 columns on desktop, 3 Default, 1 column like Google Forms. 1 Compact (3 columns), 2 Comfortable (2 columns), 3 Default (1 column, like Google Forms).*
Click **Proceed** to open your form, or **More settings** to open the
**Preview** tab, where you change the rest of the design.
3. **Preview and share**
Check the form, then share its link or embed it. See
[Share your form](https://docs.formfacade.com/guides/share).
#### What can I change?
| You want to | Where | Guide |
| --- | --- | --- |
| Change the theme, colors, background, and fonts | **Preview** tab | [Design](https://docs.formfacade.com/guides/design) |
| Add your logo and business name | **Preview** tab, **Page** | [Design](https://docs.formfacade.com/guides/design#page-branding) |
| Change the layout later | **Preview** tab, **Layout** | [Design](https://docs.formfacade.com/guides/design) |
| Add your own CSS | **Edit** tab, form settings, **Advanced** | [Design](https://docs.formfacade.com/guides/design#how-to-modify-styles-using-css) |
| Hide a field, or make it read only | Question's gear, **Answer** | [Question settings](https://docs.formfacade.com/guides/question-settings) |
| Change the placeholder text | Question's gear, **Question** | [Question settings](https://docs.formfacade.com/guides/question-settings#how-do-i-change-the-placeholder-text) |
| Calculate an answer, such as a date or a total | Question's gear, **Calculate** | [Calculated fields](https://docs.formfacade.com/reference/functions), [Date functions](https://docs.formfacade.com/reference/date-functions) |
| Change the thank-you message, or redirect | **After page** gear, **On submit** | [After submit](https://docs.formfacade.com/guides/after-submit) |
| Change the Submit button's text or language | **After page** gear, **Button** | [After submit](https://docs.formfacade.com/guides/after-submit) |
#### What do respondents see?
Your form, in your colors, fonts, and layout, with your logo at the top,
instead of the Google Forms look. Share it as a link, or
[embed it in your website](https://docs.formfacade.com/products/embed) so it sits in your page without an
iframe.
#### Where do the responses go?
To your Google Form, the same as before, and to its linked Google Sheet if you
have one. You can also work through them on the [Responses](https://docs.formfacade.com/guides/responses)
tab. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
#### Questions
##### How can I change the layout of my Google Forms?
Choose **Compact**, **Comfortable**, or **Default** in the wizard. To change it
later, open the **Preview** tab, click **Layout**, pick one, and click **Apply
to this form**.
##### How can I change the fonts or background color?
Open the **Preview** tab. **Typography settings** set the fonts and their
size, and **Background settings** set the color or an image. Click **Apply**.
See [Design](https://docs.formfacade.com/guides/design).
##### Can I add a file upload question?
Yes, people can upload files without a Google sign-in. See
[File upload](https://docs.formfacade.com/products/file-upload).
##### Does it work with question types Google Forms doesn't have?
Formfacade shows every Google Forms question type, and adds settings such as
read-only and calculated answers. See [Question types](https://docs.formfacade.com/reference/question-types).
#### Next steps
- Set the theme, colors, and fonts: [Design](https://docs.formfacade.com/guides/design).
- Hide or lock fields: [Question settings](https://docs.formfacade.com/guides/question-settings).
- Put the form on your website: [Embed in website](https://docs.formfacade.com/products/embed).
---
### Embed in website
> Embed a Formfacade form on any website (WordPress, Squarespace, Google Sites, Webflow, React/Next.js, Bootstrap, and more), or host it as a standalone site. Pick the right method here.
Chapter 2: Products
Source: https://docs.formfacade.com/products/embed
**How do I embed a Google Form in my website?**
Click Try it free on formfacade.com/embed, paste your Google Form's link, and click Next. Formfacade asks Where do you want to embed this form? Pick your platform to get its code. WordPress uses the Formfacade plugin, Google Sites takes a URL, React apps use the @formfacade/embed-react package, and most other sites take a short HTML snippet. Already using Formfacade? Open Share → Embed.
Embed in website puts your Google Form on your own site, without an iframe and
without the Google Forms look. Responses still go to your Google Form.
#### How do I start?
- **New to Formfacade?** Click **Try it free** on
[formfacade.com/embed](https://formfacade.com/embed/).
- **Already imported your form?** Open the **Share** tab and click
**Embed**. You get the same choices.
1. **Paste your Google Form link**
Step 1 is **Import Google Form**. Paste your form's link (or click
**Browse** to pick it from Drive) and click **Next**.
*Figure: Step 1 of 2, Import Google Form: 1 the link field, 2 Next. 1 Paste your Google Form link, then 2 Next.*
2. **Pick your platform**
Step 2, **Get the embed code**, asks **Where do you want to embed this
form?** Choose your platform and click **Next**. The code it gives you
already has your form's IDs in it.
*Figure: The Share screen, with 1 the Embed tab and 2 the platform options: WordPress, Squarespace, Google Sites, React, and more. The same choices in the app: 1 Share → Embed, 2 your platform.*
There are five ways to put your form on a site:
| Style | For | What you use |
| --- | --- | --- |
| **HTML snippet** | Squarespace, Webflow, Wix, Shopify, Bootstrap, any HTML-capable site | A `
` + `
```
#### Pick your platform
| Platform | Method | Guide |
| --- | --- | --- |
| **WordPress** | Official Formfacade **plugin** (setup wizard) | [WordPress](https://docs.formfacade.com/products/embed/wordpress) |
| **Squarespace** | HTML snippet in a Code block | [Squarespace](#squarespace) |
| **Google Sites** | Insert → Embed → **By URL** (paste the Formfacade URL) | [Google Sites](#google-sites) |
| **Wix** | HTML snippet in an Embed HTML element | [Wix](https://docs.formfacade.com/products/embed/wix) |
| **Webflow, Shopify, and others** | HTML snippet | [Any other website](https://docs.formfacade.com/products/embed/other-websites) |
| **React / Next.js** | `@formfacade/embed-react` package | [React & Next.js](https://docs.formfacade.com/products/embed/react-nextjs) |
| **Bootstrap / other HTML** | The HTML snippet, anywhere in your markup | [Any other website](https://docs.formfacade.com/products/embed/other-websites) |
| **React Native app** | `@formfacade/embed-react-native` package | *choose "React native" in Share → Embed* |
| **No website yet** | Host it as a site | [Share your form](https://docs.formfacade.com/guides/share) |
> **Note:**
> Whatever the platform, responses keep flowing to Google Forms and your linked Google Sheet
> exactly as covered in [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
#### Squarespace
Squarespace takes the code in a **Code block**.
1. **Copy your embed snippet**
Open **[Share → Embed](https://docs.formfacade.com/guides/share)**
and choose **Embed in my Squarespace site**. Copy the snippet:
```html
```
2. **Add a Code block**
Edit the page, click an insert point (**+**), and add a **Code** block.
*Figure: The Squarespace page editor, with 1 a Code block on the page, 2 the snippet pasted in the block's editor, and 3 Save. 1 Add a Code block where the form should appear, 2 paste the snippet, and 3 Save.*
3. **Paste and save**
Paste the snippet into the Code block and **Save**. The form appears on your
published page.
> **Note:**
> If the Code block shows the code as text instead of rendering it, make sure the
> block's type is **HTML** (not Markdown) and that **Display Source** is off.
Video: [Embed a Formfacade form in Squarespace](https://www.youtube.com/watch?v=JEE9krcJ2Oc)
#### Google Sites
Google Sites embeds the form by its **URL**, not by a code snippet.
1. **Copy your Formfacade URL**
Open **[Share → Embed](https://docs.formfacade.com/guides/share)**,
choose **Embed in my Google Sites**, click **Next**, and copy the
**Formfacade URL** it gives you.
2. **Insert → Embed (By URL tab)**
In Google Sites, click **Insert → Embed**, then select the **By URL** tab (not
“Embed code”).
*Figure: The Google Sites Embed from the web dialog, with 1 Embed in the Insert panel, 2 the By URL tab with the Formfacade URL, and 3 Insert. 1 Insert → Embed, 2 paste the Formfacade URL on the By URL tab, then 3 Insert.*
3. **Paste, insert, publish**
Paste the Formfacade URL, then click **Insert**. Resize the block so
the whole form is visible, then **Publish** the site.
> **Note:**
> Drag the embed's handles to size it so the form shows without an inner
> scrollbar.
Video: [Embed a Formfacade form in Google Sites](https://www.youtube.com/watch?v=Y0CRyKs_fk0)
#### Questions
##### How do I see where people stop filling my form?
Open the **Responses** tab and click **Kanban board**. The **Abandoned**
column lists everyone who started your form and didn't submit it. Click a
card to see the answers they gave before they stopped. See
[Responses](https://docs.formfacade.com/guides/responses).
##### Changes don't show in my embedded form. What do I do?
See [Troubleshooting](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails#form-changes-are-not-reflected-in-the-embedded-form-how-can-i-fix-this).
#### Next steps
- Pick your platform above, or start with the most common: [WordPress](https://docs.formfacade.com/products/embed/wordpress).
- Match the form to your site: [Design](https://docs.formfacade.com/guides/design).
- No website? Share a link or a hosted page from [Share your form](https://docs.formfacade.com/guides/share).
---
### Sheets Lookup
> Populate dropdowns, autofill fields, and build conditional dropdowns in Google Forms live from a Google Sheet. Set up in plain English, no code. Read-only and always in sync.
Chapter 2: Products
Source: https://docs.formfacade.com/products/sheets-lookup
**How do I pull Google Sheets data into a Google Form?**
Use Formfacade's Sheets Lookup. Go to formfacade.com/lookup, click Try it free, and pick what you want to do: populate a dropdown's options, autofill related fields, build conditional (cascading) dropdowns, or connect with AI. Then connect your form, connect your Google Sheet(s), and describe the connection in plain English. Formfacade reads the sheet live (every 30 minutes or on each submission) and never modifies it.
Google Forms has no native way to pull data from a Google Sheet. Sheets Lookup
adds exactly that: it connects form questions to columns in your sheet and reads
them **live**, so options and autofilled fields always match your real data:
product catalogs, price lists, student rosters, employee directories. Your sheet
stays the **single source of truth**; Formfacade mirrors it to serve forms fast
and **never writes to it**.
#### What you can do with your Sheets data
After **Try it free**, Formfacade asks *"What do you want to do with your Google
Sheets data?"* (four tasks, all powered by the same setup flow). Each has its own
guide:
*Figure: The picker screen: Populate a dropdown from Google Sheets, Autofill fields from Google Sheets, Conditional dropdowns from your Sheets data, Connect Google Sheets to your form with AI. Pick what you want to do. Each option leads into the same connect flow.*
| Task | What it does | Guide |
| --- | --- | --- |
| **Populate a dropdown** | Fill a dropdown's **options** from a sheet column (deduplicated, sorted, or filtered). | [Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown) |
| **Autofill fields** | When a respondent picks a value, auto-populate **related fields** from the same row. | [Autofill Fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields) |
| **Conditional dropdowns** | Filter the **next** dropdown by an earlier answer, and drop choices that are used up. | [Conditional Dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns) |
| **Connect with AI** | Describe what you want in plain English and let Formfacade wire it up. | [Connect with AI](https://docs.formfacade.com/products/sheets-lookup/connect-with-ai) |
Every option is **natural-language driven**: at the Configure step you describe
the connection in plain English rather than set it up by hand.
#### Set it up (shared by all four)
Whichever task you pick, the first three steps are the same. The **Connect form**
screen's heading changes to match the task, but the flow is identical. Then each
guide above picks up at the Configure step.
1. **Start at formfacade.com/lookup**
Go to [formfacade.com/lookup](https://formfacade.com/lookup/), click **Try it
free**, and choose what you want to do with your Sheets data.
*Figure: The Formfacade Sheets Lookup landing page with 1 Try it free and 2 Install addon buttons. formfacade.com/lookup: 1 Try it free to start, or 2 Install addon to keep your native form.*
2. **Connect your form**
Paste your Google Form link (or click **Browse** to pick it from Drive) and
click **Next**. Formfacade makes a **copy** of the form to add the lookup to.
*Figure: Step 1 Connect form: Make a copy of Google Form, with 1 a link field and Browse, and 2 Next. Step 1: connect the form by 1 pasting its link or picking it from Drive, then 2 Next.*
3. **Connect your Google Sheet(s)**
Click **Connect a Google Sheet** to launch the spreadsheet picker and choose
your sheet. Back on **Pick connected sheets**, select one or more (use
**+ Connect another sheet** to add more), then click **Next**.
*Figure: Step 2 Connect Sheets: a Connect a Google Sheet button and an 'I've connected, refresh' link. Connect a Google Sheet launches the Drive spreadsheet picker.*
*Figure: Pick connected sheets: 1 a selected sheet with its sync date, and 2 a Connect another sheet link. 1 Pick one or more connected sheets (Formfacade reads their columns). 2 Connect another sheet to add more.*
4. **Describe the connection, then follow your task's guide**
On **Configure**, you describe the connection in plain English. **This is
where the four tasks differ.** Open the guide for what you're building:
[Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown),
[Autofill Fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields),
[Conditional Dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns),
or [Connect with AI](https://docs.formfacade.com/products/sheets-lookup/connect-with-ai).
#### Behavior & limits
These apply to every Lookup task:
| Behavior | Detail |
| --- | --- |
| **Sync cadence** | Every 30 minutes, or on every form submission |
| **Direction** | Read-only. Formfacade mirrors your data and never writes to your sheet |
| **List size** | Hundreds to thousands of options, with autocomplete |
| **Multiple sheets** | Connect more than one; different fields can read from different sheets |
| **Field visibility** | Autofilled fields can be editable, read-only, or hidden |
| **Unknown values** | The form shows an error if an entry isn't found in the sheet |
| **Source of truth** | The spreadsheet; edits there propagate to every connected form |
> **Prefer to keep your native Google Form?**
> The **Try it free** path makes a Formfacade copy served from a Formfacade link.
> To keep your original Google Form instead, use **Install addon** on the landing
> page and describe your lookup in plain English from inside Google Forms.
> **Responses still go to Google:**
> Lookup only controls what options appear and what gets autofilled. Submitted
> responses keep flowing to Google Forms and your linked Google Sheet exactly as
> described in [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
#### Next steps
- Start with [Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown), the simplest task.
- Scoring answers instead of looking them up? See [Assign Points](https://docs.formfacade.com/products/assign-points).
- Pre-filling fields per contact? See [Prefill & Send](https://docs.formfacade.com/products/prefill-and-email).
---
### Populate a dropdown
> Fill a Google Forms dropdown's options from a Google Sheet column, deduplicated, sorted, or filtered, and always in sync. No code.
Chapter 2: Products
Source: https://docs.formfacade.com/products/sheets-lookup/populate-dropdown
**How do I fill a Google Forms dropdown from a Google Sheet?**
Use Formfacade's Sheets Lookup and pick 'Populate a dropdown from Google Sheets'. Connect your form and your sheet, then describe which column should feed the dropdown, for example, 'populate the Employee ID dropdown from the directory sheet'. Options can be deduplicated, sorted, or filtered, and they stay in sync every 30 minutes or on each submission. Your sheet is read-only.
This is the simplest Lookup task: it fills a **dropdown's options** from a
column in your Google Sheet, and nothing else. Add a row to the sheet and the
new option appears in the form automatically, with no manual editing.
> **First, the shared setup:**
> Every Lookup task starts the same way: Try it free, connect your form, connect
> your sheet. If you haven't done that yet, see
> [Set it up](https://docs.formfacade.com/products/sheets-lookup#set-it-up-shared-by-all-four)
> on the Sheets Lookup overview. This guide picks up at the **Configure** step.
#### Use case
An IT support form needs a **Select Employee ID** dropdown that always lists the
current employee IDs from your HR directory, without re-typing them into the
form every time someone joins or leaves.
The directory lives in a Google Sheet. The **Employee ID** column (A) is what
feeds the dropdown; the other columns are there for [autofill](https://docs.formfacade.com/products/sheets-lookup/autofill-fields).
*Figure: The IT_Support_Ticketing_Directory Google Sheet with columns Employee ID, Full Name, Department, and Manager Email, rows EMP-101 to EMP-113. The source sheet: the Employee ID column powers the dropdown's options.*
#### Describe the dropdown
At the **Configure** step, describe which column feeds the dropdown in plain
English, e.g. *"populate the Employee ID dropdown with the values from the
directory sheet."* Options can be **deduplicated** (unique values only),
**sorted**, or **filtered** by a condition.
*Figure: The Configure step with 1 a plain-English instruction connecting a sheet column to the dropdown question, and 2 Proceed. 1 Describe which column feeds the dropdown (here, Employee ID). Then 2 Proceed.*
Click **Proceed**, and Formfacade confirms the dropdown is now populated with the
distinct values from that column.
*Figure: A 'Your form is ready' confirmation describing 1 the dropdown populated with the distinct values from the sheet column, and 2 Preview your form. Your form is ready: 1 the dropdown now lists the distinct values from the column. 2 Preview your form to see it.*
Click **Preview your form** to see the live dropdown, then **Publish** when it
looks right.
#### The result
On the published form, the **Select Employee ID** dropdown lists every ID from
the sheet (EMP-101 through EMP-115) with no options typed into the form by
hand. Add a row to the sheet and the new ID shows up on the next sync.
*Figure: The published IT Support Ticket form with the Select Employee ID dropdown open, listing EMP-101 through EMP-115. The live form: the dropdown is populated straight from the sheet's Employee ID column.*
#### Good to know
| Behavior | Detail |
| --- | --- |
| **What it controls** | Only the dropdown's options, not autofill or dependencies |
| **Cleanup** | Deduplicate, sort, or filter the column's values |
| **Sync** | Every 30 minutes, or on every form submission |
| **Direction** | Read-only. Your sheet is never modified |
#### Next steps
- Want selecting a value to fill **other** fields too? See [Autofill Fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields).
- Want the next dropdown to depend on this one? See [Conditional Dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns).
- Back to the [Sheets Lookup overview](https://docs.formfacade.com/products/sheets-lookup).
---
### Autofill fields
> Autofill related Google Forms fields from a Google Sheet row. When a respondent picks a value, the matching fields fill in automatically. Editable, read-only, or hidden.
Chapter 2: Products
Source: https://docs.formfacade.com/products/sheets-lookup/autofill-fields
**How do I autofill Google Forms fields from a Google Sheet?**
Use Formfacade's Sheets Lookup and pick 'Autofill fields from Google Sheets'. Connect your form and your sheet, then at the Configure step describe the autofill, e.g. 'autofill Full Name, Department, Manager Email from Sheet1 when Employee ID is entered'. Formfacade queries the sheet in real time and populates the matching fields from the same row. Autofilled fields can be editable, read-only, or hidden.
Autofill goes a step beyond a [populated dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown):
when a respondent **selects a value, related fields fill in automatically from
the same row** of your sheet. It saves typing, prevents mistakes, and keeps
submitted data consistent with your source of truth.
> **First, the shared setup:**
> Every Lookup task starts the same way: Try it free, connect your form, connect
> your sheet. If you haven't done that yet, see
> [Set it up](https://docs.formfacade.com/products/sheets-lookup#set-it-up-shared-by-all-four)
> on the Sheets Lookup overview. This guide picks up at the **Configure** step.
#### Use case
On an IT support form, a respondent picks their **Employee ID** and the form
fills in their **Full Name**, **Department**, and **Manager Email** from the
employee directory, so every ticket is tagged to the right person and routed to
the right manager.
It uses the same directory sheet as the dropdown, this time pulling the
**Full Name**, **Department**, and **Manager Email** columns (B–D) from the row
that matches the selected Employee ID.
*Figure: The IT_Support_Ticketing_Directory Google Sheet with columns Employee ID, Full Name, Department, and Manager Email, rows EMP-101 to EMP-113. The source sheet: autofill pulls Full Name, Department, and Manager Email (columns B–D) from the matching row.*
#### Set it up
Pick **Autofill fields from Google Sheets** at the start. The Connect form
screen reads *"add lookups."*
*Figure: The Autofill Google Forms from Google Sheets entry screen: Make a copy of Google Form and add lookups. The Autofill option: 'pick the Google Sheet to autofill fields and populate dropdowns from.'*
After connecting your form and sheet, the **Configure** step pre-fills an
autofill instruction, for example *"Connect to Google Sheets:
IT_Support_Ticketing_Directory. Autofill Full Name, Department, Manager Email
from Sheet1 when Employee ID is entered."* Review it, tweak if needed, and click
**Proceed**.
*Figure: The Configure step with 1 a pre-filled instruction to autofill Full Name, Department, and Manager Email when Employee ID is entered, and 2 Proceed. Configure: 1 the autofill instruction is written for you; edit it to fit your form, then 2 Proceed.*
Formfacade confirms what it built: the Employee ID dropdown lists every ID, and
picking one autofills the other fields from that row. Other questions (like the
ticket description) are left unchanged, and it may switch the looked-up question
to **short-answer** so the value records on submission.
*Figure: A 'Your form is ready' confirmation explaining the Employee ID dropdown autofills Full Name, Department, and Manager Email from the row. Your form is ready. Picking an Employee ID now autofills the related fields.*
#### The result
On the published form, selecting **EMP-102** instantly fills **Full Name**
(Bob Johnson), **Department** (Sales), and **Manager Email**
(manager.sales@example.com) from that row. The respondent only picks their ID
and adds their issue.
*Figure: The live IT Support Ticket form with EMP-102 selected and Full Name, Department, and Manager Email autofilled. The live form: one selection fills the matching details straight from the sheet.*
Each field stays **editable** by default, but you can mark autofilled fields
**read-only** (respondents can't change them) or **hidden** (they don't see
them). You can even autofill different fields from **different connected sheets**.
#### Good to know
| Behavior | Detail |
| --- | --- |
| **Trigger** | Respondent selects or enters a value; related fields fill from the same row |
| **Field visibility** | Autofilled fields can be editable, read-only, or hidden |
| **Recording** | Looked-up questions may switch to short-answer so the value saves on submit |
| **Multiple sheets** | Different fields can autofill from different connected sheets |
| **Sync** | Every 30 minutes, or on every form submission; read-only |
#### Next steps
- Just need to fill a dropdown's options? See [Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown).
- Want the next dropdown to depend on an earlier answer? See [Conditional Dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns).
- Back to the [Sheets Lookup overview](https://docs.formfacade.com/products/sheets-lookup).
---
### Conditional dropdowns
> Build dependent (cascading) dropdowns in Google Forms from a Google Sheet. The next dropdown filters by an earlier answer, with a choice eliminator for used-up options.
Chapter 2: Products
Source: https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns
**How do I make dependent (conditional) dropdowns in Google Forms?**
Use Formfacade's Sheets Lookup and pick 'Conditional dropdowns from your Sheets data'. Connect your form and a sheet whose columns hold the related options, then describe the dependency, e.g. 'populate Category from the Category column, then filter Product by the selected Category'. When a respondent picks a value in the first dropdown, the next dropdown filters in real time to show only the matching choices. You can chain multiple levels, like Category to Sub-category to Product.
Conditional dropdowns make one dropdown **depend on another**: pick a value in
the first, and the next dropdown shows only the choices that match, filtered live
from your Google Sheet. You can chain several levels, and used-up choices can drop
out automatically (a built-in **choice eliminator**).
> **First, the shared setup:**
> Every Lookup task starts the same way: Try it free, connect your form, connect
> your sheet. If you haven't done that yet, see
> [Set it up](https://docs.formfacade.com/products/sheets-lookup#set-it-up-shared-by-all-four)
> on the Sheets Lookup overview. This guide picks up at the **Configure** step.
#### Use case
An **IT Equipment Request** form has a **Category** dropdown (Laptops, Monitors,
Accessories). When a respondent picks **Laptops**, the **Product** dropdown
filters to show only laptop models, so no one can request a product that doesn't
belong to the chosen category.
Both dropdowns are powered by one **Product Catalog** sheet, where each row ties a
product to its category:
| Category | Product |
| --- | --- |
| Laptops | MacBook Pro 14-inch |
| Laptops | Dell XPS 13 |
| Laptops | ThinkPad X1 Carbon |
| Monitors | Dell UltraSharp 27-inch |
| Monitors | LG 4K 32-inch |
| Monitors | Samsung ViewFinity 34-inch |
| Accessories | Logitech MX Master 3S |
| Accessories | Keychron K2 Keyboard |
| Accessories | USB-C Hub |
| Accessories | Webcam 1080p |
#### Set it up
Pick **Conditional dropdowns from your Sheets data** at the start. The Connect
form screen reads *"add conditional choices,"* and notes that later dropdowns can
depend on earlier answers and used-up choices disappear.
*Figure: The Conditional dropdowns and choice eliminator for Google Forms entry screen: Make a copy of Google Form and add conditional choices. The Conditional dropdowns option: later dropdowns depend on earlier answers; used-up choices disappear.*
After connecting your form and the catalog sheet, describe the dependency at the
**Configure** step, for example *"Populate the Category dropdown with the
distinct values from the Category column. Then filter the Product dropdown to
show only the products whose Category matches the Category selected above."*
Review it and click **Proceed**.
*Figure: The Configure step with 1 an instruction to populate Category from the column and filter Product by the selected Category, and 2 Proceed. Configure: 1 describe the dependency between the two columns, then 2 Proceed.*
Formfacade confirms what it built: Category lists every distinct category, and
Product is a **dependent dropdown** that auto-filters to the selected category.
*Figure: A 'Your form is ready' confirmation explaining Category lists every category and Product auto-filters to the selected category. Your form is ready. Product is now a dependent dropdown filtered by Category.*
#### The result
On the live form, the **Product** options change with the **Category**. Pick
**Laptops** and only the three laptops appear:
*Figure: The live IT Equipment Request form with Category set to Laptops and the Product dropdown showing only MacBook Pro 14-inch, Dell XPS 13, and ThinkPad X1 Carbon. Category = Laptops → Product shows only the laptops.*
Switch to **Accessories** and the Product dropdown updates to just the
accessories. The same dependency works for every category:
*Figure: The live form with Category set to Accessories and the Product dropdown showing only Logitech MX Master 3S, Keychron K2 Keyboard, USB-C Hub, and Webcam 1080p. Category = Accessories → Product shows only the accessories.*
#### Good to know
| Behavior | Detail |
| --- | --- |
| **Dependency** | The later dropdown filters in real time by the earlier answer |
| **Multiple levels** | Chain dependencies, e.g. Category → Sub-category → Product |
| **Multiple sheets** | The dropdown and its filter can read from different sheets |
| **Choice eliminator** | Choices that are used up can be dropped from later submissions (useful for one-per-respondent items like asset tags or time slots) |
| **Sync** | Every 30 minutes, or on every form submission; read-only |
#### Next steps
- Simpler single dropdown? See [Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown).
- Fill related fields on selection? See [Autofill Fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields).
- Not sure how to express it? Let [Connect with AI](https://docs.formfacade.com/products/sheets-lookup/connect-with-ai) set it up for you.
---
### Connect with AI
> Connect a Google Sheet to your Google Form by describing what you want in plain English. AI sets up the lookup, autofill, or dropdown for you.
Chapter 2: Products
Source: https://docs.formfacade.com/products/sheets-lookup/connect-with-ai
**How do I connect Google Sheets to a Google Form with AI?**
Use Formfacade's Sheets Lookup and pick 'Connect Google Sheets to your form with AI'. Paste your form, pick your sheet, then describe what you want in plain English, for example, 'when the respondent enters their Order ID, look up that row and fill in the Customer, Status, and Expected Delivery'. It sets up the lookup for you. It's the same engine behind the dropdown, autofill, and conditional options, for setups that don't fit neatly into one of those.
This is the most open-ended Lookup option: paste your form, pick your sheet, then
**tell the AI what you want in plain English** and it wires up the connection.
It's the same engine behind the other three tasks. Reach for it when your setup
doesn't fit neatly into "dropdown", "autofill", or "conditional".
> **First, the shared setup:**
> Every Lookup task starts the same way: Try it free, connect your form, connect
> your sheet. If you haven't done that yet, see
> [Set it up](https://docs.formfacade.com/products/sheets-lookup#set-it-up-shared-by-all-four)
> on the Sheets Lookup overview. This guide picks up at the **Configure** step.
#### Use case
An **Order Status Check** form lets a customer type their **Order ID** and see
their order's **Customer**, **Status**, and **Expected Delivery**, looked up
live from an orders sheet. The input is a value the customer *types* (not a
dropdown of known options), and the form returns several fields from the matching
row. That's a lookup you describe in words rather than pick from a fixed option.
*Figure: The Order-Tracking Google Sheet with columns 1 Order ID and 2 Customer, Status, and Expected Delivery, rows ORD-1001 to ORD-1010. The source sheet: the AI looks up a typed 1 Order ID and returns 2 the other columns from that row.*
#### Set it up
Pick **Connect Google Sheets to your form with AI** at the start. The Connect
form screen invites you to tell the AI what you want in your own words.
*Figure: The Connect Google Sheets to Google Forms with AI entry screen: Make a copy of Google Form and connect Google Sheets. The AI option: 'tell AI what you want in your own words. It sets up the lookup for you.'*
After connecting your form and sheet, describe the lookup at the **Configure**
step in plain English, for example *"When the respondent enters their Order ID,
look up that row and fill in the Customer, Status, and Expected Delivery fields.
If the Order ID is not found in the sheet, show an error."* Review it and click
**Proceed**.
*Figure: The Configure step with 1 a plain-English instruction to look up an Order ID and fill Customer, Status, and Expected Delivery, and 2 Proceed. Configure: 1 describe the whole lookup in your own words, then 2 Proceed.*
#### The result
On the live form, typing **ORD-1002** instantly fills **Customer** (Bob Johnson),
**Status** (Processing), and **Expected Delivery** (2026-10-14) from the matching
row. The customer only enters their order number.
*Figure: The live Order Status Check form with ORD-1002 entered and Customer, Status, and Expected Delivery filled in. The live form: one typed Order ID returns the customer, status, and delivery date.*
> **How unmatched values are handled:**
> In this build, the AI chose to leave the looked-up fields **blank** when an
> Order ID isn't found (the respondent can still submit). Because the behavior is
> driven by your instruction, describe how you want unmatched entries handled
> (for example leaving the fields blank, or blocking submission) and review the
> AI's summary before you publish.
#### Good to know
| Behavior | Detail |
| --- | --- |
| **Input** | A value the respondent types (not limited to dropdown options) |
| **Returns** | One or more fields from the matching row |
| **No match** | Handled per your instruction (e.g. fields stay blank). Review the AI's summary |
| **When to use** | Lookups that don't fit "dropdown", "autofill", or "conditional" |
| **Sync** | Every 30 minutes, or on every form submission; read-only |
#### Next steps
- Know exactly what you need? Jump straight to [Populate a Dropdown](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown), [Autofill Fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields), or [Conditional Dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns).
- Back to the [Sheets Lookup overview](https://docs.formfacade.com/products/sheets-lookup).
---
### Assign points
> Assign points to answers in Google Forms and auto-calculate scores for quizzes, assessments, lead scores, and calculators. Set it up by describing the scoring in plain English.
Chapter 2: Products
Source: https://docs.formfacade.com/products/assign-points
**How do I calculate a score in Google Forms?**
Use Formfacade's Assign Points. Go to formfacade.com/calculate, paste your Google Form, and describe how you want it scored in plain English, for example 'give 1 point for each correct answer, then show the total score after submit'. Formfacade supports dropdown, multiple-choice, checkbox, Likert, linear-scale, and grid questions, and can calculate overall, section, or category scores, show feedback, and recommend or redirect based on the score.
Assign Points turns a plain Google Form into a **quiz, assessment, lead score,
or calculator**. You attach point values to answers, Formfacade adds up the score
automatically, and you decide what the respondent sees based on how they scored.
#### What you can do
| Capability | What it does |
| --- | --- |
| **Points on any question type** | Assign points for dropdown, multiple-choice, checkbox, Likert scale, linear scale, and grid questions. |
| **Overall score** | Automatically total the points across every question in the form. |
| **Section score** | Total the points within a specific form section. |
| **Multiple category scores** | Calculate several scores at once by grouping specific questions into categories. |
| **Show or hide the score** | Hide the score during completion and reveal it after submit, or email the result instead. |
| **Feedback & recommendations** | Show correct answers, per-answer feedback, and score-based recommendations or verbal assessments. |
| **Redirect by score** | Send respondents to different pages depending on their score. |
#### Use case
Your team runs a **Cybersecurity Awareness Quiz**: 15 multiple-choice questions
on firewalls, phishing, passwords, and backups. Each correct answer is worth a
point, nobody should see their score while they're answering, and after they
submit everyone gets a verdict: **13–15** means *Security pro!*, **8–12** means
*Solid, but brush up*, and **0–7** means *Please complete the security
training*. Below, the quiz is built from scratch, so you don't need a Google
Form yet.
#### Build the quiz
1. **Choose Create a new scored form**
Go to [formfacade.com/calculate](https://formfacade.com/calculate/), click
**Try it free**, and choose **Create a new scored form**. (Already have the
quiz as a Google Form? See [Start from an existing Google
Form](#start-from-an-existing-google-form) instead.)
*Figure: The 'How do you want to build your scored form?' screen with options Assign points to your Google Forms, Create a new scored form (highlighted), and Convert a PDF to a scored form. Choose Create a new scored form to have Formfacade draft the quiz for you.*
2. **Name the form**
Type the form's name, here *Cybersecurity Awareness Quiz*, and click
**Create form**. Formfacade drafts the questions from the name.
*Figure: The 'Name your form to build it' screen, with 1 the name field showing Cybersecurity Awareness Quiz and 2 the Create form button. 1 Name the form, then 2 click Create form.*
3. **Review the suggested questions and click Proceed**
Formfacade suggests a form based on the name: here 15 multiple-choice
questions plus a **Score** field (16 fields in all). Click **Make changes**
to adjust it, or **Proceed** to create it. The new form opens in the
Formfacade editor; click **No** when it asks whether to preview it.
*Figure: The suggested Cybersecurity Awareness Quiz form, with 1 the drafted questions (16 fields) and 2 the Proceed button next to Discard. 1 Check the drafted questions, then 2 click Proceed to create the form.*
4. **Describe the scoring in plain English**
Click the chat button at the bottom left of the editor to open **Customize
form**, describe how to score the quiz, and click **Send**. This quiz used:
*"Give 1 point for each correct answer (15 points total). Hide the score
while filling and show it after submit. 13-15 points: 'Security pro!' 8-12
points: 'Solid, but brush up.' 0-7 points: 'Please complete the security
training.'"*
Formfacade puts the points on every option: **+1** on the correct answer and
**0** on the others. Check that it picked the right answers; to change one,
click the question and use **Assign points to each option** (the first icon
under it). If a change goes wrong, **Revert** at the top of the panel undoes it.
*Figure: The editor with the Customize form panel open, with 1 the scoring instruction that was sent and 2 the points next to each option of question 1: +1 for the correct answer, 0 for the others. 1 The scoring instruction, sent from Customize form. 2 The points it assigned: +1 for the correct answer, 0 for the rest.*
5. **Make the Score field add up the points**
The **Score** field at the end of the form holds each respondent's total.
Click it, open its settings (the gear) and the **Answer** tab, and check two
things:
- **Appearance** is **Hidden**, so respondents don't see the score while
they answer.
- **Calculate** is `POINTS()`, which adds up the points of every answer. If
it's anything else (for example `SCORESUMMARY()`), replace it with
`POINTS()`: the messages in the next step compare against this number.
Then click **Save**.
*Figure: The Score field's Answer settings, with 1 Appearance set to Hidden, 2 the Calculate formula POINTS(), and 3 Save. 1 Appearance: Hidden. 2 Calculate: POINTS(), the total of every answer's points. 3 Save.*
6. **Show a message based on the score**
Click the **Submit** button at the end of the form, open its **On submit**
tab, and choose **Show conditional message based on score**. Then click
**Edit**. (**Redirect to a webpage**, in the same list, sends respondents to
a page instead of showing a message.)
*Figure: The Submit button's On submit tab, with 1 Show conditional message based on score selected, listing a message for each score range, and 2 the Edit button. 1 Show conditional message based on score, then 2 Edit to set the messages.*
Under **Conditional message based on**, pick **Score**. Then add one
condition per score range, from the highest down, ending with **Else** for
everything below:
| If Score is | Message |
| --- | --- |
| Greater than or equal to 13 | Security pro! |
| Greater than or equal to 8 | Solid, but brush up. |
| Else | Please complete the security training. |
Click a condition to change its threshold and message, and **+ Condition**
to add another range. To show the score itself, click **@** in the message
toolbar and pick **Score**; it appears as a token like `${entry…}` and
becomes the respondent's score. Here every message ends with *"You scored
@Score out of 15."* Click **Save** here, then **Save** in On submit.
*Figure: The Conditional message panel, with 1 Conditional message based on Score, 2 the three conditions and their messages, and 3 the + Condition button. 1 Base the message on Score, 2 write one message per score range, and 3 add more ranges with + Condition.*
#### The result
Open **PREVIEW** and take the quiz. The Score field stays hidden while you
answer, and after **Submit** the message matches the score. All 15 correct:
*Figure: The thank-you page after submitting the quiz with every answer correct, reading 'Security pro! You scored 15 out of 15.'. 15 out of 15: the 13–15 message.*
Only 5 correct:
*Figure: The thank-you page after submitting the quiz with 5 correct answers, reading 'Please complete the security training. You scored 5 out of 15.'. 5 out of 15: the Else message.*
#### Start from an existing Google Form
If the quiz is already a Google Form, start from it instead of creating a new one:
1. **Start at formfacade.com/calculate**
Go to [formfacade.com/calculate](https://formfacade.com/calculate/), click
**Try it free**, and choose **Assign points to your Google Forms**.
2. **Paste your Google Form**
Paste your form's link, or pick it from Drive, to bring it into Formfacade.
3. **Describe how to score it in plain English**
Instead of filling in a points grid, you **describe the scoring in your own
words**, for example *"Give 1 point for each correct answer, then show the
total score after submit."* You can also describe what to show for each score
range. Click **Send** and Formfacade sets it up.
*Figure: The 'Describe how you want to score this form' screen, with 1 the plain-English instruction box and 2 the Send button. 1 Describe the scoring in plain English (points, when to show the score, and what to say for each result), then 2 click Send.*
From there you're in the same editor: check the points, the score, and the
message on submit as in steps 4–6 of [Build the quiz](#build-the-quiz).
#### Supported question types
| Question type | Points supported |
| --- | --- |
| Dropdown | ✅ |
| Multiple choice | ✅ |
| Checkboxes | ✅ |
| Likert scale | ✅ |
| Linear scale | ✅ |
| Grid | ✅ |
#### Next steps
- Autofilling fields from a sheet instead of scoring? See [Sheets Lookup](https://docs.formfacade.com/products/sheets-lookup).
- Emailing each respondent their result? See [Email notification](https://docs.formfacade.com/products/email-notification).
- Writing your own score formulas? See [Score functions](https://docs.formfacade.com/reference/score-functions).
---
### File upload
> Let anyone upload files through your Google Form without a Google account. Files up to 1GB+ sync straight to your Google Drive, auto-renamed, with type and count limits.
Chapter 2: Products
Source: https://docs.formfacade.com/products/file-upload
**How can people upload files to my Google Form without signing in?**
Import your form at formfacade.com/file-upload. Formfacade makes a copy that converts the Google Forms file-upload field into an HTML upload anyone can use without a Google account. Turn on 'Submit to Google Forms' in Advanced settings, save, then share or embed. Uploaded files (up to 1GB+) are auto-renamed and synced to your Google Drive folder, while answers flow to your linked Google Sheet.
#### The problem it solves
The moment you add a **file-upload** question to a Google Form, Google forces
every respondent to **sign in with a Google account**, and the native form
can't be embedded cleanly on your own site. That login wall quietly kills
submissions from customers, applicants, and anyone outside your organization.
File Upload removes the wall: it replaces Google's login-gated uploader with a
plain **HTML upload** anyone can use, and routes the files to **your Google
Drive** when the form is submitted.
#### Watch the walkthrough
Video: [Embed Google Forms with file uploads, no Google login required](https://www.youtube.com/watch?v=6rvS3x368Js)
#### What you can do
| Capability | What it does |
| --- | --- |
| **Collect files without login** | Converts the Google Forms file-upload field into an HTML upload so respondents don't need a Google account. |
| **Large files & limits** | Accept files up to 1GB and beyond, set the max files per upload, and enforce file-type restrictions. |
| **Sync to Google Drive** | Files are automatically renamed and synced to your Google Drive folder when the form is submitted. |
| **Free up Drive space** | Access files from secure cloud storage built on Google's infrastructure instead of consuming your personal Drive quota. |
| **Control access** | Add collaborators to restrict files to specific users, or enable public links for anyone with the link. |
| **Automate the workflow** | Enable unlisted links and integrate with Apps Script, Zapier, or other Google Workspace add-ons. |
| **Easy for respondents** | Drag and drop on desktop, or snap a photo with the phone camera on mobile. |
#### Set it up
1. **Start at formfacade.com/file-upload**
Go to [formfacade.com/file-upload](https://formfacade.com/file-upload/) and
click **Import Google Form** (or **Create new form** to build one from
scratch).
*Figure: The Formfacade File Upload landing page with Import Google Form and Create new form buttons. formfacade.com/file-upload: start by importing your Google Form.*
2. **Paste your form link and Import**
Paste your Google Form link, or click **Browse** to pick it from Google
Drive, then click **Import**. Formfacade creates a **copy** of your form with
file-upload-without-sign-in enabled. Your original form is left untouched.
A progress bar shows while your questions are copied, then the editor opens.
*Figure: The import screen: Make a copy of Google Form and enable file upload without sign-in, with 1 the link field and 2 the Import button. 1 Paste a link (or Browse from Drive), then 2 Import to create the upload-enabled copy.*
> **Want to keep your original form?**
> The import flow makes a copy. If you'd rather add uploads to your existing
> form instead, use the **file upload add-on** linked on this screen
> ("Prefer to keep your original form?"). The steps below cover the import
> (copy) flow shown in the video.
3. **Preview or keep editing**
You're taken into the Formfacade interface and, after a moment, asked **"Do
you want to preview this form?"** Click **Yes** to preview it as a
respondent would, or **No** to keep editing. Make any layout or branding tweaks you want in
[Preview & Customize](https://docs.formfacade.com/guides/design).
*Figure: The Formfacade editor showing a 'Do you want to preview this form?' dialog with No and Yes buttons. Preview the form, or choose No to continue editing.*
4. **Turn on “Submit to Google Forms” (don’t skip this)**
Click the **Advanced setting** (gear) icon on the form header, open the
**Advanced** tab, and make sure **Submit to Google Forms** is toggled **on**.
It's usually already on for an imported copy, but check. Then click
**Save**. Without it, submissions won't flow back to Google Forms and your
linked Google Sheet.
*Figure: The form header with the Advanced setting gear icon highlighted. Open Advanced setting from the gear icon on the form header.*
*Figure: The settings panel: 1 the Advanced tab, 2 the Submit to Google Forms toggle switched on, 3 the Save button. 1 Advanced tab → 2 Submit to Google Forms on → 3 Save.*
5. **Share or embed your form**
Open **Share** to hand out the form. The **Link** tab gives you a short
`near.tl` URL with **Copy**, **Share**, and **Open**. The other tabs cover
**Email**, a printable **QR code**, **WhatsApp**, **Website**, and **Embed**.
**More options** also covers adding collaborators, adding contacts, creating
prefill links, and emailing the form to fill.
*Figure: The Share screen: 1 the Link, Email, QR code, WhatsApp, Website, and Embed tabs, 2 Copy, Share, and Open for the near.tl link. 1 Pick how to share, or 2 on the Link tab, copy, share, or open the near.tl link.*
For a React or Next.js app, use the component covered in
[React & Next.js](https://docs.formfacade.com/products/embed/react-nextjs); for other
platforms, see [Embed in website](https://docs.formfacade.com/products/embed).
#### Viewing responses & uploaded files
Once **Submit to Google Forms** is on, every submission shows up in two places:
Formfacade's **Responses** and your **Google Form / Google Sheet**. The
uploaded file rides along as an attachment on the response.
1. **Find the submission on the Kanban board**
Open **Responses**, then **Kanban board**, to see each submission as a card
on the status board: **Abandoned**, **Submitted**, **Completed**, and
**Trash**. A new upload lands in **Submitted**.
*Figure: Responses: 1 the Kanban board view, 2 a new response card in the Submitted column. 1 Responses → Kanban board; 2 the new submission appears as a card under Submitted.*
2. **Open the response and the uploaded file**
Click the card to see every answer. The file-upload question shows the file
as an **attachment chip**. Click it to open the file in a new tab. The
panel also confirms **Google Forms: Submitted** and links to the live
**Form page**.
*Figure: The response panel: 1 the uploaded file as an attachment chip, 2 Google Forms: Submitted. 1 The uploaded file appears as a chip. Click it to open in a new tab. 2 Google Forms confirms the submission.*
3. **Follow it into Google Forms & Sheets**
Everything also lands in Google. In **Responses → Google Forms**, click
**View in Google Forms** (or open its **▾** menu and choose **View responses
in Google Forms**). The same menu has **Stop submitting to Google Forms** if
you ever want to turn syncing off.
*Figure: Responses → Google Forms: 1 the View in Google Forms button, 2 its menu with View responses in Google Forms and Stop submitting to Google Forms. 1 View in Google Forms, or 2 its menu: View responses in Google Forms.*
The form opens in Google Forms on its **Responses** tab, with your response
there too. Click **Link to Sheets** to send responses to a Google Sheet.
*Figure: Google Forms: 1 the Responses tab showing 1 response, 2 the Link to Sheets button. In Google Forms: 1 Responses, 2 Link to Sheets to send them to a spreadsheet.*
##### What lands where
| What | Where it lands |
| --- | --- |
| **Uploaded files** | Auto-renamed and synced to your chosen **Google Drive** folder / secure cloud storage |
| **Form answers** | Your **linked Google Sheet**, plus the Google Forms response view |
| **In Formfacade** | Manage submissions on the [Responses](https://docs.formfacade.com/guides/responses) board and in [Reports](https://docs.formfacade.com/guides/reports) |
Because answers keep flowing to Google exactly as described in
[Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets), the file sits
alongside the rest of the response. There's nothing special to wire up once
**Submit to Google Forms** is on.
#### Handling, storage & access
| Area | Detail |
| --- | --- |
| **Max file size** | Up to 1GB and beyond |
| **Type restrictions** | Enforced. You choose the allowed types |
| **Max files** | Configurable per upload session |
| **On submit** | Files auto-renamed and synced to your Drive folder |
| **Storage** | Secure cloud storage on Google's infrastructure (keeps your Drive quota free) |
| **Access** | Collaborator-restricted, public links, or unlisted links for automation |
| **Respondent UX** | Desktop drag-and-drop · mobile camera capture |
> **Unlisted links for automation:**
> Enable unlisted links when you want Apps Script or Zapier to pick up each
> uploaded file automatically, for example, attaching it to a ticket or a CRM
> record.
#### Next steps
- Embedding in a React/Next.js app (as in the video)? See [React & Next.js](https://docs.formfacade.com/products/embed/react-nextjs).
- Pre-filling respondent details before they upload? See [Prefill & Send](https://docs.formfacade.com/products/prefill-and-email).
- Confirming the upload by email? See [Email notification](https://docs.formfacade.com/products/email-notification).
---
### Email notification
> Send a personalized confirmation email on every Google Forms submission, with the respondent's own answers merged into the subject and body. No code.
Chapter 2: Products
Source: https://docs.formfacade.com/products/email-notification
**How do I send a confirmation email when someone submits my Google Form?**
Use Formfacade's Email Notification. Import your form at formfacade.com/collaboration and click Add notifications. Pick which field holds the respondent's email, write a subject and body, and insert the respondent's own answers with the @ menu. Submit a test to confirm, and from then on every submission sends a personalized email automatically. You can also notify your team on each new response.
Email Notification turns a plain Google Form into an **automated onboarding
experience**: the moment someone submits, they get a branded, personalized email
built from their own answers. No scripts, no mail merge.
#### Use case
You're hosting a live workshop, **"Building Real-Time AI Agents with MCP Toolbox
& BigQuery."** When a developer registers, they should immediately get a
confirmation that greets them by name, lists the prerequisites, and includes the
date, time, and meeting link, with their chosen focus area echoed back so they
can correct it. That's exactly what Email Notification sets up.
#### Set it up
1. **Import your form and add notifications**
Go to [formfacade.com/collaboration](https://formfacade.com/collaboration/),
click **Import Google Form**, paste your form's link (or Browse from Drive),
and click **Add notifications**.
*Figure: The 'Add email notifications to your Google Form' screen, with 1 the link field and Browse, and 2 the Add notifications button. 1 Paste the form link, then 2 click Add notifications to start.*
2. **Pick the respondent's email field**
Formfacade opens the **Responses** tab and asks which form question holds the
respondent's email address. It usually detects and selects it for you.
Optionally let respondents edit their response and join the workflow, then
click **Next**.
*Figure: The Email respondent dialog, with 1 the field that holds the respondent's email, 2 the option to let them edit their response, and 3 Next. 1 Choose which field is the respondent's email (usually auto-detected), 2 optionally let them edit their response, then 3 Next.*
3. **Write the subject with form fields**
Type the email subject. Insert the respondent's own answers by typing **@**
and picking a field (and `RESPONSEID()` for a unique reference). Here the
subject becomes *"Confirmed: AI Agents & BigQuery Workshop 🚀 - @Full Name"*.
*Figure: The email subject step, with 1 the subject field and 2 the @ menu listing form fields (Full Name, Email Address, primary focus, GitHub Username). 1 Type @ in the subject line, then 2 pick the form field to merge.*
4. **Write the body with form fields**
Compose the email in the rich-text editor: headings, **bold**, *italic*,
lists, images, and links. Insert fields with the **@** button in the toolbar;
they appear as tokens like `${entry…}` and resolve to each respondent's
answer when the email is sent.
*Figure: The email body editor with a drafted workshop confirmation, with 1 the @ button in the toolbar and 2 a merged field in the greeting. Draft the body and insert fields with 1 the @ button. 2 Each field shows as a token that becomes the respondent's answer.*
5. **Test it**
Formfacade prompts you to **test** the notification. Click through to submit a
real response to your form, then check whether the email arrives.
*Figure: The Test email notification step, with 1 the Click here link to submit a response and 2 the No and Yes buttons. 1 Submit a test response, then 2 confirm whether the email arrived.*
#### The result
Seconds after the test submission, the email lands in the inbox, with the
subject and body **filled in from the answers**: it's addressed to *Jordan Diaz*,
the subject reads *"Confirmed: AI Agents & BigQuery Workshop 🚀 - Jordan Diaz"*,
and the focus area shows the selected *Software Development*.
*Figure: The received message in Gmail, with 1 the subject, 2 the greeting, and 3 the focus area filled in from the respondent's answers. The delivered email: 1 the subject, 2 the greeting, and 3 the focus area all show the respondent's own answers.*
Back in the interface, click **Yes** (you got the email) and Formfacade confirms
you're done. Every future submission now sends this email automatically.
*Figure: A 'You are all set!' confirmation saying users should receive an email notification when they submit the form. You're all set. New submissions trigger the email from now on.*
#### Also available
The flow above sends a **confirmation to the respondent**. Email Notification can
also:
- **Notify your team**: email you and chosen collaborators on every new response.
- **Brand the email**: add your logo, personalize the message, and format the text.
- **Work from Gmail**: open a response in Gmail to edit it, add notes, and update its status.
#### Next steps
- Emailing each respondent a quiz result? Pair this with [Assign Points](https://docs.formfacade.com/products/assign-points).
- Sending prefilled forms by email instead? See [Prefill & Send](https://docs.formfacade.com/products/prefill-and-email).
- Managing responses as a team board? See [Responses](https://docs.formfacade.com/guides/responses).
---
### Prefill & email
> Prefill Google Forms and send them as email. Make a named prefill link for a group, or email each contact their own link, and lock or hide the answers you prefill.
Chapter 2: Products
Source: https://docs.formfacade.com/products/prefill-and-email
**How do I send a Google Form with answers already filled in?**
Import your Google Form with Prefill & email. In the Share tab, use Create prefill links to make a named link with answers filled in, then copy it and send it. To email each person their own link, add them under Add contacts, click Compose, and send. Set a question's Appearance to Read only or Hidden so people can't change what you prefilled.
Prefill & email fills in the answers you already know, so people only answer
the rest. Unlike a Google Forms prefill link, the link carries only a name you
choose, such as `near.tl/sm/AbC12dEf/intro-to-sheets`. The values aren't in the
address, and you can lock them or hide them.
This guide follows one example: feedback for a workshop called "Intro to
Google Sheets", where the workshop details are prefilled and locked.
#### How do I start?
Click **Try it free** on the [Prefill & email page](https://formfacade.com/prefill/).
The wizard has three steps: **Import Google Form**, **Prefill this form**, and
**Send prefilled links**. To build a new form from its name or a PDF, click
**←** and pick another way to start.
*Figure: How do you want to prefill your form? with Import your Google Forms, Enter your form name, and Upload a PDF to prefill and send. Three ways to start. Start a form explains each one.*
When you name a new form, Formfacade asks **Who are the prefilled links
for?**
*Figure: Step 3 of 4, Prefill this form: 1 Contacts, a link for each person, 2 Groups, a link for each group. 1 Contacts: one link for each person, sent by email. 2 Groups: one named link you share with many people.*
| Choose | You get | Use it for |
| --- | --- | --- |
| **Contacts** | A link for each person, with their name and email filled in | Renewals, follow-ups, anything personal |
| **Groups** | One named link, such as a promo code or a region | A workshop, a branch, a campaign |
#### How do I stop people changing a prefilled answer?
Every question is editable by default. Lock or hide it before you share:
1. On the **Edit** tab, click the question, then its gear icon.
2. Click **Answer** and change **Appearance**:
- **Read only**: people see the value as plain text and can't change it.
- **Hidden**: the question isn't on the form, but its value is saved with the response.
3. Click **Save**.
> **Prefill every required read-only question:**
> A read-only question has no answer box. If it's required and the link
> doesn't fill it in, people can't submit the form.
[Question settings](https://docs.formfacade.com/guides/question-settings) covers every Appearance option.
#### How do I create a secure prefill link?
1. **Open Create prefill links**
Click the **Share** tab. Under **More options**, click **Create prefill
links**, then **+ Create new prefill**.
*Figure: The Share tab: 1 the SHARE tab, 2 Create prefill links under More options. 1 Share, then 2 Create prefill links.*
2. **Name the link and fill in the answers**
Enter a **Link name**. Spaces become hyphens, so use letters, numbers, and
hyphens. Fill in the answers you want prefilled, then click **Create
prefill link**.
*Figure: Create prefill link: 1 Link name near.tl/sm/AbC12dEf/intro-to-sheets, 2 Workshop Title, Location, and Instructor filled in, 3 Create prefill link. 1 The link's name, 2 the answers to prefill, 3 Create prefill link.*
If you fill in a name or email here, it's replaced by each contact's own
details when you send the link by email.
3. **Copy the link**
The link appears under **Group prefill links**. Click **3 fields** to see
what it fills in, **Preview** to open it, and **Copy link** to share it.
The **⋮** menu has **Compose email**, **Edit**, and **Remove**.
*Figure: Group prefill links: 1 the three prefilled fields, 2 Preview, 3 Copy link. 1 The prefilled answers, 2 Preview, 3 Copy link.*
#### What do people see when they open the link?
The form opens with your answers in place. Read-only answers show as plain
text. Editable ones are filled in, and people can change them.
*Figure: The prefilled form: 1 Workshop Title shown as read-only text, 2 Workshop Location and Instructor Name filled in and editable. 1 Read only: shown, not editable. 2 Editable: filled in, can be changed.*
#### How do I send bulk emails with a personalized prefill link?
1. **Add your contacts**
Click the **Share** tab, then **Add contacts** under **More options**.
Click **Add contact**, then **Add new contact**. Enter a **Name** and
**Email** (required) and click **Save**.
To bring in a list, choose **Import contacts** instead. It opens a Google
Sheet: add your contacts there, click **Extensions > Formfacade - Prefill &
email > Formprefill**, then **Sync now**.
2. **Compose the email**
Tick the contacts you want, or click **⋮ > Compose** on one contact.
*Figure: All contacts with one contact: 1 Add contact, 2 Compose in the contact's menu. 1 Add contact, or 2 Compose an email to a contact.*
The **Email** tab opens with **To**, **Subject**, and **Message** filled
in. The message uses `${name}` for each person's name and
`${prefilllink("Click here")}` for their link. Click **Prefill form** to
choose the answers in the link, then **Create prefill link**.
3. **Send**
Edit the message if you like, then click **Send email**. The subject and
message are saved under **Mail template** for next time. Each person gets
their own link, with their name and email filled in.
#### Where do the responses go?
Prefilled answers are saved with each response, including hidden ones. See
them on the [Responses](https://docs.formfacade.com/guides/responses) tab, or link a sheet in
[Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets). Each contact's **⋮ >
History** shows what was sent to them.
#### Questions
##### Does Formfacade support pre-filled links like native Google Forms?
Yes. The difference is the link: a Google Forms prefill link carries every
value in its address, while a Formfacade link carries only its name.
##### How do I edit the message before sending the email?
Change the **Subject** and **Message** in the **Email** tab before you click
**Send email**. Keep `${prefilllink("Click here")}` in the message, or the
email won't include the link.
##### How do I connect two Google Forms?
Use the answers from the first form to prefill a link to the second. The
[step-by-step guide](https://formfacade.com/prefill/how-to-connect-two-google-forms-step-by-step-guide.html)
compares four ways to do it.
##### How do I set a field as protected health information?
On the question's **Question** tab, tick **Mark this as Protected Health
Information**. See [Question settings](https://docs.formfacade.com/guides/question-settings).
#### Next steps
- Lock, hide, or calculate answers: [Question settings](https://docs.formfacade.com/guides/question-settings).
- Fill answers from a spreadsheet as people type: [Autofill fields](https://docs.formfacade.com/products/sheets-lookup/autofill-fields).
- Email each response after submit: [Email notification](https://docs.formfacade.com/products/email-notification).
---
## Chapter 3: Build your form
### The editor
> The Formfacade Edit page maps every control: toolbars, AI editing, form settings (Header, Appearance, Advanced), configure fields, page order, and what happens after submit.
Chapter 3: Build your form
Source: https://docs.formfacade.com/guides/editor
**How do I edit my form in Formfacade?**
After importing, you land on the Edit page. It works like the Google Forms editor: add questions, titles, images, videos, or pages from the right-hand toolbar, and use the form toolbar to preview, add a banner, change the layout, or open Settings (Header, Appearance, Advanced). You can also edit the form in plain English with the AI button, and set what happens after submit: a default message, a custom message, or a redirect.
When you import a form, you land on the **Edit** page, your home base for
structuring the form. It feels just like the Google Forms editor, with a few
Formfacade extras: AI editing, banner images, layout controls, and
redirect-on-submit. This page maps **every** control on it.
#### The Edit canvas at a glance
Two toolbars do most of the work: the **form toolbar** (on the form card) and
the **add toolbar** (down the right edge). The round button in the bottom-left
opens the AI editor.
*Figure: The Edit page: 1 the form toolbar on the form card, 2 the add toolbar on the right edge, 3 the AI editor button in the bottom-left. 1 Form toolbar, 2 add toolbar, 3 AI editor.*
**Form toolbar**: acts on the whole form.
| Icon | Control | What it does |
| --- | --- | --- |
| 👁️ | **Preview** | See exactly how the live form looks; close with ✕ |
| 🖼️ | **Banner image** | Opens a file picker to upload a header banner |
| ▦ | **Change layout** | Jumps to **Settings → Appearance** to change layout & theme |
| ⚙️ | **Advanced setting** | Opens the settings panel (Header, Appearance, Advanced) |
**Add toolbar**: adds new blocks to the form.
| Icon | Adds |
| --- | --- |
| ➕ | A new **question** |
| T | A **title & description** block |
| 🖼️ | An **image** |
| ▶️ | A **YouTube video** |
| ▬ | A new **page** |
#### Editing a question
Click a question to edit it inline. Change its text, its options, or its type
(Short answer, etc.), and toggle **Required**. Each question card also has quick
actions: **preview**, **duplicate**, and **delete**.
For field-level control, open the question's **⚙️ Advanced setting**, which has
two tabs: **Question** and **Answer**.
**Question**: the title, a *Mark this as required field* checkbox, and optional
**Description**, **Placeholder**, and **Title image**.
**Answer**: how the field behaves.
| Answer setting | What it does |
| --- | --- |
| **Appearance** | **Editable**, **Read only**, **Office use**, or **Hidden**. This is how you **hide a field** from respondents |
| **Prefill** | Show a default answer when the form loads |
| **Calculate** | Custom **formulas**. Type `@` for form fields and `=` for functions (with *Get help from AI*) |
| **Validation** | Configure input rules for the answer |
*Figure: A question's Answer tab: 1 the Appearance dropdown with Editable, Read only, Office use, and Hidden, 2 the Calculate formula box. A question's Answer tab: 1 set Appearance (for example, Hidden), 2 add a Calculate formula, or configure validation.*
[Question settings](https://docs.formfacade.com/guides/question-settings) explains each of these, with
examples.
For branching and other advanced logic, use **Launch** (in the **Advanced**
settings tab) to edit the underlying Google Form.
#### Edit with AI (beta)
The button in the **bottom-left** opens the AI editor. Describe what you want in
plain English, like *"add a Contact Details section and update the Name and Email
fields"*, and Formfacade makes the change for you.
*Figure: The Customize form (Beta) AI panel with a plain-English input and a Send button. Describe changes in plain English and click Send; the AI edits the form.*
> **Beta feature:**
> AI editing is in beta. You can use **Revert** at any time to undo its changes
> and go back.
#### Preview, banner & layout
The three left-most toolbar icons are quick actions:
- **👁️ Preview**: opens a full preview of the live form. Close it with ✕.
- **🖼️ Banner image**: opens your file browser to upload a banner.
- **▦ Change layout**: jumps straight to **Settings → Appearance**, where you
pick a layout and theme, then click **Save**.
#### Form settings (the ⚙️ panel)
The **⚙️ Advanced setting** icon opens a panel with three tabs.
##### Header
Edit the form's **Title** and **Description** (a rich-text editor with bold,
italic, strikethrough, links, lists, images, tables, quotes, and field
mentions), and add a **Banner**.
##### Appearance
Choose a **Layout Style** (**Compact**, **Comfortable**, or **Default**) and
set the theme (colors and fonts). This is the same panel the **Change layout**
button opens.
*Figure: The Appearance tab showing layout styles and theme colors. Appearance: layout style + theme colors and fonts.*
> **Note:**
> All theming (Minimal vs Colorful, presets, colors, fonts) is documented in one
> place: [Design](https://docs.formfacade.com/guides/design).
##### Advanced
Controls for the underlying form and its behavior:
| Setting | What it does |
| --- | --- |
| **Edit this form with Google Forms → Launch** | Opens the underlying Google Form to edit questions in Google Forms |
| **Locale** | Sets the form's language |
| **Close this form** | Stops the form from accepting responses |
| **Show progress bar** | Shows respondents how far through the form they are |
| **Submit to Google Forms** | Forwards responses into the Google Form. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets) |
| **Custom CSS** | Add your own CSS to style individual form elements (e.g. `.ff-form`, `.ff-form input`) |
#### Configure key fields
The **Configure key fields** button (at the bottom of the settings panel, or
next to **After page 1** below your questions) opens a panel with two tabs
that tell Formfacade how to *identify and summarize* each response:
- **Respondent**: *Get name from*, plus optional **Email**, **Phone**, and
**Customer id** fields, and *Ask users to login at this page*.
- **Notes**: optional **Subject**, **Details**, **Attachments**, and
**Line 1–3**.
*Figure: The Configure key fields panel on its Respondent tab: Get name from, optional Email, Phone, and Customer id, and Ask users to login at this page. Configure key fields: map which answers identify each respondent.*
These mappings power the [Responses board](https://docs.formfacade.com/guides/responses),
reports, and email notifications, so each response shows a name, subject, and
details instead of raw answers.
#### Rearrange pages
For multi-page forms, the **Rearrange pages** button lists your pages so you can
drag them into a new order.
#### After submit: message & redirect
Scroll to the bottom to the **Submit** block. The dropdown controls what
respondents see after they submit:
| Option | Result |
| --- | --- |
| **Default message** | Google Forms' standard *"Your response has been recorded."* |
| **Custom message** | Your own thank-you message (with alignment and font size) |
| **Redirect to webpage** | Send respondents to any URL after they submit |
The **Submit setting** icon (⚙️, next to **After page 1**) exposes the same
choices in a panel with two tabs. **Button** sets the **Caption** and
**Language**; **On submit** sets the confirmation behavior plus message
**alignment** and **font size**.
*Figure: The On submit tab: Show Google Forms confirmation message (selected), Show customized message for this button, and Redirect to a webpage, then alignment and font size. On submit: keep the default message, customize it, or redirect to a webpage.*
[After submit](https://docs.formfacade.com/guides/after-submit) covers the message, redirects, and the
button's text and language.
#### Prefer a visual editor?
Below the submit block, **Prefer a WYSIWYG editor?** offers a **Switch** to a
what-you-see-is-what-you-get editing mode.
#### Next steps
- Hide, lock, or calculate answers: [Question settings](https://docs.formfacade.com/guides/question-settings).
- Style and brand your form in [Design](https://docs.formfacade.com/guides/design).
- Share or embed it from [Share your form](https://docs.formfacade.com/guides/share).
---
### Question types
> Every question type you can add in the Formfacade editor, what each one is for, and how to add it. Likert, frequency, ranking and voting questions are built from a multiple choice grid.
Chapter 3: Build your form
Source: https://docs.formfacade.com/reference/question-types
**How to add a question type to Google Forms?**
Open your form in Formfacade and click the Edit tab. Click the + icon (Add field) in the toolbar on the right, enter your question and select the type in the question type list. Google Forms has no number, Likert, frequency or ranking question, so you build those from a short answer with validation or a multiple choice grid.
Pick the type that fits your question. Each row links to its section below.
Scales, grids, dates, and times are on
[Scales, grids, and dates](https://docs.formfacade.com/reference/scales-grids-and-dates).
| Question type | Use it for | How to add it |
| --- | --- | --- |
| [Short answer](#short-answer) | Names, phone numbers, website URLs and other answers in a few words | Leave the type as **Short answer** |
| [Paragraph](#paragraph) | Long answers in one or more paragraphs | Select **Paragraph** |
| [Email address](#email-address) | A valid email address | **Short answer** with **Text** and **Email** validation |
| [Number](#number) | An age, a quantity or a percentage | **Short answer** with **Number** validation |
| [Multiple choice](#multiple-choice) | One answer from a short list | Select **Multiple choice** |
| [Checkboxes](#checkboxes) | One or more answers from a list | Select **Checkboxes** |
| [Dropdown](#dropdown) | One answer from a long list | Select **Dropdown** |
#### How to add a question?
1. **Open your form on the Edit tab**
[Import your Google Form](https://docs.formfacade.com/getting-started/start-a-form). Your form opens on
the **Preview** tab. Click the **Edit** tab.
2. **Add the question**
Click the **+** icon (**Add field**) in the toolbar on the right and enter
your question. A new question is already a **Short answer**.
3. **Pick the type**
Select the type in the question type list. Turn on the **Required** toggle
button to make it a mandatory question.
**Validation.** To check an answer, click on the ⚙️ icon at the bottom right of
the question, select the **Answer** tab and click **Configure** under
**Validation**. Pick a rule, add a custom error message if you want one, and
click **Save**.
> **Options that are only in Google Forms:**
> **Shuffle row order**, **Limit to one response per column**, **Include year**
> and **Duration** are set in Google Forms. Click on the form's title, click on
> the ⚙️ icon, select the **Advanced** tab and click **Launch** next to **Edit
> this form with Google Forms**. Click on the ⋮ icon on the question and select
> the option. Then reload the form's **Edit** tab in Formfacade, so that your
> form picks up the change.
#### Text answers
##### Short answer
For answers in a few words: names, email addresses, phone numbers and website
URLs. Leave the question type as **Short answer**. To restrict answers, open
**Validation** and pick a rule: **Text** (**Contains**, **Doesn't contain**,
**Email**, **URL**), **Length** (**Minimum character count**, **Maximum
character count**), **Number** or **Regular expression**. People see your error
message until the answer fits.
[Full article](https://formfacade.com/website/google-forms-question-types-short-answer-text.html)
##### Paragraph
For long answers with one or more paragraphs. Select **Paragraph**. There is no
character or word limit by default. For a character limit, open **Validation**,
select **Length** and then **Maximum character count** or **Minimum character
count**. For a word limit, select **Regular expression**, select **Contains**
and enter a pattern such as this one, which allows up to 300 words:
```text
^\W*(\w+(\W+|$)){1,300}$
```
[Full article](https://formfacade.com/website/google-forms-question-types-paragraph.html)
##### Email address
Add a **Short answer**, open **Validation**, select **Text** and **Email**. You
can put it anywhere in the form, label it your way and make it required or
optional. The other way is **Collect email addresses** in Google Forms (Settings
tab, Responses, **Responder input**), but then Email is always the first field,
can't be optional and is always labelled Email address. With Formfacade, don't
turn on "Send responders a copy of their response". Use
[Email notification](https://docs.formfacade.com/products/email-notification) for confirmation emails.
[Full article](https://formfacade.com/website/google-forms-question-types-collect-email-address.html)
##### Number
Google Forms has no number question. Leave the type as **Short answer**, open
**Validation**, select **Number** and pick a rule: **Is number**, **Whole
number**, **Between**, **Not between**, **Equal to**, **Not equal to**, **Less
than**, **Less than or equal to**, **Greater than** or **Greater than or equal
to**. A question with **Is number** validation is treated as a number, so you
can use it in a [calculation](https://docs.formfacade.com/reference/functions#calculated-fields).
[Full article](https://formfacade.com/website/google-forms-question-types-number.html)
#### Choices
##### Multiple choice
For one answer from a short list (fewer than 10 choices works best). Select
**Multiple choice**, type the first answer choice, then click **Add Option** for
each next one. Click the **add "Other"** link to let people type their own
answer. To send people to a page based on their answer, click on the ⚙️ icon,
click **+ Go to page** and pick **Continue to next page**, a page or **Submit
form** for each choice.
[Full article](https://formfacade.com/website/google-forms-question-types-multiple-choice.html)
##### Checkboxes
For one or more answers from a list. Select **Checkboxes**, add your answer
choices with **Add Option**, and click **add "Other"** if you need it. To limit
how many boxes people can tick, open **Validation** and select **Select at
least**, **Select at most** or **Select exactly**, then enter the number.
[Full article](https://formfacade.com/website/google-forms-question-types-checkboxes-multi-select.html)
##### Dropdown
For one answer from a long list, such as a country or a department. Select
**Dropdown** and add each choice with **Add option**, or paste the whole list
from a spreadsheet into the first answer option. Formfacade turns a dropdown with
more than 1000 choices into a search box. Use multiple choice instead when people
should see every choice, or when you want images on the choices or an "Other"
option.
[Full article](https://formfacade.com/website/google-forms-question-types-dropdown.html)
#### Next steps
- Scales, grids, dates, and times: [Scales, grids, and dates](https://docs.formfacade.com/reference/scales-grids-and-dates).
- Hide, lock, or validate a question: [Question settings](https://docs.formfacade.com/guides/question-settings).
- Calculate an answer: [Calculated fields](https://docs.formfacade.com/reference/functions).
---
### Scales, grids, and dates
> Linear scales, grids, Likert, frequency, ranking and voting questions, and date and time questions in Formfacade, with what each is for and how to add it.
Chapter 3: Build your form
Source: https://docs.formfacade.com/reference/scales-grids-and-dates
**How to add a Likert scale to Google Forms?**
Google Forms has no Likert question, so build it from a multiple choice grid: one row per statement and one column per answer, such as Strongly disagree to Strongly agree. Frequency and ranking scales and voting questions are built the same way. Linear scales, dates, and times are their own question types.
These question types are added the same way as the others: on the **Edit**
tab, click the **+** icon (**Add field**), enter the question, and pick the type.
See [Question types](https://docs.formfacade.com/reference/question-types) for text and choice questions.
#### Scales and grids
##### Linear scale
For a number on a scale you set, with a label at each end, such as satisfaction
from 1 to 5. Select **Linear scale**, update the scale and add labels for each
end. The scale starts from 0 or 1 and ends on a whole number from 2 to 10. For
the standard NPS question, set it from 0 to 10.
[Full article](https://formfacade.com/website/google-forms-question-types-linear-scale.html)
##### Multiple choice grid
For many items with the same answer choices, one answer per row. Select
**Multiple choice grid** and add your questions in **Rows** and the answer
choices in **Columns**. Turn on **Requires a response in each row** so no row is
skipped. **Shuffle row order** and **Limit to one response per column** are set
in Google Forms.
[Full article](https://formfacade.com/website/google-forms-question-types-multiple-choice-grid.html)
##### Checkbox grid
Like a multiple choice grid, but people can tick several answers in each row.
Select **Checkbox grid** and add your questions in **Rows** and the answer
choices in **Columns**. Turn on **Requires a response in each row** and, in
Google Forms, **Limit to one response per column** to make it a ranking question.
[Full article](https://formfacade.com/website/google-forms-question-types-checkbox-grid.html)
##### Likert scale
Google Forms has no Likert scale question. Add a **Multiple choice grid** with
your statements in **Rows** and the Likert scale in **Columns**, and turn on
**Requires a response in each row**. For a single statement, use a **Multiple
choice** question with the Likert scale as its answer choices.
[Full article](https://formfacade.com/website/google-forms-question-types-likert-scale.html)
##### Frequency scale
Google Forms has no frequency scale question. Add a **Multiple choice grid**
with your statements in **Rows** and the frequency scale (Never, Rarely,
Sometimes, Often, Always) in **Columns**, and turn on **Requires a response in
each row**.
[Full article](https://formfacade.com/website/google-forms-question-types-frequency-scale.html)
##### Ranking scale
Google Forms has no ranking question. Add a **Multiple choice grid** with the
choices to rank in **Rows** and the ranks in **Columns**. Turn on **Requires a
response in each row**, then select **Limit to one response per column** in
Google Forms, so no two choices share a rank.
[Full article](https://formfacade.com/website/google-forms-question-types-ranking-scale.html)
##### Voting / Top n choices
Add a **Multiple choice grid**. For a vote, put the roles in **Rows** and the
candidates in **Columns**. For top choices, put the choices in **Columns** and
1st, 2nd, 3rd in **Rows**. Turn on **Requires a response in each row**, then
select **Limit to one response per column** in Google Forms, so nobody picks the
same candidate twice.
[Full article](https://formfacade.com/website/google-forms-question-types-voting-top-n-choices.html)
#### Dates and times
##### Date
For a travel date, a date of birth or a booking. Select **Date**. To ask for a
time too, click on the ⚙️ icon and tick **Include time** on the **Question**
tab. For a birthday without the year, deselect **Include year** in Google Forms.
Formfacade adds validation rules to date questions and can fill in today's date:
see [Date functions](https://docs.formfacade.com/reference/date-functions#examples).
[Full article](https://formfacade.com/website/google-forms-question-types-date-time.html)
##### Time & Duration
Select **Time** for a time in 12 hr AM/PM format. For hours, minutes and
seconds, select **Duration** on the question in Google Forms. Google Forms has no
24 hour setting. For 24 hr HH:MM time, use a **Short answer**, open
**Validation**, select **Regular expression** and **Matches**, and enter:
```text
^(0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]$
```
[Full article](https://formfacade.com/website/google-forms-question-types-time-duration.html)
#### Next steps
- Text and choice questions: [Question types](https://docs.formfacade.com/reference/question-types).
- Score a scale or grid: [Score functions](https://docs.formfacade.com/reference/score-functions).
- Calculate with dates: [Date functions](https://docs.formfacade.com/reference/date-functions).
---
### Question settings
> Hide a question, make it read only, prefill a default answer, calculate it with a formula, or add validation. Every setting is in the question's gear icon on the Edit tab.
Chapter 3: Build your form
Source: https://docs.formfacade.com/guides/question-settings
**How do I hide a field or make it read only?**
On the Edit tab, click the question, then its gear icon. Click Answer and change Appearance to Read only (people see it but can't change it) or Hidden (it isn't on the form, but its value is saved). Click Save. The same panel sets a default answer (Prefill), a formula (Calculate), and Validation.
Google Forms shows every question the same way. Formfacade adds settings to
each question, so you can hide it, lock it, fill it in for people, or work it
out from their other answers.
#### Where are the question settings?
1. Open the form's **Edit** tab.
2. Click the question. Its toolbar shows preview, duplicate, delete,
**Required**, and a gear icon.
3. Click the gear icon. A panel opens with two tabs: **Question** and
**Answer**.
4. Change what you need and click **Save**.
*Figure: A question's Answer tab: 1 the Appearance dropdown with Editable, Read only, Office use, and Hidden, 2 the Calculate formula box. The Answer tab: 1 Appearance, 2 Calculate. Prefill and Validation are in the same panel.*
#### The Question tab
| Setting | What it does |
| --- | --- |
| **Title** | The question's text |
| **Mark this as required field** | People must answer it before they submit |
| **Mark this as Protected Health Information** | Marks the answer as protected health information, for HIPAA forms |
| **Description** | Help text under the title |
| **Placeholder** | Grey hint text inside an empty answer box |
| **Title image** | An image next to the question's title |
Some types add their own options. For example, a date question has **Include
time**.
#### The Answer tab
| Setting | What it does |
| --- | --- |
| **Appearance** | **Editable**, **Read only**, **Office use**, or **Hidden** (below) |
| **Prefill** | An answer shown when the form loads. People can change it unless the question is read only |
| **Calculate** | A formula that fills in the answer. Type `@` to pick a question and `=` for a function |
| **Validation** | Rules the answer must meet, with **Configure** |
##### Is it possible to hide fields in Google Forms?
Yes. Set **Appearance** to one of these:
| Appearance | Respondents see it? | Can they change it? | Use it for |
| --- | --- | --- | --- |
| **Editable** | Yes | Yes | Normal questions (the default) |
| **Read only** | Yes, as plain text | No | A prefilled name, order number, or price |
| **Office use** | No | No | Answers your team fills in later |
| **Hidden** | No | No | A source, a customer ID, or a calculated value |
A hidden or read-only question is still saved with the response, so you can
see its value on the [Responses](https://docs.formfacade.com/guides/responses) tab and in your sheet.
> **Required and read only:**
> A read-only question has no answer box. If it's also required, give it a
> value with **Prefill**, **Calculate**, or a
> [prefill link](https://docs.formfacade.com/products/prefill-and-email), or people can't submit.
##### How do I prefill a default answer?
Type the answer in **Prefill**, for example `Online`. Everyone sees it filled
in when the form opens. To fill in a different answer for each person, use
[Prefill & email](https://docs.formfacade.com/products/prefill-and-email) instead. To prefill today's
date, use `TODAY()` in **Calculate**.
##### How do I add a calculated field?
Write a formula in **Calculate**. Type `@` to insert another question's
answer, and `=` to insert a function. If you're not sure how to write it,
click **Get help from AI** and describe the result you want.
A question with a formula fills in its own answer, so people don't type it.
[Calculated fields](https://docs.formfacade.com/reference/functions), [Date functions](https://docs.formfacade.com/reference/date-functions) and [Score functions](https://docs.formfacade.com/reference/score-functions) list every function, with examples such as
age from date of birth and days between two dates.
##### How do I add response validation?
Under **Validation**, click **Configure** and pick a type:
| Type | Checks |
| --- | --- |
| **Number** | Greater than, less than, equal to, between, a whole number, and more |
| **Text** | Rules for the text people type |
| **Length** | The number of characters |
| **Regular expression** | A pattern you write |
For numbers, compare with a fixed **Number** or with another **Field**, for
example "end date is greater than start date". Click **Delete validation** to
remove it.
##### Date questions
A **Date** question has its own validation rules: **Allow only past dates**,
**Allow only future dates**, **Allow only future dates with lead time**,
**Allow between two dates**, **Allow specific days of the week**, and
**Exclude specific dates**.
#### Only accept dates in a range
Click the date question's gear icon, select the **Answer** tab, and click
**Configure** under **Validation**. Select **Allow between two dates**, enter
the first and last date, and click **Save**.
[Full article](https://formfacade.com/website/google-forms-date-validations-check-date-within-range.html)
#### Only accept dates a set number of days ahead
To accept a date only if it is at least 7 days from today, open the date
question's **Validation** the same way, select **Allow only future dates with
lead time** and enter 7. The date picker starts 7 days from today, and an
earlier date can't be submitted. The same list has **Allow only past dates**,
**Allow only future dates**, **Allow between two dates**, **Allow specific days
of the week** and **Exclude specific dates**.
[Full article](https://formfacade.com/website/google-forms-date-validations-allow-submit-seven-days-in-advance.html)
#### How do I change the placeholder text?
Open the question's **Question** tab, click **+ Placeholder**, type the hint,
and click **Save**. Short answer and paragraph boxes in Google Forms always say
"Your answer". Your placeholder replaces it.
#### Two more buttons
The bottom of the panel has two more icons:
- **Rearrange fields**: move questions into a new order.
- **Configure key fields**: tell Formfacade which questions hold the
respondent's name, email, and phone. Email notifications and contacts use
them. See [The editor](https://docs.formfacade.com/guides/editor#configure-key-fields).
#### Next steps
- Write formulas: [Calculated fields](https://docs.formfacade.com/reference/functions).
- Lock answers you send in a link: [Prefill & email](https://docs.formfacade.com/products/prefill-and-email).
- Change what happens after submit: [After submit](https://docs.formfacade.com/guides/after-submit).
---
### Design
> Customize your form's look and feel in the Formfacade Preview tab: choose a Minimal or Colorful theme, set colors, background, and fonts, add your branding, and preview live before publishing.
Chapter 3: Build your form
Source: https://docs.formfacade.com/guides/design
**How do I customize how my Formfacade form looks?**
Open the Preview tab. Pick a base theme (Minimal or Colorful), then choose a color preset, set your primary and background colors, add a background image or make it transparent, and set fonts and size. Use the Page tab to add a logo, business name, and footer. Preview on desktop or mobile, then click Apply to save.
Once your form is structured in [the editor](https://docs.formfacade.com/guides/editor), the
**Preview** tab is where you customize its **look and feel**, one of
Formfacade's core selling points. Choose a theme, set your colors and fonts, add
your branding, and see the result live before you publish.
#### Entering Preview & the page-title prompt
If your site doesn't have a business name yet, opening **Preview** first asks
whether to change the default **page title**:
- **Yes** → opens the **Page** tab to set your branding (logo, business name,
footer, language).
- **No** → stays on the **Theme** tab so you can start styling right away.
*Figure: The Page title not configured prompt with Yes and No buttons. On entering Preview: Yes goes to the Page tab, No stays on the Theme tab.*
The right panel has three tabs: **Theme** (the form's visual style), **Layout**
(Compact, Comfortable, or Default), and **Page** (site-level branding).
#### Preview modes
At any time you can preview the form as it will really appear:
- **Desktop / Mobile**: toggle between the two device widths.
- **Open in new tab**: see the full, live form on its own.
*Figure: The form previewed in mobile width using the device toggle. Switch to the mobile view to check how the form looks on phones.*
#### Theme: Minimal vs Colorful
The **Theme** tab starts with two base themes. Both expose the same controls
(presets, colors, background, and typography); they just start from a different
look:
| | **Minimal** | **Colorful** |
| --- | --- | --- |
| **Look** | Clean, light, understated | Bold, with a colored header band and richer palettes |
| **Best for** | Blending into an existing site | Making the form a branded centerpiece |
| **Presets** | Custom, Default, Blossom pink, Celadon green, Sky blue, Forest green, Persian indigo | Default, Blossom pink, Celadon green, Sky blue, Mauve purple, Persian indigo, Indigo dark, Yale blue |
*Figure: The Theme tab with Minimal selected and its preset palette. Minimal: a clean, understated base with light presets.*
*Figure: The Theme tab with Colorful selected and its richer preset palette. Colorful: a bold header band with deeper, more vivid presets.*
Whichever base you pick, the controls below work the same way.
##### Theme options (presets)
Pick a ready-made palette, or choose **Custom** to define your own. Colorful adds
several deeper options (Mauve purple, Indigo dark, Yale blue) for a more vivid
look.
##### Colors
Set the **Primary color** (buttons, accents) and the **Background**. Match these
to your brand's palette.
##### Background settings
- **Background image**: upload your own image behind the form.
- **Make form background transparent**: let the form blend into the page or
site it's embedded on.
##### Typography settings
Choose separate fonts for **Headings** and **Paragraph** text, and set the
overall **Font size** with the slider (Smaller → Larger).
#### Page (branding)
The **Page** tab sets your brand details, shown around the form:
| Field | What it sets |
| --- | --- |
| **Logo** | Upload a logo (PNG, JPG, or WebP) |
| **Business name** | Your name as it appears in branding |
| **Footer** | Footer text, e.g. copyright info |
| **Language** | The form's display language |
*Figure: The Preview panel, with 1 the Page tab and 2 its Logo, Business name, Footer, and Language fields. 1 The Page tab, with 2 logo, business name, footer, and language.*
#### Apply your changes
> **Always click Apply:**
> Whatever you change (theme, colors, background, fonts, or branding), you must
> click **Apply** to save it to your form. Nothing takes effect until you do.
#### How to modify styles using CSS?
When the theme options don't go far enough, add your own CSS:
1. Open the **Edit** tab and click the form's title.
2. Click the gear icon (⚙️) and open the **Advanced** tab.
3. Paste your CSS into **Custom CSS** and click **Save**.
Formfacade's elements have `ff-` class names, such as `.ff-title` for the
form's title. Right-click an element on your form and choose **Inspect** to
find its class. For a worked example, read
[How to modify styles using CSS in a Google Form](https://formfacade.com/website/modify-styles-using-css-in-google-forms.html).
#### Next steps
- Share or embed your styled form from [Share your form](https://docs.formfacade.com/guides/share).
- Change what happens after submit: [After submit](https://docs.formfacade.com/guides/after-submit).
---
### After submit
> Choose what people see after they submit. Keep the Google Forms message, show your own thank-you message with their answers in it, or redirect to a webpage. Change the Submit button's text and language.
Chapter 3: Build your form
Source: https://docs.formfacade.com/guides/after-submit
**How can I change the confirmation message shown after form submission?**
On the Edit tab, scroll to the end of the form and click the gear icon (Submit setting) on the After page row. On the On submit tab, choose Show customized message for this button and write your message, or choose Redirect to a webpage and enter the address. Click Save. The Button tab changes the Submit button's caption and language.
Google Forms ends every form with "Your response has been recorded." With
Formfacade you can thank people in your own words, show them their answers,
or send them to your own page.
#### Where are the after-submit settings?
1. Open the form's **Edit** tab and scroll to the end of the form.
2. On the last **After page** row (it says **After page 1** on a one-page
form), click the gear icon. Its tooltip says **Submit setting**.
3. A panel opens with two tabs: **Button** and **On submit**.
*Figure: The On submit tab: Show Google Forms confirmation message (selected), Show customized message for this button, and Redirect to a webpage, then alignment and font size. On submit: keep the Google Forms message, write your own, or redirect.*
#### What can happen after submit?
| On submit option | What people see |
| --- | --- |
| **Show Google Forms confirmation message** | "Your response has been recorded" (the default) |
| **Show customized message for this button** | Your own message, formatted, with their answers if you like |
| **Redirect to a webpage** | The page you choose, for example your own thank-you page |
##### Can I customize the thank you message shown after form submission?
Yes. Choose **Show customized message for this button** and type the message
in the editor. Use the toolbar to format it with bold text, images, and links.
Under **Submit
message**, set **Align message to** (Left, Center, or Right) and **Font size**
(Normal, Medium, Large, or X-Large). Click **Save**.
##### How can I use the form response to personalize the confirmation message?
In the message, click the **@** icon in the toolbar and pick a question.
Formfacade inserts the question as `${...}`, and each person sees their own
answer in its place, for example "Thanks, Jane. We'll reply to jane@example.com within a
day." Read the
[full article](https://formfacade.com/website/show-form-response-in-google-forms-confirmation-message.html)
for more examples.
##### How can I redirect respondents to another webpage after submitting?
Choose **Redirect to a webpage** and enter the address, such as
`https://www.example.com/thank-you`. You can add answers to the address, like
`?name=value`.
To send people to different pages, click **Try advanced redirects** and
describe what you want, for example "send Enterprise picks to /book-a-call,
everyone else to /thanks with their email in the URL."
> **Note:**
> The **Assign points** guide shows a score message after submit, with a
> different message for each score range. See
> [Assign points](https://docs.formfacade.com/products/assign-points).
#### How can I change the Submit button text?
Open the **Button** tab and type the new text in **Caption**, such as "Send
request". Leave it empty to keep the default. Click **Save**.
#### Can I change the language for the button text?
Yes. Google Forms picks the button language from each respondent's own
settings, so one form can show Submit in English to one person and in French
to the next. In Formfacade, choose a **Language** on the **Button** tab. It
applies to this form only, so Next, Back, and Submit match the language your
form is written in.
#### Is there a way to change the button color or font styles?
Yes, in the form's design rather than here. See [Design](https://docs.formfacade.com/guides/design).
#### Next steps
- Email people their answers too: [Email notification](https://docs.formfacade.com/products/email-notification).
- Change the form's look: [Design](https://docs.formfacade.com/guides/design).
- Fix "the form goes to Google Forms on submit": [Troubleshooting](https://docs.formfacade.com/reference/troubleshooting#formfacade-form-redirects-to-google-forms-page-on-submit-how-can-i-fix-this).
---
## Chapter 4: Formulas
### Calculated fields
> Write a formula in the Calculate option of a Formfacade question to work out an answer from other answers, such as a total, a price, or a label chosen with IFS.
Chapter 4: Formulas
Source: https://docs.formfacade.com/reference/functions
**How to add a calculated field in Google Form?**
Google Forms does not support calculations in the form. In Formfacade, click on the ⚙️ icon of a question, select the Answer tab and write a formula in the Calculate option, such as Price * Quantity or TODAY(). Type @ to add another question to the formula. The value is shown in real time to the person filling in the form and is saved with the response.
Every formula goes in the **Calculate** option of a question. The value shows
while people fill in the form, and it's saved in your Google Form with the rest
of the response, so it reaches Google Sheets too. Dates and scores have their
own functions: see [Date functions](https://docs.formfacade.com/reference/date-functions) and
[Score functions](https://docs.formfacade.com/reference/score-functions).
#### Where do I write a formula?
1. **Open your form on the Edit tab**
[Import your Google Form](https://docs.formfacade.com/getting-started/start-a-form). Your form opens on
the **Preview** tab. Click the **Edit** tab.
2. **Add the question that shows the result**
Click on the **+** icon (**Add field**) in the toolbar on the right and enter
the question, such as "Total amount". The examples on this page use a
**Short answer** for a number and a **Date** question for a date.
3. **Open the Answer tab**
Click on the ⚙️ icon at the bottom right of the question and select the
**Answer** tab.
4. **Write the formula**
Write the formula in the **Calculate** option. When you type **@**, you see
the list of all the fields in the form. Select one to add it to the formula.
Click **Save**.
- You see the display name of a field in the formula, but internally it uses
the entry id for the calculations.
- A question with a formula turns read only by itself, so people can't change
the value.
- To keep a calculated value off the form, change the question's
**Appearance** to hidden on the **Answer** tab.
> **Names in the formulas on this page:**
> A name such as `Price`, `date_of_birth` or `start_date` stands for a question
> you add to the formula with **@**.
#### Calculated fields
A calculated field works out its value from other fields. It can do arithmetic
on number fields and work with text and dates.
##### How to add a simple calculated field to a Google Form?
Calculations can only be performed on number fields. For each question you
calculate with, click on the ⚙️ icon, select the **Answer** tab, click
**Configure** under **Validation**, select **Number** and select **Is number**.
Then write the expression in the **Calculate** option of the result question:
```text
Price * Quantity
```
Use `+`, `-`, `*`, `/` and parentheses, as in the examples on this page.
[Full article](https://formfacade.com/website/google-forms-calculated-fields.html)
##### Conditional logic with IFS
The IFS function evaluates multiple conditions and returns the value for the
first true condition.
```text
IFS(condition1, value1, [condition2, value2, …])
```
- `condition1`: the first condition to be evaluated.
- `value1`: the value returned if condition1 is TRUE.
- `condition2, value2, …`: more conditions and values, used if the first one is
false.
In this order form, a bottle costs $60, or $50 for 10 or more. Shipping is $25,
or free for orders above $150.
```text
IFS(Quantity >=10 , 50, 60) * Quantity
IFS(Order amount > 150, 0, 25)
Order amount + Shipping fees
```
The first formula goes in **Order amount**, the second in **Shipping fees** and
the third in **Total amount**.
[Full article](https://formfacade.com/website/how-to-add-a-calculated-field-in-google-form-on-1FAIpQLSeooiyPfimYtFV-LlN3uiXUNu3QbPzVxCa33BCSGrPR2AqwcA.html)
#### Next steps
- Work with dates: [Date functions](https://docs.formfacade.com/reference/date-functions).
- Add up points: [Score functions](https://docs.formfacade.com/reference/score-functions).
- Hide or lock the result: [Question settings](https://docs.formfacade.com/guides/question-settings).
---
### Date functions
> Formfacade's date functions DATE, TODAY, NOW, ADD, SUBTRACT and DIFF, with formulas for age, days between two dates, end dates, and more.
Chapter 4: Formulas
Source: https://docs.formfacade.com/reference/date-functions
**How do I calculate dates in Google Forms?**
Google Forms can collect a date but can't calculate one. In Formfacade, write a date function such as TODAY(), ADD, SUBTRACT, or DIFF in the Calculate option of a question. People see the result while they fill in the form, and it's saved with the response.
Write these formulas in the **Calculate** option of a question, as described in
[Calculated fields](https://docs.formfacade.com/reference/functions#where-do-i-write-a-formula). Put a
formula that returns a date in a **Date** question.
| Function | Syntax | Returns | Example |
| --- | --- | --- | --- |
| DATE | `DATE(year, month, day)` | A date from a year, month and day | `DATE(2020, 9, 25)` |
| TODAY | `TODAY()` | The current date | `TODAY()` |
| NOW | `NOW()` | The current date and time | `NOW()` |
| ADD | `inputdate.add(number, term)` | The date with seconds, minutes, hours, days, months or years added | `TODAY().add(3,"days")` |
| SUBTRACT | `inputdate.subtract(number, term)` | The date with seconds, minutes, hours, days, months or years subtracted | `TODAY().subtract(6,"months")` |
| DIFF | `enddate.diff(startdate, unit)` | The number of seconds, minutes, hours, days, months or years between two dates | `TODAY().diff(DATE(1950,12,12),"years")` |
[Full article](https://formfacade.com/website/google-forms-date-calculations-formfacade-functions.html)
##### DATE
Converts a year, month and day into a date.
```text
DATE(year, month, day)
```
- `year`: the year component of the date.
- `month`: the month component of the date.
- `day`: the day component of the date.
```text
DATE(2020, 9, 25)
DATE(2020, 12, 12)
```
##### TODAY and NOW
`TODAY()` returns the current date. `NOW()` returns the current date and time.
```text
TODAY()
NOW()
```
##### ADD
Adds seconds, minutes, hours, days, months or years to a date or date & time.
```text
inputdate.add(number, term)
```
- `inputdate`: the date to use. This can be a date or date & time question, or
a formula that returns a date or date & time.
- `number`: the number to add.
- `term`: `"seconds"`, `"minutes"`, `"hours"`, `"days"`, `"months"` or
`"years"`.
```text
TODAY().add(3,"days")
TODAY().add(6,"months")
TODAY().add(2,"years")
NOW().add(3,"hours")
NOW().add(25,"minutes")
NOW().add(10,"seconds")
```
##### SUBTRACT
Subtracts seconds, minutes, hours, days, months or years from a date or date &
time.
```text
inputdate.subtract(number, term)
```
- `inputdate`: the date to use. This can be a date or date & time question, or
a formula that returns a date or date & time.
- `number`: the number to subtract.
- `term`: `"seconds"`, `"minutes"`, `"hours"`, `"days"`, `"months"` or
`"years"`.
```text
TODAY().subtract(3,"days")
TODAY().subtract(6,"months")
TODAY().subtract(2,"years")
NOW().subtract(3,"hours")
NOW().subtract(25,"minutes")
NOW().subtract(10,"seconds")
```
##### DIFF
Calculates the number of seconds, minutes, hours, days, months or years between
two dates or date & time values.
```text
enddate.diff(startdate, unit)
```
- `enddate`: the end date. This can be a date or date & time question, or a
formula that returns a date or date & time.
- `startdate`: the start date, in the same forms as `enddate`.
- `unit`: the unit of the result: `"seconds"`, `"minutes"`, `"hours"`,
`"days"`, `"months"` or `"years"`.
```text
TODAY().diff(DATE(1950,12,12),"years")
TODAY().diff(DATE(2020,06,18),"months")
TODAY().diff(DATE(2020,09,27),"days")
```
##### Parts of a date
| Function | Returns | Example |
| --- | --- | --- |
| `year()` | The year | `TODAY().year()` |
| `month()` | The month | `TODAY().month()` |
| `date()` or `getDate()` | The day of the month | `TODAY().date()` |
| `getDay()` | The day of the week, a number from 0 (Sunday) to 6 (Saturday) | `TODAY().getDay()` |
##### Subtracting one date from another
When you subtract one date from another, the result is in milliseconds. Divide
it to get the unit you need:
| To get | Divide by |
| --- | --- |
| Seconds | `1000` |
| Minutes | `(60 * 1000)` |
| Hours | `(60 * 60 * 1000)` |
| Days | `(24 * 60 * 60 * 1000)` |
#### Examples
##### How to calculate the age based on date of birth entered by the user?
```text
TODAY().diff(date_of_birth, "years")
```
Add a **Date** question for the date of birth and a **Short answer** for the
age, and write the formula in the age question. The form shows the age as soon
as the date of birth is entered.
[Full article](https://formfacade.com/website/google-forms-calculate-age-based-on-date-of-birth-entered-by-user.html)
##### How to calculate the days between two dates?
```text
((Leave Till - Leave From) / (24 * 60 * 60 * 1000)) + 1
```
The difference between two dates is in milliseconds, so divide it by
24 * 60 * 60 * 1000 for days, and add 1 to include the start date. For example,
2 November to 6 November gives 5.
[Full article](https://formfacade.com/website/google-forms-calculate-number-of-days-between-two-dates.html)
##### How to add days, months or years to a date?
```text
Inputdate.add(5,"days")
Inputdate.add(3,"months")
TODAY().add(1,"years")
```
Write the formula in a **Date** question. The new date shows as soon as the
input date is entered.
[Full article](https://formfacade.com/website/google-forms-date-calculations-add-days-months-years-to-a-date.html)
##### How to subtract days, months or years from a date?
```text
Inputdate.subtract(7,"days")
Inputdate.subtract(2,"months")
TODAY().subtract(1,"years")
```
Write the formula in a **Date** question. The new date shows as soon as the
input date is entered.
[Full article](https://formfacade.com/website/google-forms-date-calculations-subtract-days-months-years-from-a-date.html)
##### How to calculate the end date based on the start date and term duration selected by the user?
```text
start_date.add(number_of_months, "months")
```
Here the term is a **Dropdown** with the number choices 3, 6 and 12, and the
formula goes in an **End date** question. If the choices are text, such as
3 months, 6 months and 1 year, turn them into numbers with IFS:
```text
start_date.add(IFS(subscription == "3 months", 3, subscription == "6 months", 6, subscription == "1 year", 12, 1),"months")
```
[Full article](https://formfacade.com/website/google-forms-dynamically-calculate-end-date-based-on-start-date-and-term-duration.html)
##### How to calculate the number of days left in a month?
```text
DATE(TODAY().year(), TODAY().month()+1, 0).date() - TODAY().date()
```
`DATE(TODAY().year(), TODAY().month()+1, 0)` is the last day of this month, so
its `date()` is the number of days in the month. Subtracting today's day of the
month leaves the days remaining. The form works it out again each day.
[Full article](https://formfacade.com/website/google-forms-calculate-number-of-days-left-in-a-month.html)
##### How to calculate the day of the week?
```text
TODAY().getDay()
```
The result is a number from 0 to 6, Sunday to Saturday, so on a Monday it is 1.
Change the question's **Appearance** to hidden and the day comes with every
response without your users seeing it.
[Full article](https://formfacade.com/website/google-forms-calculate-the-day-of-the-week.html)
##### How to calculate the start and end date of a work week?
```text
TODAY().add(7-TODAY().getDay(),"days")
week_start_date.add(6, "days")
```
Write the first formula in a **Week start date** question and the second in a
**Week end date** question. For a week from Sunday to Saturday, on Monday
2 November the next week starts on 8 November and ends on 14 November.
[Full article](https://formfacade.com/website/google-forms-date-calculations-find-start-and-end-date-of-work-week.html)
##### How to automatically fill today's date in the form?
```text
TODAY()
```
Write it in the **Calculate** option of a **Date** question. The form opens with
today's date filled in, and people can't change it, because a question with a
formula turns read only by itself.
[Full article](https://formfacade.com/website/automatically-fill-todays-date-in-google-forms-date-question.html)
To accept only dates in a range, or a set number of days ahead, use the date
question's validation rules. See
[Question settings](https://docs.formfacade.com/guides/question-settings#date-questions).
#### Next steps
- Write other formulas: [Calculated fields](https://docs.formfacade.com/reference/functions).
- Add up points: [Score functions](https://docs.formfacade.com/reference/score-functions).
- Lock today's date: [Question settings](https://docs.formfacade.com/guides/question-settings).
---
### Score functions
> Formfacade's score functions SCORE, GRIDSCORE and POINTS give answer choices points and add them into a score, per question, per section, or for the whole form.
Chapter 4: Formulas
Source: https://docs.formfacade.com/reference/score-functions
**How do I calculate a score in Google Forms with a formula?**
Set up Assign points, then write a score function in the Calculate option of the Score question. SCORE(scope, point-1, point-2, …) gives the answer choices their points, for example SCORE(ALL, 1, 2, 3, 4, 5) for every question. GRIDSCORE scores chosen rows of a grid question. Add scores together with +.
Score functions give points to answer choices and add them into a score. You
write them in the **Calculate** option of the Score question that Formfacade
adds when you set up [Assign points](https://docs.formfacade.com/products/assign-points). For the
step-by-step scoring walkthroughs, see that page.
##### Where to write these functions?
1. **Import your form for scoring**
In [Assign points](https://docs.formfacade.com/products/assign-points), import your Google Form: paste
its link or click **Browse** to pick it, then click **Next**.
2. **Finish the setup**
Under "Describe how you want to score this form", click **Next**. Under
"How do you want to score?", click **Next**. On "You're all set!", click
**Preview form**. Your form opens in a new tab.
3. **Open the Edit tab**
Back on the setup page, click **Share form** under **Manage**. Your form
opens on the **Share** tab. Click the **Edit** tab.
4. **Write the function**
Click on the Score question, then click on the gear icon. Click **Answer**,
delete the `POINTS()` that is already in the **Calculate** option, write the
function and click **Save**.
##### SCORE
Assigns points to the answer choices in multiple choice, checkboxes and grid
questions and calculates the total score.
```text
SCORE(scope, point-1, point-2, …, point-n)
```
- `scope`: which questions to score (see the table below).
- `point-1, point-2, … point-n`: the points for answer choices (a), (b), (c),
(d), (e) and so on, in order.
| Scope | Scores | Example |
| --- | --- | --- |
| `ALL` | All the questions in the form | `SCORE(ALL, 1, 2, 3, 4, 5)` |
| `SECTION` | All the questions in the section. Your form needs more than one section. | `SCORE(SECTION, 1, 2, 0.5, 0.25, 0.25)` |
| A question | One question. Type @ and select it to add its entry id. | `SCORE(entry###, -1, -2, 0, 2, 1)` |
| A search term | The questions whose description has the search term | `SCORE("Physical activity", 1, 2, 0.5, 0.25, 0.25)` |
With `SCORE(ALL,1,2,3,4,5)`, a person who picks (e), (d) and (c) in three
questions scores 5 + 4 + 3 = 12. To give each question its own points, add a
SCORE for each question:
```text
SCORE(entry#id, 1, 2, 3, 4, 5) + SCORE(entry#id, 2, 4, 6, 8, 10) + SCORE(entry#id, 5, 10, 15, 20, 25)
```
On a checkboxes question, SCORE adds up the points of every box ticked, and
points can be negative: `SCORE(entry#id, 1, 2, 2, 10, -3, -5, -6, -1)`. On a
multiple choice grid, the points apply to every row: `SCORE(entry#id, -1, 1, 0)`.
[Full article](https://formfacade.com/calculate/google-forms-calculate-scores-scorecery-score-functions.html)
##### GRIDSCORE
Assigns points to the answer choices for chosen rows of a grid question and
calculates the score. Your form needs a grid question for this.
```text
GRIDSCORE(question, rownum, point-1, point-2, … point-n)
```
- `question`: the entry id of the grid question. Type @ and select the question
to add it.
- `rownum`: the rows to score. `[2, 3, 5, 10]` selects rows 2, 3, 5 and 10.
- `point-1, point-2, … point-n`: the points for the answer choices in the
columns, in order from column 1.
```text
GRIDSCORE(entry###, [2, 3, 7, 8], 1, 2, 3, 4, 5)
GRIDSCORE(entry###, [1, 4, 5, 6], -2, -1, 0, 2, 1)
```
To score some rows in reverse, add two GRIDSCORE functions. This happiness
score is the average of 29 statements, 12 of them scored in reverse:
```text
(GRIDSCORE(entry#id, [2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26], 1, 2, 3, 4, 5, 6) + GRIDSCORE(entry#id, [1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29], 6, 5, 4, 3, 2, 1)) / 29
```
[Full article](https://formfacade.com/calculate/google-forms-assign-varying-points-multiple-choice-grid-question-calculate-score.html)
##### POINTS
When you set up scoring, the Score question's **Calculate** option already has
`POINTS()`. You can also point POINTS at part of the form:
- `POINTS(SECTION)` adds up only that section's answers, with the points you
set on each question. Add a Short answer question to each section and write
it in its **Calculate** option.
- `POINTS(question)` adds up one question. Type `POINTS(`, then type @ and
select a question, then type `)`. Type `+` and another POINTS for each
question, to make a score for one category.
```text
POINTS(SECTION)
POINTS(question_1) + POINTS(question_2) + POINTS(question_3)
```
[Full article](https://formfacade.com/calculate/assign-points-add-different-questions-calculate-multiple-scores-google-forms.html)
##### Adding scores together
To add section scores into an overall score, use the SUM() formula in the Score
question, with each section score added with @. Or select the score for each
section with `+` between them:
```text
section_1_score + section_2_score + section_3_score
```
You can also add the answers of linear scale questions directly. The P4 pain
questionnaire adds four 0 to 10 answers into a score from 0 to 40:
```text
pain_morning + pain_afternoon + pain_evening + pain_with_activity
```
[Full article](https://formfacade.com/calculate/assign-points-calculate-scores-for-each-section-google-forms.html)
#### Next steps
- Set up scoring step by step: [Assign points](https://docs.formfacade.com/products/assign-points).
- Show the score after submit: [After submit](https://docs.formfacade.com/guides/after-submit).
- Write other formulas: [Calculated fields](https://docs.formfacade.com/reference/functions).
---
## Chapter 5: Share and embed
### Share your form
> Share a Formfacade form by link, QR code, email, or WhatsApp; turn it into a website or embed it; and manage collaborators, contacts, and prefill links.
Chapter 5: Share and embed
Source: https://docs.formfacade.com/guides/share
**How do I share my Formfacade form?**
Open the Share tab. Copy the form link, print a QR code, or share by Email or WhatsApp with a custom message. You can also add the form to your hosted website or embed it on your own site. The More options list adds collaborators, contacts, prefill links, and a virtual email assistant.
Once your form is structured in [the editor](https://docs.formfacade.com/guides/editor) and
styled in [Design](https://docs.formfacade.com/guides/design),
it's time to share it. The **Share** tab gives you several ways to get the form
in front of people, plus tools for collaborators, contacts, and prefill links.
*Figure: The Share tab: 1 the Share via tabs (Link, Email, QR code, WhatsApp, Website, Embed), 2 the More options list. 1 Sharing methods on the left, 2 team and contact tools on the right.*
#### Share via: the six methods
The **Share via** panel has six tabs:
| Method | What it does | Where it's covered |
| --- | --- | --- |
| **Link** | Copy, share, or open the form's short link | Below |
| **Email** | Send the form by email with a custom message | Below |
| **QR code** | Print or edit a QR code for the form | Below |
| **WhatsApp** | Send the form with a message on WhatsApp | Below |
| **Website** | Add the form to your hosted website | [Share your form](https://docs.formfacade.com/guides/share) |
| **Embed** | Put the form on your own site or app | [Embed in website](https://docs.formfacade.com/products/embed) |
##### Link & QR code
- **Link** (the default tab): your short form link (e.g. `https://near.tl/sm/…`),
with **Copy**, **Share**, and **Open**.
- **QR code**: a QR code for the form with **Print** and **Edit**. Good for
posters, packaging, or events.
##### Email
Send the form to someone directly from Formfacade:
- Pick a **Mail template**, set the **To** address and **Subject**, and write a
**Message**.
- The message supports variables like `${name}` and
`${prefilllink("Click here")}`, and a **Prefill form** button to insert a
prefilled link.
- Click **Send email**.
*Figure: The Email tab: Mail template, To, Subject, 1 a Message with ${name} and ${prefilllink} variables, 2 the Prefill form button. Email: 1 a message with prefill variables, 2 Prefill form inserts a prefilled link.*
##### WhatsApp
Write a custom message (it includes the form link) and click **Send message** to
share over WhatsApp.
*Figure: The WhatsApp tab: 1 a custom message with the form link, 2 the Send message button. WhatsApp: 1 a custom message plus your form link, 2 Send message.*
##### Website & Embed
Two methods have their own in-depth guides:
- **Website**: your hosted site at `near.tl/your-name`, with **Copy**,
**Open**, and **Edit**. **Add to Quick Links** lists this form on the site,
or **Switch Form** makes it the site's main form. See
[Share your form](https://docs.formfacade.com/guides/share).
- **Embed**: choose where the form goes (WordPress, Squarespace, Google Sites,
React.js, React Native, Bootstrap, and more). Each target has its own guide in
[Embed in website](https://docs.formfacade.com/products/embed).
*Figure: The Embed tab asking Where do you want to embed this form?, with WordPress, Squarespace, Google Sites, React.js, React native, Bootstrap CSS, other website, and no website options. The Embed tab routes you to the right snippet for your platform.*
#### Collaborators, contacts & more
The **More options** list on the right of the Share screen opens related tools:
| Action | What it does | Where it's covered |
| --- | --- | --- |
| **Add collaborators** | Invite people to view or edit the form | Below |
| **Add contacts** | Build a contact list to email the form to | Below |
| **Create prefill links** | Generate per-recipient prefilled links | [Prefill & email](https://docs.formfacade.com/products/prefill-and-email) |
| **Email to fill form** | A virtual email assistant for the form | Below |
##### Collaborators & roles
Invite teammates and choose what they can do:
| Role | Can |
| --- | --- |
| **Owner** | View & edit the form, responses, reports **and** manage collaborators |
| **Editor** | View & edit the form, responses & reports |
| **Viewer** | View responses & reports |
*Figure: The Collaborators screen: 1 the Add collaborators button, 2 the invite dialog with Add people by email, a Viewer role, an optional message, and Share. Collaborators: 1 Add collaborators, 2 invite by email as a Viewer or Editor.*
##### Contacts
The **Contacts** screen is your address book for emailing the form. Add contacts
manually (**Add new contact**) or **Import contacts**, then filter and select
who to send to.
##### Prefill links
**Create prefill links** generates a per-recipient link with fields already
filled in. The recipient's details replace the placeholders when the email is
sent. This is a feature in its own right; see
[Prefill & email](https://docs.formfacade.com/products/prefill-and-email) for the full guide.
##### Email to fill form
Creates a **virtual email assistant**. Your business name becomes an email
address (`businessname@near.tl`) that customers can email to receive and fill
out your form.
#### Next steps
- Read submissions on the [Responses](https://docs.formfacade.com/guides/responses) board.
- Embedding on your own site? Start with [Embed in website](https://docs.formfacade.com/products/embed).
---
### Embed in WordPress
> Embed a Formfacade form in WordPress with the official Formfacade plugin. Install it, run the setup wizard, and the form is placed on your page automatically. No code to copy.
Chapter 5: Share and embed
Source: https://docs.formfacade.com/products/embed/wordpress
**How do I embed a Formfacade form in WordPress?**
Install the Formfacade plugin from Plugins → Add New and activate it. The setup wizard opens automatically: sign in with your Google account, pick an existing form (or paste your Google Form link / create a new one), choose the page to add it to, and click Proceed. Formfacade embeds the form on that page for you. No code to copy, and your WordPress theme styles apply automatically.
WordPress has its own **Formfacade plugin**, so embedding takes no code. The
plugin places the form on your page for you.
#### Steps
1. **Install the Formfacade plugin**
In your WordPress admin, go to **Plugins → Add New Plugin**, search for
**Formfacade**, click **Install Now**, then **Activate**.
*Figure: The WordPress Add Plugins screen, with 1 Add New Plugin in the Plugins menu and 2 Install Now on the Formfacade plugin. 1 Plugins → Add New Plugin → search “Formfacade” → 2 Install Now → Activate.*
2. **Run the setup wizard and sign in**
The embed **setup wizard** opens automatically. **Sign in with your Google
account** and click **Next**.
3. **Pick or create your form**
Choose an existing form, **create a new form**, or **copy & paste the link**
of the Google Form you want to embed. Click **Next**.
4. **Choose the page**
Select a page from the dropdown of your WordPress pages (or choose **create a
new page** and enter a page title), then click **Proceed**.
5. **Done: preview your form**
Formfacade **automatically embeds the form** on the selected page. Preview it;
your WordPress **theme styles apply to the form automatically**.
> **Manage the form later:**
> Edit the embedded form anytime from your WordPress dashboard: **Formfacade →**
> select the form to change its fields, appearance, and thank-you message.
> (Deeper customization is available on paid plans.)
> **Prefer not to use the plugin?**
> You can also embed the HTML snippet from
> [Share → Embed](https://docs.formfacade.com/guides/share) into a **Custom HTML** block,
> but the plugin is the simplest path on WordPress.
#### Next steps
- Embedding elsewhere too? See [Embed in website](https://docs.formfacade.com/products/embed).
- Style the form first in [Design](https://docs.formfacade.com/guides/design).
---
### Embed in Wix
> Embed a Formfacade form in Wix by pasting the embed code in an Embed HTML element. The form shows on your page without Google's branding.
Chapter 5: Share and embed
Source: https://docs.formfacade.com/products/embed/wix
**How to Embed Google Forms in Wix?**
Click on the Share tab, click Embed, select My website is different from above and copy the embed code. In your Wix editor, open the page, add an Embed HTML element and paste the embed code. Save and publish the page, and your form shows without Google's branding.
Wix lets you paste code into an **Embed HTML** element. If you paste Google's
embed code there, the form keeps the Google Forms look, and you can only change
its width and height. Paste Formfacade's embed code instead, and the form takes
your design. Responses still go to your Google Form, so you can sync them to
Google Sheets.
#### Steps
1. **Copy your embed code**
In Formfacade, open the **[Share](https://docs.formfacade.com/guides/share)** tab and click **Embed**.
Wix is not in the list, so under **Where do you want to embed this form?**,
select **My website is different from above** and click **Next**. Copy the
embed code. It looks like this, with your own IDs in it:
```html
```
2. **Add an Embed HTML element**
In your Wix editor, open the page where you want the form and add an
**Embed HTML** element.
3. **Paste the embed code**
Paste the embed code in the **Embed HTML** element. You can change the
element's width and height on the page.
4. **Save and publish**
Save and publish the page. Your form shows on your page without Google's
branding.
> **Wix shows the form in a frame:**
> Wix shows any embed code inside its own frame, so even with Formfacade the form
> is added as an iframe. Set your fonts and colors on the **Preview** tab in
> Formfacade so the form matches your site. See [Design](https://docs.formfacade.com/guides/design).
#### Want help matching your website?
Click **Next** on the embed code, select **Yes, I want to customize UI like my
website** and click **Next**. Enter the URL of your page and your message and
click **Submit**. The Formfacade team will contact you to help.
#### Form changes are not reflected in the embedded form
Edit the form your page uses, open it in Formfacade's editor and reload your
page. Reloading or clearing your browser's cache alone won't bring the change.
More fixes are in [Fix embed, add-on, and email problems](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails).
#### Next steps
- Embedding elsewhere too? See [Embed in website](https://docs.formfacade.com/products/embed).
- Set your fonts and colors in [Design](https://docs.formfacade.com/guides/design).
- Read the longer article: [How to Embed Google Forms in Wix?](https://formfacade.com/embed/embed-google-form-in-wix.html)
---
### React & Next.js
> Embed a Formfacade form in a React or Next.js app with the @formfacade/embed-react component, with props for prefill, submit, and load callbacks.
Chapter 5: Share and embed
Source: https://docs.formfacade.com/products/embed/react-nextjs
**How do I embed a Formfacade form in React or Next.js?**
Install @formfacade/embed-react, import the FormfacadeEmbed component, and pass your form's embed URL as formFacadeURL. Optional props handle prefill (prefillForm), submit (onSubmitForm), and load (onFormLoad). In Next.js App Router, render it in a Client Component.
For React and Next.js apps, Formfacade ships a dedicated component so the form
renders as a first-class part of your app. No raw `
```
4. **Paste it in your webpage**
Paste the embed code in the webpage where you want the form, then save or
publish the page. Your form shows on your webpage with no iframe and no
Google branding.
> **Send the answers to Google Sheets:**
> Click the **Responses** tab, click **Google Sheets**, click **Link to Sheets**,
> then click **Proceed**. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
#### What if my website is on Shopify or Webflow?
The default Google Forms embed can break on your website and cut off the form,
so use the Formfacade embed code instead.
##### Shopify
Select **My website is different from above**, copy the embed code and paste it
in the Shopify page where you want the form.
##### Webflow
Webflow works like any other website. Select **My website is different from
above**, copy the embed code, paste it in an **Embed** element on your Webflow
page, and publish the site.
#### 3 ways to put a Google Form on your website
| Way | How | Where it falls short |
| --- | --- | --- |
| Link to the form | Copy your form's link from Google Forms and put it on a button or in your menu. | Visitors leave your website to fill in the form, and some don't come back. |
| Google's Embed HTML | Open your Google Form, click the **More** (⋮) icon, select **Embed HTML**, copy the code and paste it in your webpage. | You can change only the width and height. The form keeps Google's look and the note at the bottom, a long form scrolls inside its own box, and a form with a file upload question can't be embedded. |
| Formfacade embed code | Copy the embed code from the **Share** tab and paste it in your webpage. | The free plan adds a small Formfacade attribution, and removing it needs a paid plan. |
##### Google Forms embed and Formfacade embed compared
| Feature | Google Forms embed | Formfacade embed |
| --- | --- | --- |
| Matches your website theme | No | Yes |
| Mobile responsive | No | Yes |
| File upload questions | Not supported | Supported |
| Prefill answers | No | Yes, via URL or JavaScript |
| Analyze with session recording tools | No | Yes |
| Mobile app and React support | No | Yes |
| Responses in Google Forms and Google Sheets | Yes | Yes |
#### How to match your form to your website colors and fonts?
- Click on the **Preview** tab.
- Set your **Primary color**, **Background** and **Typography** settings to
match your website.
- To keep these colors, click **Apply to all forms**. This changes every live
form on your account, not only this one. Your embed code works without it.
- To change the form layout, click the **Layout** tab. That button says
**Apply to this form**.
Every setting is in [Design](https://docs.formfacade.com/guides/design).
##### Want help matching your website?
Click **Next** on the embed code, select **Yes, I want to customize UI like my
website** and click **Next**. Enter the URL of your page and your message and
click **Submit**. The Formfacade team will contact you to help.
#### Troubleshooting
| Problem | Fix |
| --- | --- |
| Form changes are not reflected in the embedded form | Edit the form your page uses, open it in Formfacade's editor and reload your page. |
| Form redirects to Google Forms page on submit | Turn off **Limit to 1 response** and **Send responders a copy of their response** in your Google Form's settings, and send receipts from Formfacade instead. |
| Form responses are not recorded in Google Forms | Turn on **Submit to Google Forms** under **Responses** and send the missed responses from the Kanban board. |
| Form is not publicly visible | Publish your Google Form and turn off the options that need sign-in. Formfacade supports only public forms. |
More fixes are in [Fix embed, add-on, and email problems](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails).
#### Next steps
- Using Wix? See [Embed in Wix](https://docs.formfacade.com/products/embed/wix).
- Match your site's fonts and colors in [Design](https://docs.formfacade.com/guides/design).
- Read the longer articles: [How to Embed Google Forms in Website?](https://formfacade.com/embed/embed-google-form-in-website.html) and [3 ways to embed your Google Forms](https://formfacade.com/embed/embed-google-form.html)
---
## Chapter 6: Responses
### Responses
> View and manage submissions on Formfacade's Responses board: statuses like Abandoned, Submitted, Completed, and Trash, custom statuses, column actions, and the Google Forms and Sheets views.
Chapter 6: Responses
Source: https://docs.formfacade.com/guides/responses
**How do I view and manage responses in Formfacade?**
Open the Responses tab, then Kanban board, for a structured board that groups submissions into statuses: Abandoned, Submitted, Completed, and Trash. Drag cards between columns, add your own statuses, and use each column's ⋮ menu to search, notify people, print, or hide. The Google Forms view shows each response as the filled-in form, with View in Google Forms to open the underlying form (Summary, Question, Individual) and its linked Google Sheet.
Once your form is built, styled, and shared, it's time to read the responses.
You can always view them in the underlying Google Form and linked Sheet (see
[Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets)), but Formfacade
also gives you a **structured board** to organize and act on them.
#### The Responses tab
The **Responses** tab has a menu of views along the top: **Google Forms** (the
default), **Google Sheets**, **Kanban board**, and reports such as **Responses
by status**, **Responses by email**, and **Traffic source** (see
[Reports](https://docs.formfacade.com/guides/reports)).
#### The Kanban board
**Responses → Kanban board** is a status board that groups every submission
into columns you can drag between.
*Figure: Responses: 1 the Kanban board view, 2 the board with Abandoned, Submitted, Completed, and Trash columns, 3 the + STATUS button. 1 Responses → Kanban board, 2 submissions grouped by status, 3 + STATUS adds your own.*
It ships with four default statuses:
| Status | What it means |
| --- | --- |
| **Abandoned** | Someone started the form but didn't submit |
| **Submitted** | A completed submission |
| **Completed** | Your workflow's done state. Mark responses you've handled |
| **Trash** | Removed responses |
Each response is a **card** showing its number (e.g. `#2`), the respondent's
name, and how long ago it arrived. Click a card to open the response. **Drag a card** to another column to change
its status.
#### Add your own statuses
The four defaults are just a starting point. Click **+ STATUS** to add your own
columns. Rename, reorder (drag), or pin them, then **Save**. This lets the
board mirror your real workflow (e.g. *New → Contacted → Won*).
*Figure: The Add status panel listing pinned statuses, with 1 a New status field and 2 the Save button. 1 Type a new status (drag to reorder, pin to keep), then 2 Save.*
#### Column actions (the ⋮ menu)
Each column's **three-dot (⋮) menu** has actions for the responses in it. The
exact options depend on the column:
| Action | What it does |
| --- | --- |
| **Search** | Find responses within the column |
| **Contactable** | Filter to responses you can reach (e.g. Abandoned) |
| **Notify Abandoned** | Email people who didn't finish the form |
| **Notify respondent** | Email the person who submitted |
| **Notify approvers** | Email your approvers for review |
| **Notify collaborators** | Email your team |
| **Print** | Print the column's responses |
| **Hide** | Hide the column from the board |
| **Privacy** | Privacy options for the responses |
*Figure: The Submitted column's ⋮ menu: Search, Notify respondent, Notify approvers, Notify collaborators, Print, and Hide. The Submitted column's ⋮ menu: search, notify the right people, print, or hide.*
#### View in Google Forms & Sheets
**Responses → Google Forms** shows each response as the filled-in form. Page
through them with the arrows. **View in Google Forms** opens the underlying
Google Form on its **Responses** tab; its **▾** menu also has **Stop submitting
to Google Forms**.
*Figure: Responses: 1 the Google Forms view, showing a response as the filled-in form, 2 the View in Google Forms button. 1 Responses → Google Forms, 2 View in Google Forms.*
In Google Forms, the **Responses** tab shows:
- **Summary**: charts and aggregates per question.
- **Question**: every answer, one question at a time.
- **Individual**: one respondent at a time.
- **View in Sheets** (or **Link to Sheets** if no sheet is linked yet): open
the linked spreadsheet. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
*Figure: The Google Forms Responses tab with Summary, Question, and Individual views and View in Sheets. The same responses in Google Forms: Summary, Question, Individual, and View in Sheets.*
**Responses → Google Sheets** shows your responses as a table you can filter
and search, with its own **Link to Sheets** button.
> **Deletions are permanent:**
> Responses deleted in Google Forms can't be restored. If you might need a
> response later, move it to a status (like Trash) on the board instead of
> deleting it in Google Forms.
#### Next steps
- Summarize responses with [Reports](https://docs.formfacade.com/guides/reports).
- Automate follow-ups with [Email Responses](https://docs.formfacade.com/products/email-notification).
---
### Reports
> Analyze form responses in Formfacade Reports: built-in reports, custom columns and layouts, export to CSV/PDF, weekly/monthly/yearly views, and syncing to a dedicated Google Sheet.
Chapter 6: Responses
Source: https://docs.formfacade.com/guides/reports
**How do I report on responses in Formfacade?**
Open the Responses tab and pick a report from its view menu for a spreadsheet-style view of your responses. Use the built-in reports (Google Sheets, Responses by status, Responses by email, Traffic source), switch the date range or layout, and edit a report with the pencil to pick columns and organize it as a table, nested table, or matrix. Export to CSV/PDF, or click Link to Sheets to send every response to a Google Sheet.
Where the [Responses board](https://docs.formfacade.com/guides/responses)
is for *managing* submissions, **Reports** is for *analyzing* them, a
spreadsheet-style view you can filter, reshape, and export. Both live in the
**Responses** tab.
#### The built-in reports
Open **Responses** and pick a report from the view menu at the top. There are
four ready-made reports (plus **⊕ New report** to add your own):
| Report | What it shows |
| --- | --- |
| **Google Sheets** | Every response in a table: id, date, status, and your form fields |
| **Responses by status** | Responses grouped by their status |
| **Responses by email** | Responses grouped by respondent email |
| **Traffic source** | Where your responses came from |
*Figure: The Responses tab's view menu, with 1 the Google Sheets report, 2 the Responses by status, Responses by email, and Traffic source reports, and 3 New report. 1 Google Sheets, a spreadsheet-style view of your responses, 2 the other built-in reports, and 3 New report.*
#### Working with a report
Every report has a toolbar in the top-right:
- **Link to Sheets** (Google Sheets report): send every response to a Google
Sheet (see below).
- **Date range**: page through periods with `‹ Aug 9 – Aug 15 ›`.
- **View toggle**: switch between the standard columns view and **Columns to
rows** (which transposes fields into rows).
- **Search**: find values in the report.
- **Pencil**: edit the report (see below).
*Figure: The report toolbar: 1 Link to Sheets, 2 the date range, 3 the view toggle, 4 Search, 5 the pencil, and 6 the three-dot menu. 1 Link to Sheets, 2 date range, 3 view toggle, 4 search, 5 edit, 6 more options.*
#### Export, format & more (the ⋮ menu)
The three-dot menu holds the export and formatting actions:
| Action | What it does |
| --- | --- |
| **Export to CSV** | Download the report as a CSV file |
| **Download as PDF** | Download the report as a PDF |
| **Show/Hide columns** | Choose which columns appear |
| **Conditional formatting** | Color-code cells by rules |
| **Add collaborator** | Share the report with someone |
| **Make a copy** | Duplicate the report |
| **Switch to Weekly / Monthly / Yearly** | Change the reporting period |
*Figure: The report three-dot menu with Export to CSV, Download as PDF, and other options. Export, format, share, or switch the reporting period from the ⋮ menu.*
#### Create or edit a report
Click the **pencil** to edit a report, or **⊕ New report** to build one from scratch.
Either opens a short wizard:
1. **Name & reporting period**
Give the report a name and pick a **reporting period**: **Auto
[Recommended]**, Weekly, Monthly, or Yearly. Expand **More options** to
include abandoned responses.
2. **Customize columns**
Choose which column groups to include: **Summary**, **Other details**,
**Submitted from**, and **Calculated columns**. Expand each to pick
individual fields.
*Figure: The Customize columns step with Summary, Other details, Submitted from, and Calculated columns groups. Pick exactly which columns the report shows.*
3. **Organize & finish**
Choose how to lay it out (**Table**, **Nested table**, or **Matrix**), then
click **Finish**.
*Figure: The organize step, with 1 the Table, Nested table, and Matrix layouts and 2 the Finish button. 1 Organize the report as a table, nested table, or matrix, then 2 click Finish.*
#### Sync to a dedicated Google Sheet
On the **Google Sheets** report, click **Link to Sheets** to send every response
to a Google Sheet. The first time, this creates a dedicated Google Sheet for
reporting. It comes with two tabs, **Responses** and **Response Statuses**,
for a fuller view of your data.
*Figure: The synced Google Sheet with Responses and Response Statuses tabs. A dedicated reporting sheet with Responses and Response Statuses tabs.*
> **Note:**
> This is separate from linking the underlying Google Form to a sheet (see
> [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets)). It's a
> reporting-focused sheet Formfacade builds from your responses.
#### Next steps
- Manage submissions as a pipeline on the [Responses board](https://docs.formfacade.com/guides/responses).
- Automate follow-ups with [Email Responses](https://docs.formfacade.com/products/email-notification).
---
### Google Forms and Sheets
> Understand where Formfacade stores responses and how to stream every submission into a Google Sheet using Submit to Google Forms and Link to Sheets.
Chapter 6: Responses
Source: https://docs.formfacade.com/guides/google-sheets
**Where do my Formfacade responses go?**
When you import a form, Formfacade creates a managed copy that collects every submission. You can view responses right inside Formfacade's Responses tab. To also send them to a spreadsheet, make sure ‘Submit to Google Forms’ is on in Advanced settings (it usually is), go to Responses → Google Forms and click ‘View in Google Forms’ to open the underlying Google Form on its Responses tab, and click ‘Link to Sheets’.
When you import a form, Formfacade creates a **managed copy** of your Google
Form. Every response people submit is collected against that copy, and you have
two places to read them: the **Responses** tab inside Formfacade, and a linked
**Google Sheet**. This page explains that flow and how to turn on the Sheets
connection.
> **Responses go to the Formfacade copy, not your original form:**
> Don't worry if the original Google Form you imported from stays empty. Formfacade
> collects responses on its **own managed copy** of the form. That's by design:
> your responses are safe in Formfacade and in the Google Sheet you link below.
#### Where your responses live
Once your form is live, a single submission flows like this:
| Stage | What happens |
| --- | --- |
| Respondent submits | The submission is captured by the **Formfacade** |
| Submit to Google Forms | The response is forwarded into the linked **Google Form** |
| Link to Sheets | Google Forms appends the row to your linked **Google Sheet** |
You can read responses in **two** places: Formfacade's **Responses** tab (no
setup needed) and the **Google Sheet** (after you link it, below).
#### Step 1: Check “Submit to Google Forms” is on
This toggle forwards each submission into the underlying Google Form, which is
what feeds Google Sheets. When you import a form via the link method, it's
**usually already on**, but it's worth confirming.
1. **Open Advanced settings**
In the Formfacade editor, click the **⚙️ Advanced setting** button in the
toolbar next to your form's title.
*Figure: The Formfacade editor with the Advanced setting gear icon highlighted next to the form title. Click the ⚙️ Advanced setting button next to the form title.*
2. **Go to the Advanced tab and confirm the toggle**
In the panel that opens, select the **Advanced** tab. Make sure **Submit to
Google Forms** is toggled **on**. If it isn't, turn it on and click **Save**.
*Figure: The settings panel: 1 the Advanced tab, 2 the Submit to Google Forms toggle turned on, 3 the Save button. 1 Advanced tab, 2 confirm “Submit to Google Forms” is on, 3 Save.*
> **Save before you leave:**
> If you had to switch the toggle on, click **Save** before closing the panel.
> If responses aren't reaching Sheets later, this is the first setting to
> re-check.
#### Step 2: Open the underlying Google Form
In Formfacade, go to **Responses → Google Forms** and click **View in Google
Forms** (or open its **▾** menu and choose **View responses in Google Forms**).
This opens the Formfacade-managed copy of your Google Form in a new tab. This is the
form that actually stores your responses.
*Figure: The Responses tab: 1 the RESPONSES tab, 2 the View in Google Forms button with its menu open. 1 Responses (it opens on the Google Forms view), 2 View in Google Forms.*
#### Step 3: Link responses to Google Sheets
Now connect that Google Form to a spreadsheet so every submission streams in
live.
1. **Open Responses and click “Link to Sheets”**
In the Google Form, open the **Responses** tab and click **Link to Sheets**.
*Figure: Google Forms: 1 the Responses tab, 2 the Link to Sheets button. In the underlying Google Form: 1 Responses → 2 Link to Sheets.*
2. **Choose a destination spreadsheet**
Pick **Create a new spreadsheet** (Google names it after your form) or
**Select existing spreadsheet**, then click **Create**.
*Figure: The Select destination for responses dialog: 1 Create a new spreadsheet (selected), 2 Select existing spreadsheet, 3 the Create button. 1 Create a new spreadsheet, or 2 link an existing one, then 3 Create.*
Every new submission now appends to that sheet automatically, timestamp and all.
*Figure: A Google Sheet titled Support request (Responses) with Timestamp, Full name, and Email address columns and one response. Responses stream into the linked Google Sheet, one row per submission.*
#### Viewing your responses
You never have to leave Formfacade to read responses. The **Responses** tab's
**Kanban board** view gives you a status board (Abandoned, Submitted, Completed,
Trash) so you can track each submission through your workflow.
*Figure: The Formfacade Responses tab, Kanban board view, with a submitted response card. Formfacade's Responses tab: read and manage submissions without opening Sheets.*
So you have two synced views of the same data: the **Responses** board in
Formfacade and the **Google Sheet**. Use whichever fits the task.
> **Note:**
> Managing responses as a pipeline (statuses, assignments, and follow-ups) gets
> its own guide. For now, just know both views stay in sync once the sheet is
> linked.
#### Verify the sync
To confirm everything is wired up end to end:
1. Open your published form and submit a **test response**.
2. Check **Responses → Kanban board** in Formfacade. The submission should appear under
**Submitted** within seconds.
3. Open the linked **Google Sheet**. A new row should be there too.
If the response shows in Formfacade but not in the Sheet, re-open **Link to
Sheets**. If it doesn't appear at all, revisit **Submit to Google Forms** in
[Advanced settings](#step-1-check-submit-to-google-forms-is-on).
#### Next steps
- Work through responses on the board: [Responses](https://docs.formfacade.com/guides/responses).
- Email each response: [Email notification](https://docs.formfacade.com/products/email-notification).
---
## Chapter 7: Reference
### Fix form and response problems
> Fix a Formfacade form that isn't publicly visible, has stopped accepting responses, doesn't record responses in Google Forms, or redirects to Google Forms on submit.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/troubleshooting
**My Formfacade form isn't working. How can I fix this?**
Find the symptom below. Most problems come from a Google Forms setting, such as sign-in, Accepting responses or Limit to 1 response, or from being signed in to more than one Gmail account. Each entry gives the cause, the fix and a link to the full article on formfacade.com.
Find the message or symptom you see. Each entry says what causes it and how to fix it, with a link to the full article on formfacade.com. Problems with embeds, the add-on, or emails are on [Fix embed, add-on, and email problems](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails).
Many fixes start in your Google Form. To open the Google Form your page uses, open your form in Formfacade and click **Edit**. Click the form's title, click the ⚙️ icon on the title card, click the **Advanced** tab and click **Launch** next to **Edit this form with Google Forms**.
#### The form won't load or isn't public
##### Form is not publicly visible. How can I fix this?
Formfacade shows this warning when people have to sign in to fill your form.
**Cause:** Formfacade supports only public forms. The warning shows if the form is not published, responder access is restricted to specific people, **Collect email addresses** is set to **Verified**, **Send responders a copy of their response** is set to **Always**, or the form has a file upload question.
**Fix:**
1. Publish your form in Google Forms and set **Responder view** to **Anyone with the link**.
2. In **Settings**, set **Collect email addresses** to **Do not collect** or **Responder input**.
3. Turn off **Send responders a copy of their response**. To send a confirmation email, set it up in Formfacade: click **Responses**, then **Kanban board**, click the ⋮ icon on **Submitted** and click **Notify respondent**.
4. If your form has a file upload question, use [Formfacade File Upload](https://docs.formfacade.com/products/file-upload). It turns the question into an upload that doesn't need sign-in.
Read the full article: [Form is not publicly visible. How can I fix this?](https://formfacade.com/embed/fix-formfacade-form-not-publicly-visible.html)
##### Form is no longer accepting responses. How can I fix this?
Your form worked on your website, and now it says it is no longer accepting responses. People can't open it or submit it.
**Cause:** **Accepting responses** is turned off in your Google Form. The switch is in Google Forms, so nothing on your form says why.
**Fix:**
1. Open your Google Form and click the **Published** button.
2. Turn on the **Accepting responses** toggle and click **Save**.
> **Does the message mention a file upload limit or Drive storage?**
> Then the toggle is not the cause. The form stops when the files people upload reach that limit. Read [How to save Google Forms uploads without using your Drive storage?](https://formfacade.com/file-upload/save-google-forms-uploads-without-using-drive-storage.html)
Read the full article: [Form is no longer accepting responses. How can I fix this?](https://formfacade.com/website/form-no-longer-accepting-response-fix.html)
#### Responses
##### Form responses are not recorded in Google Forms. How can I fix this?
People have their response receipts, but your Google Form shows no responses.
**Cause:** Each response from your page is recorded in Formfacade. It reaches your Google Form, and the Google Sheet linked to it, only when **Submit to Google Forms** is turned on.
**Fix:**
1. Open your form in Formfacade and click **Responses**, then **Google Forms**. If you see the **Submit to Google Forms** button, click it, then **Proceed**. Each new response now goes to your Google Form too.
2. Click **View in Google Forms** to open the form that gets your responses. If you imported your form, this is Formfacade's copy of your form, not your original. To use a Google Sheet, [link it to this copy](https://docs.formfacade.com/guides/google-sheets).
3. **Proceed** only covers new responses. To send the ones that were missed, click **Kanban board**. A response that isn't in your Google Form has a warning sign next to its number.
4. Click the response. Under **Additional Details**, the **Google Forms** row says **Not submitted**. Click the icon next to it. When the response reaches your Google Form, the row says **Submitted**.
Responses from before March 21, 2025 don't show the warning sign or the icon. If your Google Form asks people to sign in, for example with **Limit to 1 response** on, Formfacade can't send the response for them. Turn that setting off (see the next entry).
Read the full article: [Form responses are not recorded in Google Forms. How can I fix this?](https://formfacade.com/embed/fix-form-responses-not-recorded-in-google-forms.html)
##### Formfacade form redirects to Google Forms page on submit. How can I fix this?
People submit your form and land on a Google Forms page with "There was a problem submitting your response. Try again." or "Sign in to continue. To fill out this form, you must be signed in." If they are already signed in to Google, they land on the Google Forms page with no message.
**Cause:** Two settings in your Google Form. **Send responders a copy of their response** set to **Always** gives the "There was a problem" message. **Limit to 1 response** asks people to sign in.
**Fix:**
1. Open your form in Google Forms (see the steps at the top of this page).
2. Click the **Settings** tab, then **Responses**.
3. Set **Send responders a copy of their response** to **Off**.
4. Turn off **Limit to 1 response**.
5. To send response receipts, use Formfacade instead. Click **Responses**, then **Kanban board**, click the ⋮ icon on **Submitted** and click **Notify respondent** or **Notify collaborators**. See [Email notification](https://docs.formfacade.com/products/email-notification).
Read the full article: [Formfacade form redirects to Google Forms page on submit. How can I fix this?](https://formfacade.com/embed/fix-formfacade-form-redirects-to-google-forms-on-submit.html)
#### Still stuck?
If your problem isn't here, or the fix didn't work, write to support. [Plans, limits, and support](https://docs.formfacade.com/reference/plans-and-support) shows how.
#### Next steps
- Embeds, the add-on, and emails: [Fix embed, add-on, and email problems](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails).
- Work with your responses: [Responses](https://docs.formfacade.com/guides/responses).
- Check where responses go: [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets).
---
### Fix embed, add-on, and email problems
> Fix an embedded form that doesn't show your changes, Google Forms changes that don't reach Formfacade, add-on menu errors, and email notifications that don't arrive.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails
**Form changes are not reflected in the embedded form. How can I fix this?**
Your page shows the form it was given in the embed code. Open that form in Formfacade's editor and reload your page. If you changed the Google Form itself, sync the change into Formfacade. Add-on and email problems usually come from being signed in to more than one Google account.
Find the message or symptom you see. Each entry says what causes it and how to
fix it. Problems with a form that won't load or doesn't record responses are on
[Fix form and response problems](https://docs.formfacade.com/reference/troubleshooting).
Many fixes start in your Google Form. To open the Google Form your page uses, open your form in Formfacade and click **Edit**. Click the form's title, click the ⚙️ icon on the title card, click the **Advanced** tab and click **Launch** next to **Edit this form with Google Forms**.
#### Changes and embeds
##### Form changes are not reflected in the embedded form. How can I fix this?
You changed your questions, but your website still shows the old ones, even after reloading or clearing the cache.
**Cause:** Formfacade reads your Google Form when you open the form in its editor, not each time someone opens your page. If you imported your form, your page uses Formfacade's copy, so a change in your original doesn't reach it.
**Fix:**
1. Make your change in the form your page uses. Open it from **Launch** (see the steps at the top of this page).
2. In Formfacade, click **Edit**, or reload the page if it is already open. Your change is now on the screen.
3. Reload your page.
4. Still the old form? Each import makes a new copy with its own embed code. Click **Share**, then **Embed**, choose your website, and if the code differs from the one on your page, replace it.
Read the full article: [Form changes are not reflected in the embedded form. How can I fix this?](https://formfacade.com/embed/fix-changes-not-reflected-in-embedded-form.html)
##### How to sync Google Forms changes with Formfacade?
**Cause:** There's no Sync button. Importing again isn't the answer: it makes a new copy with its own embed code and responses.
**Fix:**
1. Make your change in the Google Form your page uses.
2. In Formfacade, click **Edit**, or reload the page if it is already open. Formfacade reads your Google Form again each time you open the form here, so this is the sync.
3. Reload your page.
> **Make your changes in Formfacade's editor:**
> A change you make in [Formfacade's editor](https://docs.formfacade.com/guides/editor) is saved to your Google Form and reaches your page when you reload it, so there is nothing to sync.
Read the full article: [How to sync Google Forms changes with Formfacade?](https://formfacade.com/embed/sync-google-forms-changes-with-formfacade.html)
#### Add-on menu
##### How to solve Error: drive.google.com refused to connect?
**Cause:** You are signed in to more than one Gmail account in the same browser, and the add-on opens with the wrong one.
**Fix:**
1. Open an incognito window.
2. Sign in with only the Gmail account you installed the add-on with.
3. Open your Google Form and use the add-on again.
Read the full article: [How to solve Error: drive.google.com refused to connect?](https://formfacade.com/website/error-drive-google-com-refused-to-connect-fix.html)
##### Only the help option is displayed in the Formfacade add-on menu. How can I fix this?
You click the add-on icon, choose **Formfacade - Embed Google Forms™**, and the menu shows only **Help**. **Embed in a webpage** and **Customize this form** are missing.
**Cause:** The menu opened before your Google Form finished loading. This is a Google Workspace issue. The add-on is installed and working.
**Fix:**
1. Wait until your Google Form has finished loading.
2. Click the add-on icon again and select **Formfacade - Embed Google Forms™**.
3. The menu now shows **Embed in a webpage** and **Customize this form**.
Read the full articles: [Only the help option is displayed in the Formfacade add-on menu. How can I fix this?](https://formfacade.com/embed/fix-missing-menu-options-formfacade-google-forms-addon.html) and [How do I fix the missing "Embed" and "Customize" options in the Formfacade menu?](https://formfacade.com/website/how-do-i-fix-the-missing-embed-and-customize-options-in-the-formfacade-menu-on-1FAIpQLScMqVzoO3XzJkcSFiGLLQgXlyek_F5SrU-yVERhCviUFBLxPg.html)
#### Email notifications
##### Email notifications are not working. How can I fix this?
**Cause:** The email triggers were not set up. This often happens when you set up the notification while signed in to more than one Gmail account.
**Fix:**
1. Open an incognito window and sign in with only the Gmail account you installed the add-on with.
2. Set up the notification again. When it works, the setup ends with **You are all set!**
3. If you set up the email from the **Responses** tab and the test email doesn't arrive, click **NO**. It says "Repaired email notification". Click **Click here** and submit a response again.
4. If the email still doesn't arrive, click **Get support**.
Read the full article: [Email notifications are not working. How can I fix this?](https://formfacade.com/collaboration/email-notifications-not-working-fix.html)
##### How to fix ReferenceError: Computation failed message in email notifications
After you changed the form, emails show "Computation failed" and a ReferenceError in place of an answer.
**Cause:** The message still uses the entry#id of a field you deleted from the form.
**Fix:**
1. In your form's dashboard, click **Responses**.
2. Click **Kanban board**, click the ⋮ icon on **Submitted** and click **Notify respondent** or **Notify collaborators**, whichever you set up.
3. Click **Next** until you reach the message.
4. Delete the entry#id named in the error.
5. Click the **@** option and pick the field you want instead.
6. Click **Next**. Click **Click here**, fill in the form and submit it. When the email arrives, click **YES**.
Read the full article: [How to fix ReferenceError: Computation failed message in email notifications](https://formfacade.com/collaboration/reference-error-comptation-failed-message-email-notifications.html)
#### Still stuck?
If your problem isn't here, or the fix didn't work, write to support. [Plans, limits, and support](https://docs.formfacade.com/reference/plans-and-support) shows how.
#### Next steps
- Forms and responses: [Fix form and response problems](https://docs.formfacade.com/reference/troubleshooting).
- Embed your form again: [Embed in website](https://docs.formfacade.com/products/embed).
- Set up emails: [Email notification](https://docs.formfacade.com/products/email-notification).
---
### AI assistants
> Connect Claude, ChatGPT or another AI assistant to Formfacade's MCP server to create and edit forms in your own words, and give assistants these docs as plain text.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/ai-assistants
**What is the Formfacade MCP server?**
The Formfacade MCP server lets an AI assistant such as Claude or ChatGPT create and edit your Formfacade forms from plain language. Add the remote server URL to your assistant, sign in and authorize your Formfacade account once, then describe the form you want.
#### Can an AI assistant read these docs?
Yes. [/llms.txt](https://docs.formfacade.com/llms.txt) lists every page, [/llms-full.txt](https://docs.formfacade.com/llms-full.txt)
has the whole guide in reading order as one plain-text file, and every page has
a Markdown copy at `/md/
.md`, for example
[/md/getting-started/quickstart.md](https://docs.formfacade.com/md/getting-started/quickstart.md).
#### What does the Formfacade MCP server do?
The MCP server connects an AI assistant to your Formfacade account. You describe a form in your own words, or paste a draft you already wrote, and the assistant creates the form with its sections, questions and choices. You can then ask it to change the form, show it to you, or find one of your other forms.
It follows the open Model Context Protocol, so it works with any MCP-capable client, such as Claude, ChatGPT, Cursor, Goose, Windsurf and VS Code extensions.
#### Remote server URL
```
https://formfacade.com/mcp/101214642160492007877
```
#### Requirements
- A Formfacade account. If you don't have one, [start a form](https://docs.formfacade.com/getting-started/start-a-form) first.
- An AI assistant that supports MCP servers.
- A one-time approval for each person who uses it.
#### How do I connect it to my AI assistant?
1. **Add the server to your assistant**
In your AI assistant, add a remote MCP server and paste the remote server URL above. Where you add it depends on your assistant.
2. **Sign in and authorize your account**
The assistant asks you to sign in to Formfacade. Sign in and authorize the Formfacade account you want to use. You approve this once. Each person who uses the server signs in with their own account.
3. **Ask for a form**
Describe the form you want, with its title, sections, questions and choices. The assistant creates it and shows you a preview.
> **Changes go to the live form:**
> A form the assistant creates is published and live. When you ask it to change a form, the change is made on the live form, so people who open it see the new version.
#### What tools does it have?
| Tool | What it does |
| --- | --- |
| `create_form` | Creates and publishes a new form from a text description in HTML or Markdown. Give it the title, sections, questions, field types and choices. You can also set the form's language. It returns a preview of the form. |
| `list_forms` | Lists your Formfacade forms. The assistant uses it to find the form you mean before it changes it. |
| `get_form` | Reads a form's sections and questions. |
| `update_form` | Adds, changes or removes a field, section, choice or wording on a live form, from your instruction. |
| `preview` | Shows a preview of a form. |
| `progress` | Opens the form's settings checklist. |
#### What can't it do yet?
- **It can't list or analyze your responses.** See them on the [Responses](https://docs.formfacade.com/guides/responses) and [Reports](https://docs.formfacade.com/guides/reports) pages in Formfacade.
- **It can't replace a whole form in one step.** It changes parts of a form: a field, section, choice or wording.
- **`progress` doesn't set up every feature.** Set up branding, CSS, embedding and integrations in Formfacade. See [Design](https://docs.formfacade.com/guides/design) and [Embed in website](https://docs.formfacade.com/products/embed).
- **It reads text, not files.** It can't take an image or a PDF. If your draft is a PDF, convert it to text first, then give the text to your assistant.
#### Example prompts
Create a form:
```
Create a Formfacade form called Acme customer feedback with two sections,
About you and Your visit. Ask for Name, Email, a rating from 1 to 5 for
our service, and a paragraph question for comments.
```
Create a form from a draft you wrote, in another language:
```
Here is my workshop registration form as Markdown. Create a Formfacade
form from it in Spanish.
```
Find and change a form:
```
List my Formfacade forms.
```
```
In my Acme customer feedback form, add a required Phone question after Email.
```
```
In my Acme customer feedback form, rename the Your visit section to Your last visit.
```
See a form:
```
Show me a preview of my Acme customer feedback form.
```
```
Open the settings checklist for my Acme customer feedback form.
```
#### Next steps
- Don't have a Formfacade account yet? [Start a form](https://docs.formfacade.com/getting-started/start-a-form).
- Fine-tune the form the assistant made in the [editor](https://docs.formfacade.com/guides/editor).
- Put the form on your website: [Embed in website](https://docs.formfacade.com/products/embed).
- Read the answers people send: [Responses](https://docs.formfacade.com/guides/responses).
---
### Plans, limits, and support
> Formfacade's plans by product, where to see and change your plan, and how to contact support.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/plans-and-support
**How much does Formfacade cost, and how do I get help?**
Each product has its own plans, starting at $8/month for Customize UI, $18/month for Embed in website, $28/month for File upload, and $38/month for Assign points. The Enhance plans start at $98/month and include every product. To get help, fill in the form on the Formfacade support page with your form's link.
#### What do the plans cost?
These are the starting prices on the
[pricing page](https://formfacade.com/enhance/pricing.html). Check it for the
current plans and limits before you buy.
| Plan | Starts at | Includes |
| --- | --- | --- |
| Customize layout, form fields & buttons | $8/month | Up to 300 responses/month |
| Embed in website | $18/month | Up to 500 responses/month |
| Collect files without login | $28/month | Up to 1 GB per file and 1 TB of file storage |
| Assign points and calculate scores | $38/month | Up to 300 responses/month |
| Enhance (tailor made CRM) | $98/month | 500 responses/month, with Customize UI, Embed, large files, email notifications, custom PDFs, workflows, and customer management |
#### Where do I see my plan?
Open your [dashboard](https://docs.formfacade.com/getting-started/your-dashboard). The **Current plan**
card on **Home** shows your plan, with **Manage plan** to change it. The
**Account** tab shows it too. On the **Forms** tab, **New Form** shows how
many more forms your plan allows.
#### How do I contact support?
Go to the [Formfacade support page](https://formfacade.com/enhance/support.html)
and fill in the form:
1. Describe the problem in **What problem are you facing?**
2. Choose **Formfacade** as the **Product**.
3. Enter your email, so the team can reply.
4. Paste the share link of your form, or the address of the page where it's
embedded. This lets the team open the same form you're looking at.
Before you write, check [Fix form and response problems](https://docs.formfacade.com/reference/troubleshooting). Most
problems with embeds, submissions, and emails are covered there.
#### How can I transfer ownership of the form?
Ask the new owner to install Formfacade with their own account and send you
their embed code. Put their code on your webpage in place of yours. From then
on, they customize the form and manage its responses themselves. See
[Share your form](https://docs.formfacade.com/guides/share) to add them as a collaborator first.
#### Next steps
- Fix a problem by its symptom: [Fix form and response problems](https://docs.formfacade.com/reference/troubleshooting).
- Find the page for a task: [Task index](https://docs.formfacade.com/reference/task-index).
---
### Glossary
> Formfacade terms in a line or two each, with the page that explains them.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/glossary
**What does this Formfacade term mean?**
Find the term below. Each one is explained in a line or two, with a link to the page that covers it.
| Term | Meaning |
| --- | --- |
| **After page** | The row at the end of each page in the editor. Its gear icon (**Submit setting**) sets the button and what happens on submit. See [After submit](https://docs.formfacade.com/guides/after-submit). |
| **Appearance** | A question setting: **Editable**, **Read only**, **Office use**, or **Hidden**. See [Question settings](https://docs.formfacade.com/guides/question-settings). |
| **Calculate** | The question setting where you write a formula. See [Calculated fields](https://docs.formfacade.com/reference/functions). |
| **Collaborator** | Someone you add from the **Share** tab to work on the form or its responses. See [Share your form](https://docs.formfacade.com/guides/share). |
| **Conditional dropdown** | A dropdown whose choices depend on an earlier answer, from a Google Sheet. See [Conditional dropdowns](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns). |
| **Contacts** | People you've saved, so you can email them a form or a prefill link. See [Prefill & email](https://docs.formfacade.com/products/prefill-and-email). |
| **Copy** | Formfacade works on a copy of the Google Form you import. Your original form and its responses stay as they are. See [Start a form](https://docs.formfacade.com/getting-started/start-a-form). |
| **Dashboard** | Your home in Formfacade, with Home, Forms, Inbox, Contacts, and Account. See [Your dashboard](https://docs.formfacade.com/getting-started/your-dashboard). |
| **Embed code** | The snippet from **Share → Embed** that puts your form in a webpage, without an iframe. See [Embed in website](https://docs.formfacade.com/products/embed). |
| **Group prefill link** | One named prefill link you share with many people, such as `intro-to-sheets`. See [Prefill & email](https://docs.formfacade.com/products/prefill-and-email). |
| **Hidden** | An Appearance: the question isn't on the form, but its value is saved with the response. |
| **Hub** | The docs page for one product, such as [File upload](https://docs.formfacade.com/products/file-upload). |
| **Import** | Bringing a Google Form into Formfacade by its link. Formfacade makes a copy. See [Start a form](https://docs.formfacade.com/getting-started/start-a-form). |
| **Kanban board** | The Responses view that groups submissions by status, such as Abandoned, Submitted, and Completed. See [Responses](https://docs.formfacade.com/guides/responses). |
| **Key fields** | The questions that hold the respondent's name, email, and phone, set in **Configure key fields**. Emails and contacts use them. See [The editor](https://docs.formfacade.com/guides/editor). |
| **Link to Sheets** | Sends responses to a Google Sheet. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets). |
| **Lookup** | Reading data from a Google Sheet into the form: dropdown choices or autofilled answers. See [Sheets Lookup](https://docs.formfacade.com/products/sheets-lookup). |
| **MCP server** | Lets an AI assistant such as Claude or ChatGPT create and edit your forms. See [AI assistants](https://docs.formfacade.com/reference/ai-assistants). |
| **Office use** | An Appearance: hidden from respondents, and filled in later by your team. |
| **Points** | What an answer is worth in a scored form. See [Assign points](https://docs.formfacade.com/products/assign-points). |
| **Prefill** | An answer filled in before the person sees the form, as a default or through a prefill link. See [Question settings](https://docs.formfacade.com/guides/question-settings). |
| **Prefill link** | A link that opens the form with answers filled in. It carries only a name you choose, not the values. See [Prefill & email](https://docs.formfacade.com/products/prefill-and-email). |
| **Read only** | An Appearance: people see the value as plain text and can't change it. |
| **Responder link** | Your Google Form's public link, starting `https://docs.google.com/forms/d/e/`. You paste it to import the form. |
| **Score** | The total of the points for a person's answers, shown in a Score question. See [Score functions](https://docs.formfacade.com/reference/score-functions). |
| **Status** | A column on the Kanban board, such as Submitted or Completed. You can add your own. See [Responses](https://docs.formfacade.com/guides/responses). |
| **Submit to Google Forms** | The setting that sends each response to your Google Form. See [Google Forms and Sheets](https://docs.formfacade.com/guides/google-sheets). |
| **Validation** | A rule an answer must meet, such as a number range or a date range. See [Question settings](https://docs.formfacade.com/guides/question-settings#how-do-i-add-response-validation). |
#### Next steps
- Find the page for a task: [Task index](https://docs.formfacade.com/reference/task-index).
- Start from the beginning: [What Formfacade does](https://docs.formfacade.com/getting-started/what-is-formfacade).
---
### Task index
> Every task readers come to Formfacade with, in their own words, grouped by chapter, with the page that does it.
Chapter 7: Reference
Source: https://docs.formfacade.com/reference/task-index
**Where do I find how to do something in Formfacade?**
Find the task below, grouped by the chapter it's in, and click it to open the page that does it. You can also search from the top of any page: every word you type must match, and titles rank first.
The tasks below come from the questions people ask about Formfacade. Each one
opens the page that does it. To search instead, use the search at the top of
the page.
#### Get started
- [Install Formfacade](https://docs.formfacade.com/getting-started/start-a-form)
- [Build a form from its name](https://docs.formfacade.com/getting-started/start-a-form)
- [Convert a PDF into a form](https://docs.formfacade.com/getting-started/start-a-form)
- [Find your forms and plan](https://docs.formfacade.com/getting-started/your-dashboard)
#### Products
- [Choose a layout](https://docs.formfacade.com/products/customize-ui)
- [Compare ways to embed a form](https://docs.formfacade.com/products/embed)
- [Embed a form in any website](https://docs.formfacade.com/products/embed)
- [Embed a form in Squarespace](https://docs.formfacade.com/products/embed)
- [Embed a form in Google Sites](https://docs.formfacade.com/products/embed)
- [See where people stop filling your form](https://docs.formfacade.com/products/embed)
- [Look up data from a Google Sheet](https://docs.formfacade.com/products/sheets-lookup)
- [Fill a dropdown from a Google Sheet](https://docs.formfacade.com/products/sheets-lookup/populate-dropdown)
- [Autofill fields from a Google Sheet](https://docs.formfacade.com/products/sheets-lookup/autofill-fields)
- [Create a conditional dropdown](https://docs.formfacade.com/products/sheets-lookup/conditional-dropdowns)
- [Give every question the same points and total them](https://docs.formfacade.com/products/assign-points)
- [Give every question the same points and score each section](https://docs.formfacade.com/products/assign-points)
- [Give each question different points and total them](https://docs.formfacade.com/products/assign-points)
- [Assign points for a Likert scale question](https://docs.formfacade.com/products/assign-points)
- [Assign points for a checkboxes question](https://docs.formfacade.com/products/assign-points)
- [Assign points for a linear scale question](https://docs.formfacade.com/products/assign-points)
- [Assign points for a grid question](https://docs.formfacade.com/products/assign-points)
- [Assign different points for specific statements in a grid question](https://docs.formfacade.com/products/assign-points)
- [Create a quiz that calculates a score](https://docs.formfacade.com/products/assign-points)
- [Give multiple choice answers different points](https://docs.formfacade.com/products/assign-points)
- [Calculate scores for each section](https://docs.formfacade.com/products/assign-points)
- [Calculate several scores from different questions](https://docs.formfacade.com/products/assign-points)
- [Assign points for a dropdown question](https://docs.formfacade.com/products/assign-points)
- [Show the score only after submit](https://docs.formfacade.com/products/assign-points)
- [Show a message based on the score](https://docs.formfacade.com/products/assign-points)
- [Email each person their quiz score](https://docs.formfacade.com/products/assign-points)
- [Add a file upload question](https://docs.formfacade.com/products/file-upload)
- [Let people upload files without signing in](https://docs.formfacade.com/products/file-upload)
- [Make a file upload required](https://docs.formfacade.com/products/file-upload)
- [Change the Add file button text](https://docs.formfacade.com/products/file-upload)
- [Allow several files per question](https://docs.formfacade.com/products/file-upload)
- [Restrict file types](https://docs.formfacade.com/products/file-upload)
- [Style the upload button with CSS](https://docs.formfacade.com/products/file-upload)
- [Check the maximum file size](https://docs.formfacade.com/products/file-upload)
- [See the ways people can upload files](https://docs.formfacade.com/products/file-upload)
- [View and download uploaded files](https://docs.formfacade.com/products/file-upload)
- [Give collaborators access to uploaded files](https://docs.formfacade.com/products/file-upload)
- [Delete uploaded files](https://docs.formfacade.com/products/file-upload)
- [Save uploads without using your Drive storage](https://docs.formfacade.com/products/file-upload)
- [Let collaborators edit responses after submit](https://docs.formfacade.com/products/email-notification)
- [Send respondents a copy of their response](https://docs.formfacade.com/products/email-notification)
- [Get an email with each response](https://docs.formfacade.com/products/email-notification)
- [Email several collaborators](https://docs.formfacade.com/products/email-notification)
- [Change the email subject](https://docs.formfacade.com/products/email-notification)
- [Personalize the email message](https://docs.formfacade.com/products/email-notification)
- [Stop notification emails](https://docs.formfacade.com/products/email-notification)
- [Track each response's status](https://docs.formfacade.com/products/email-notification)
- [Edit a form after submit](https://docs.formfacade.com/products/email-notification)
- [Edit responses after submit](https://docs.formfacade.com/products/email-notification)
- [Automatically send email notifications](https://docs.formfacade.com/products/email-notification)
- [Use prefill links like Google Forms' pre-fill](https://docs.formfacade.com/products/prefill-and-email)
- [Pre-fill answers in the embedded form](https://docs.formfacade.com/products/prefill-and-email)
- [Create a secure prefill link](https://docs.formfacade.com/products/prefill-and-email)
- [Prefill links from a Google Sheet](https://docs.formfacade.com/products/prefill-and-email)
- [Save an email template with a prefill link](https://docs.formfacade.com/products/prefill-and-email)
- [Send a form with answers filled in](https://docs.formfacade.com/products/prefill-and-email)
- [Edit the message before sending the email](https://docs.formfacade.com/products/prefill-and-email)
- [Email each contact their own prefill link](https://docs.formfacade.com/products/prefill-and-email)
- [Connect two forms](https://docs.formfacade.com/products/prefill-and-email)
#### Build your form
- [Create a new form](https://docs.formfacade.com/guides/editor)
- [Add a question](https://docs.formfacade.com/guides/editor)
- [Add a description to a question](https://docs.formfacade.com/guides/editor)
- [Add response validation](https://docs.formfacade.com/guides/editor)
- [Add images](https://docs.formfacade.com/guides/editor)
- [Add videos](https://docs.formfacade.com/guides/editor)
- [Add sections](https://docs.formfacade.com/guides/editor)
- [Show different questions based on answers](https://docs.formfacade.com/guides/editor)
- [Shuffle question order](https://docs.formfacade.com/guides/editor)
- [Shuffle answer choices](https://docs.formfacade.com/guides/editor)
- [Add an email address question](https://docs.formfacade.com/reference/question-types)
- [Add a short answer question](https://docs.formfacade.com/reference/question-types)
- [Add a number question](https://docs.formfacade.com/reference/question-types)
- [Add a paragraph question](https://docs.formfacade.com/reference/question-types)
- [Add a multiple choice question](https://docs.formfacade.com/reference/question-types)
- [Add a checkboxes question](https://docs.formfacade.com/reference/question-types)
- [Add a dropdown question](https://docs.formfacade.com/reference/question-types)
- [Add a linear scale question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a multiple choice grid question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a Likert scale question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a frequency scale question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a ranking scale question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a voting question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a checkbox grid question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a date question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Add a time or duration question](https://docs.formfacade.com/reference/scales-grids-and-dates)
- [Change the placeholder text](https://docs.formfacade.com/guides/question-settings)
- [Accept dates a set number of days ahead](https://docs.formfacade.com/guides/question-settings)
- [Accept only dates in a range](https://docs.formfacade.com/guides/question-settings)
- [Hide fields](https://docs.formfacade.com/guides/question-settings)
- [Add hidden fields](https://docs.formfacade.com/guides/question-settings)
- [Add read-only fields](https://docs.formfacade.com/guides/question-settings)
- [Mark a field as protected health information](https://docs.formfacade.com/guides/question-settings)
- [Choose a theme](https://docs.formfacade.com/guides/design)
- [Change the layout](https://docs.formfacade.com/guides/design)
- [Change the background color](https://docs.formfacade.com/guides/design)
- [Change the fonts](https://docs.formfacade.com/guides/design)
- [Style the form with CSS](https://docs.formfacade.com/guides/design)
- [Add your logo](https://docs.formfacade.com/guides/design)
- [Change the button color or font styles](https://docs.formfacade.com/guides/design)
- [Change the Submit button text](https://docs.formfacade.com/guides/after-submit)
- [Customize the thank-you message](https://docs.formfacade.com/guides/after-submit)
- [Change the language of the buttons](https://docs.formfacade.com/guides/after-submit)
- [Change the confirmation message](https://docs.formfacade.com/guides/after-submit)
- [Format the confirmation message](https://docs.formfacade.com/guides/after-submit)
- [Show answers in the confirmation message](https://docs.formfacade.com/guides/after-submit)
- [Redirect to a webpage after submit](https://docs.formfacade.com/guides/after-submit)
#### Formulas
- [Add a calculated field](https://docs.formfacade.com/reference/functions)
- [Calculate with dates](https://docs.formfacade.com/reference/date-functions)
- [Fill in today's date](https://docs.formfacade.com/reference/date-functions)
- [Calculate the days between two dates](https://docs.formfacade.com/reference/date-functions)
- [Calculate age from date of birth](https://docs.formfacade.com/reference/date-functions)
- [Add days, months or years to a date](https://docs.formfacade.com/reference/date-functions)
- [Subtract days, months or years from a date](https://docs.formfacade.com/reference/date-functions)
- [Calculate an end date from a start date and a term](https://docs.formfacade.com/reference/date-functions)
- [Calculate the number of days left in a month](https://docs.formfacade.com/reference/date-functions)
- [Calculate the day of the week](https://docs.formfacade.com/reference/date-functions)
- [Calculate the start and end date of a work week](https://docs.formfacade.com/reference/date-functions)
- [Write a score formula](https://docs.formfacade.com/reference/score-functions)
#### Share and embed
- [Transfer ownership of the form](https://docs.formfacade.com/guides/share)
- [Add collaborators](https://docs.formfacade.com/guides/share)
- [Embed a form in WordPress](https://docs.formfacade.com/products/embed/wordpress)
- [Embed a form in Wix](https://docs.formfacade.com/products/embed/wix)
- [Embed a form in React or Next.js](https://docs.formfacade.com/products/embed/react-nextjs)
#### Responses
- [Organize and manage form responses](https://docs.formfacade.com/guides/responses)
- [View responses](https://docs.formfacade.com/guides/responses)
- [View individual responses](https://docs.formfacade.com/guides/responses)
- [View a summary of responses](https://docs.formfacade.com/guides/responses)
- [View all the answers for a question](https://docs.formfacade.com/guides/responses)
- [Delete a response](https://docs.formfacade.com/guides/responses)
- [Delete all responses](https://docs.formfacade.com/guides/responses)
- [Get back deleted responses](https://docs.formfacade.com/guides/responses)
- [Download responses](https://docs.formfacade.com/guides/responses)
- [Share responses](https://docs.formfacade.com/guides/responses)
- [Share responses without edit access](https://docs.formfacade.com/guides/responses)
- [Send an HTML form's answers to Google Sheets](https://docs.formfacade.com/guides/google-sheets)
- [Send responses to Google Sheets](https://docs.formfacade.com/guides/google-sheets)
#### Reference
- [Fix "no longer accepting responses"](https://docs.formfacade.com/reference/troubleshooting)
- [Fix "form is not publicly visible"](https://docs.formfacade.com/reference/troubleshooting)
- [Stop the form going to Google Forms on submit](https://docs.formfacade.com/reference/troubleshooting)
- [Fix responses that don't reach Google Forms](https://docs.formfacade.com/reference/troubleshooting)
- [Fix "drive.google.com refused to connect"](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Fix missing Embed and Customize options in the add-on menu](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Sync Google Forms changes with Formfacade](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Fix an add-on menu that shows only Help](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Show your changes in an embedded form](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Fix email notifications that don't arrive](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Fix "Computation failed" in emails](https://docs.formfacade.com/reference/troubleshooting-embeds-and-emails)
- [Connect an AI assistant with the MCP server](https://docs.formfacade.com/reference/ai-assistants)
- [Read these docs from an AI assistant](https://docs.formfacade.com/reference/ai-assistants)
- [Contact support](https://docs.formfacade.com/reference/plans-and-support)
- [Look up a Formfacade term](https://docs.formfacade.com/reference/glossary)
#### Next steps
- Fix a problem by its symptom: [Fix form and response problems](https://docs.formfacade.com/reference/troubleshooting).
- Look up a term: [Glossary](https://docs.formfacade.com/reference/glossary).
---