Embed in website
Embed Google Forms in your website
Customize UI
Change layout, hide fields & redirect on submit
Scorecery
Assign different points for each answer & calculate score
Petaform
Upload files in Google Forms without login
Personalize Email
Email Google Forms response to your users & co-workers
All products
Enhance Google Forms into CRM
eSignature
Accept eSignature in Google Forms
HIPAA form
Make your Google Forms HIPAA compliant
Intake form
Create intake forms that accepts eSignature from patients
Formprefill
Create prefill links for Google Forms without violating HIPAA
Formfillable
Generate customized documents from Google Forms responses
Mailrecipe
Signature workflow for Google Forms
Make your Google Forms compliant
Form builder
Take food orders using Google Forms
WhatsTarget
Take online orders from your WhatsApp contacts
Peergateway
Registrations, memberships, & bookings using Google Forms
Site builder
Create website for your Google Forms
Google Forms Addon
Calculate order amount in Google Forms
Peergateway Addon
Accept payment in Google Forms
Take online orders using Google Forms
Let's create a simple questionnaire with 3 multiple choice questions with five answer choices each (see below). We will calculate the total score to determine how active a person is.How much time do you spend sitting each day?(a) 5+ hrs(b) 4 to 5 hrs(c) 3 to 4 hrs(d) 2 to 3 hrs(e) Less than 2 hrsHow often do you do sports and recreational activities?(a) Once or twice in a month(b) Once a week(c) Thrice a week(d) 5 days in a week (e) DailyHow much physical activity does your job require? (a) Not much(b) A moderate amount(c) Average(d) Intense(e) Very intensePoints: We will use the same points scale for all the three multiple choice questionsAnswer choice (a) - 1 pointAnswer choice (b) - 2 pointsAnswer choice (c) - 3 pointsAnswer choice (d) - 4 pointsAnswer choice (e) - 5 pointsWe will calculate the total score by adding the individual points for the 3 multiple choice questions. The total score would be between 3 and 15.
Pre-requisite: You must have installed the Formfacade add-on for Google Forms. If you haven't installed the add-on yet, you can install it from G Suite marketplace using this link. https://gsuite.google.com/marketplace/app/formfacade/743872305260
SCORE() function allows you to assign scores to each answer choices in multiple choice questions, checkboxes questions and grid questions. It takes two input parameters:1. The first parameter specifies whether the score should be calculated for all questions in the section (SECTION) or questions across all the sections (ALL) or only the questions that matches the search term in the description. 2. The second parameter is the points to be assigned for different answer choices (a), (b), (c), (d), (e) etc.In this example, we will use SCORE(ALL,1,2,3,4,5) to calculate the physical activity score.First parameter: ALL option to calculate the total score across the three multiple choice questions.Second parameter: 1, 2, 3, 4, 5 to assign points for answer choices (a), (b), (c), (d), (e) respectively.
Click Submit to finish.
Calculate score in Google Forms