How do I show the total on the Form submissions?

  • Profile Image
    keitijaroth
    Asked on October 11, 2019 at 02: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.

  • Profile Image
    roneet
    Answered on October 11, 2019 at 02: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

    1570775823888888888.gif

    Let us know if you have further questions.

    Thanks.

  • Profile Image
    keitijaroth
    Answered on October 11, 2019 at 04: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?
  • Profile Image
    roneet
    Answered on October 11, 2019 at 04:44 AM

    I have moved your other concern to a separate thread:

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

    We will address it shortly.

    Thanks.