How to assign points for a linear scale question?

"I need to add all the linear scale responses automatically for each form response."- Google Docs Editors Community

If your form is a questionnaire made only of linear scales, the result is usually the total. The P4 pain questionnaire, for one, adds four 0 to 10 answers into a score from 0 to 40. Google Forms records each number but has nowhere to add them up, so the total gets worked out in the Sheet, one response at a time, and 6 people on Google's forum have asked how to add them automatically. With Formfacade, the Score question's Calculate option adds up the answers of your linear scale questions, and each person sees their total on the form as they answer. Sync the responses to Google Sheets and the total arrives in its own column.

Let's start. Import your Google Form and follow the steps below.

How to calculate the score for Linear scale questions?

  • On the page that opens, paste your Google Form's link or click Browse to pick it, then click Next.
The import page with a Google Form's link pasted, and the link box and Next marked
Let's take the P4 questionnaire, which measures the pain intensity, as an example. The P4 consists of 4 items that address pain intensity in the morning, afternoon, evening and with activity over the past 2 days. Each item is scored on an 11-point numeric scale.
We will use a linear scale question that starts from 0 and ends on 10. The end points of the linear scales can be named to provide a reference for the users. 0 = No pain, 10 = Worst imaginable pain
  • A description is already written under "Describe how you want to score this form". Change it to say how you want to score your form, for example: "Score each linear scale question from 0 points for No pain to 10 points for Worst imaginable pain. Add them up into a score." Click Next.
  • "How do you want to score?" shows what it did. Click View points to check the points for each answer, then click Next.
  • On "You're all set!", click Preview form. Your form opens with its score in a new tab.
  • Back on this page, click Share form under Manage: your form opens on the Share tab. Click the Edit tab.
  • Your form already has a Score question, which may be named Total Score. Click on the score question, then click the ⚙️ icon.
P4 questionnaire on the EDIT tab with the Total Score question selected and EDIT, the question and the gear at the bottom of its card marked
  • Select the "Answer" tab and write the formula to assign points and calculate the score.
The Answer tab of the Score question with Answer and the Calculate box holding POINTS() marked
  • The Calculate option already has POINTS(), so delete it. To calculate the score, add the answers for all the 4 linear scale questions as shown below and click Save. The total P4 scores can vary from 0 (no pain) to 40 (the highest possible pain level).
The Calculate box with the four linear scale questions added together and the Save button marked
Users will see the total as they answer the questions.
The P4 questionnaire with four linear scale questions from 0 to 10 answered and a Score of 21

Summary

Google Forms records each linear scale answer but can't add them into a total in the form. With Formfacade, you add up the linear scale answers in the Calculate option of the Score question and people see the total as they answer. Import your Google Form and complete the steps above. If you have any questions, write to support.

Add up the linear scale answers in your Google Form.

Import your Google Form and add up your linear scale answers in the Score question's Calculate option. Each person sees their total as they answer.

Last updated: