See quiz score in submissions table

  • dan_dan283
    Asked on March 19, 2025 at 9:03 PM

    Hi I am following these instructions to show their quiz grade in my submissions table

    https://www.jotform.com/answers/19125021-viewing-students-score-in-jotform-tables#:~:text=You%20can%20use%20Form%20Calculation,Values%20toggle%20to%20ON%20position.

    See quiz score in submissions table Image 1 Screenshot 30

    however the column is not available to add

    See quiz score in submissions table Image 2 Screenshot 41


    Form name is [Imported] Tinny Rally March 2025 Induction


    Can you help me show this please?


  • Aiden JotForm Support
    Replied on March 20, 2025 at 4:06 AM

    Hi Dan,

    Thanks for reaching out to Jotform Support. I couldn't find a form named "[Imported] Tinny Rally March 2025 Induction," but I did find one called "Tinny Rally March 2025 Induction." It looks like the Form Calculation widget wasn’t configured correctly. You should include every question into the calculation like you see below:

    See quiz score in submissions table Image 1 Screenshot 30If you need help with the configuration, I can assist you from scratch and guide you through the entire process. Once the calculation is properly configured, the final score should be seen on Jotform Tables. Check out the screencast below to see my results: See quiz score in submissions table Image 2 Screenshot 41

    Reach out again if you need any more help.

  • dan_dan283
    Replied on March 20, 2025 at 8:16 AM

    Thanks, thats is the form.

    I just added them all.

    I want to see a % grade. I am still not seeing the grade though?

  • dan_dan283
    Replied on March 20, 2025 at 8:19 AM

    it's showing the % complete after they submit. Can I show them if they get 100% before they hit submit though, they can then fix their answers before they hit submit
    See quiz score in submissions table Image 1 Screenshot 20 Screenshot 10
  • Aiden JotForm Support
    Replied on March 20, 2025 at 9:28 AM

    Hi Dan,

    Since there are 23 points to be earned, you can add *100/23 to the equation to calculate the exam’s percentage. Here’s how to do it:

    1. In Form Builder, click on the Calculation Value field and then the Wand icon. See quiz score in submissions table Image 1 Screenshot 402. Add parentheses before and after the questions, then after the parentheses include *100/23.See quiz score in submissions table Image 2 Screenshot 513. If you’d like to round up the result, click the blue Options button and set Decimal Places in Numerical Results to 0.

    4. Finally, click on Go Back and then Save. See quiz score in submissions table Image 3 Screenshot 62

    That's it, now you should be able to see the exam result in percentage. To avoid confusion, I moved your other question to a new thread and helped you with that here.

    Give it a try and let us know if you need any other help.