How to automatically show the score on the spreadsheet?

  • Profile Image
    pisara
    Asked on October 15, 2015 at 11:07 AM

    I am using QUIZ FORM app. It works very well.  When I checked the result in spreadsheet.  The scores and percentages were not showing at the end of the column.  It only displays the answers.  

    Is there a way to show the scores/percentage?  

     

    Thank you.

  • Profile Image
    david
    Answered on October 15, 2015 at 12:37 PM

    Hi,

    Though it would require a bit of alteration of your form, you could assign calculation values to your answers:

    http://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    And total/adjust them using a calculation field:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    This will give you a calculated total in the form that will be included in the spreadsheet of your submissions.

    If you would like to give this a try and need any help along the way, let us know and we will be happy to assist you.