How do I show the total on the Form submissions?

  • keitijaroth
    Asked on October 11, 2019 at 2:22 AM

    Hello!

    I am a play therapist working in a public school in Latvia (former USSR). The school social worker wants me to collect Strengths and DIfficulties questionnaires from class teachers, for all the kid in their class and then produce reports with a list of all the kids in the class, with their total scores in each of 5 domains. Each domain has 5 questions that give it a total score. I have assigned calculation values to each question and I also have a field with the number of the class. So what I want to do is pull together all the results for a certain class and add up the totals for each child in each domain. Is this possible??? The URL for the form is below. I will also add a screenshot to show the kind of spreadsheet I've been creating manually up until now.

    Jotform Thread 1997188 Screenshot
  • roneet
    Replied on October 11, 2019 at 2:38 AM

    Unfortunately, there is no other way where you can compare and insert calculations in the submission report via which you can compare the total for each of the classes.

    The most you can do is add a Form Calculation widget to add up all the questions and show the total value that the student received when he submitted the questionnaire. Next, you can compare the total value in the report

    How do I show the total on the Form submissions? Image 10

    Let us know if you have further questions.

    Thanks.

  • keitijaroth
    Replied on October 11, 2019 at 4:10 AM

    Brilliant! Thank you so much! I have it all worked out now to do exactly what I need it to.

    Only one thing I can't figure out - I have a Full name field (vārds, uzvārds), in which the Last Name is the second box, but I can't get the results table to sort by last name. It will only do it by First name. Is there a way to do this with the field as it is, or do I need to make First Name and Last Name separate fields?
  • roneet
    Replied on October 11, 2019 at 4:44 AM

    I have moved your other concern to a separate thread:

    https://www.jotform.com/answers/1997405

    We will address it shortly.

    Thanks.