Chapter 2 · Products
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.
Quick Answer
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
Choose Create a new scored form
Go to 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 instead.)
Name the form
Type the form's name, here Cybersecurity Awareness Quiz, and click Create form. Formfacade drafts the questions from the name.
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.
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.
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 exampleSCORESUMMARY()), replace it withPOINTS(): the messages in the next step compare against this number.
Then click Save.
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.)
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.
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:
Only 5 correct:
Start from an existing Google Form
If the quiz is already a Google Form, start from it instead of creating a new one:
Start at formfacade.com/calculate
Go to formfacade.com/calculate, click Try it free, and choose Assign points to your Google Forms.
Paste your Google Form
Paste your form's link, or pick it from Drive, to bring it into Formfacade.
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.
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.
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.
- Emailing each respondent their result? See Email notification.
- Writing your own score formulas? See Score functions.