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 customer facing forms
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
Show consent screen while submitting Google Forms
Mailrecipe
Signature workflow for Google Forms
Make your Google Forms compliant
Form builder
Take online orders from your Instagram & Facebook fans
WhatsTarget
Take online orders from your WhatsApp contacts
Peergateway
Create registration, membership form for Schools & Sports clubs
Site builder
Create website for new users to learn about your brand
Google Forms Addon
Take online orders using Google Forms
Peergateway Addon
Accept payment in Google Forms
Take online orders from your social media fans
Let's create the Oxford Happiness Questionnaire to measure the current level of happiness. This happiness questionnaire consists of 29 statements. The items are a combination of positively and negatively phrased statements and pertain to different areas of well-being. This ensures that the respondent takes time to carefully read each item before answering. The survey asks you to evaluate each statement and rate it according to how much you disagree or agree with the statement. It uses a 6-point Likert scale with 6 being the highest as “strongly agree”.We will use a multiple choice grid question with 29 statements that pertain to different areas of well-being. The answer choices for this multiple choice grid question is as follows: strongly disagree, moderately disagree, disagree, agree, moderately agree, strongly agree. Please follow the instructions below to assign points and calculate the score.
You can use the GRIDSCORE function to assign the points to the columns (answer choices) for specific rows (statements) in a grid question and calculate the score.The happiness questionnaire has 29 statements in a multiple choice grid question with a 6-point likert scale. Twelve of the 29 items are scored reversely. The answer choices for statements 2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26 will be assigned the points as shown below.strongly disagree = 1moderately disagree = 2slightly disagree = 3slightly agree = 4moderately agree = 5 strongly agree = 6GRIDSCORE(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) The answer choices for statements 1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29 will be assigned the points as shown below.strongly disagree = 6moderately disagree = 5slightly disagree = 4slightly agree = 3moderately agree = 2 strongly agree = 1GRIDSCORE(entry#id, [1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29], 6, 5, 4, 3, 2, 1)Happiness score is the average of all the statements. The formula to calculate the happiness score is:(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)) / 29Note: Type @ and select the required multiple choice grid question from the list to add its entry #id in the above formula.
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.