Hi Mahima, you can use the POINTS(SECTION) formula to add the points for all the questions in that section to calculate the section score and AVERAGEPOINTS(SECTION) formula to calculate the average points for the questions in the section.
Calculate average points
To calculate the average points for a section and record it in the form, login to Formfacade > click on the form to open it > Edit page will be displayed > In the Formfacade Edit page, click on the last question in a section to select it > click on the + add question icon > a new question will be added below the selected question > enter the title (Ex: Average Score Section#1), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > select Hidden from the dropdown list for the Appearance option, enter the AVERAGEPOINTS(SECTION) formula in the Calculate option and click Save. Repeat the steps to calculate the average points for other sections.
Custom message
In the Formfacade Edit page, scroll to the bottom of the page > select Custom message from the list for the Submit section > enter the preferred message. Click on the @ icon in the editor to include specific answers in the message.
Comments (1)
Oct 9, 2024
Hi Mahima, you can use the POINTS(SECTION) formula to add the points for all the questions in that section to calculate the section score and AVERAGEPOINTS(SECTION) formula to calculate the average points for the questions in the section. Calculate average points To calculate the average points for a section and record it in the form, login to Formfacade > click on the form to open it > Edit page will be displayed > In the Formfacade Edit page, click on the last question in a section to select it > click on the + add question icon > a new question will be added below the selected question > enter the title (Ex: Average Score Section#1), select the Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > select Hidden from the dropdown list for the Appearance option, enter the AVERAGEPOINTS(SECTION) formula in the Calculate option and click Save. Repeat the steps to calculate the average points for other sections. Custom message In the Formfacade Edit page, scroll to the bottom of the page > select Custom message from the list for the Submit section > enter the preferred message. Click on the @ icon in the editor to include specific answers in the message.
Add your comment
Add photo