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

CapabilityWhat it does
Points on any question typeAssign points for dropdown, multiple-choice, checkbox, Likert scale, linear scale, and grid questions.
Overall scoreAutomatically total the points across every question in the form.
Section scoreTotal the points within a specific form section.
Multiple category scoresCalculate several scores at once by grouping specific questions into categories.
Show or hide the scoreHide the score during completion and reveal it after submit, or email the result instead.
Feedback & recommendationsShow correct answers, per-answer feedback, and score-based recommendations or verbal assessments.
Redirect by scoreSend 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.)

Choose Create a new scored form to have Formfacade draft the quiz for you.

Name the form

Type the form's name, here Cybersecurity Awareness Quiz, and click Create form. Formfacade drafts the questions from the name.

1 Name the form, then 2 click Create form.

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.

1 Check the drafted questions, then 2 click Proceed to create the form.

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.

1 The scoring instruction, sent from Customize form. 2 The points it assigned: +1 for the correct answer, 0 for the rest.

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.

1 Appearance: Hidden. 2 Calculate: POINTS(), the total of every answer's points. 3 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.)

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 isMessage
Greater than or equal to 13Security pro!
Greater than or equal to 8Solid, but brush up.
ElsePlease 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.

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:

15 out of 15: the 13–15 message.

Only 5 correct:

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:

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.

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.

Supported question types

Question typePoints supported
Dropdown✅
Multiple choice✅
Checkboxes✅
Likert scale✅
Linear scale✅
Grid✅

Next steps