How to calculate for a passing mark

  • Sandy_Green
    Asked on December 9, 2020 at 9:01 AM
  • Sam_G
    Replied on December 9, 2020 at 9:51 AM

    HI Sandy_Green,

    Thank you for contacting Support.

    Here's my test form: https://form.jotform.com/203433598472966. You can make a test submission and see how it works. If that's what you are expecting, then you can follow the steps below: 

    1. First, all my questions that will be scored are in the "Single Choice" field, this is optional and you can use other fields. 

    15045973762017 09 05 15 31 01 Screenshot 10


    2. Now the radio button, checkboxes, drop-down fields can have a calculation value. Here's a guide about it: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value. You can find that option under the "Properties" window of the field. 

    15045977082017 09 05 15 33 43 Screenshot 21

    3. In my case, I have two options "Yes" and "No". For testing purposes, I'll set a value of "1" to "Yes", which means this is the correct answer and have a value of 1 point. While the "No" option will have "0". Now do the same with the other fields. 

    15045977712017 09 05 15 34 22 Screenshot 32

    4. I will then add a Form Calculation widget, this is where the calculation of the scores will happen. 

    15045978042017 09 05 15 40 21 Screenshot 43

    5. In the Form Calculation widget, I'll simply add all the 5 question fields. Basically, I have a 5 point scoring here. Of course, you can have your own calculation. 

    15045976102017 09 05 15 41 23 Screenshot 54

    To perform calculations, please check the following guides:

    Calculation using the Form Calculation widget: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Calculation using the Conditional Logic feature: https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field 


    6. We don't want the score to show up in live preview, so we will hide it. 

    15045976462017 09 05 15 41 40 Screenshot 65


    7. Next is that we want to inform our users if they pass or not. Depending on what you prefer, you can inform them by email or by a custom "Thank You" page. But the main feature we'll use here is the Conditional Logic.

    I'll use a custom "Thank You" page here. Below, navigate to Settings->Conditions and select Change "Thank You" Page.

    15045979162017 09 05 15 39 49 Screenshot 76


    8. Here you can set conditions on what message to display based on an input or a value of a field. Here, I'll set an "IF" statement that says that if the "Score" is less than 3, which means 2 and below then show a custom message. 

    15045979362017 09 05 15 45 24 Screenshot 87


    9. Now the custom message is shown below. You can see that I'm using {score} / 5, which will inform the user of his score. You can get the {score} tag under the "Form Fields" drop down option in the text editor. 

    15045979552017 09 05 15 45 06 Screenshot 98


    Now repeat steps 7-9 to create another condition for the passing mark. 

    To learn more about conditional logic on how to change "Thank You" messages, you can check this guide: https://www.jotform.com/help/372-How-to-Change-Thank-You-Message-Using-Conditional-Logic


    For the email, this is somewhat similar. You can create multiple email alerts, then create a condition to trigger those email alerts based on the score value. 

    To learn more about the email alerts, you can check this guide: https://www.jotform.com/help/30-Explanation-of-Email-Notification-and-Autoresponder-Settings

    To learn how to trigger the email alerts based on conditions, you can check this one: https://www.jotform.com/help/167-How-to-Send-Email-Based-on-Selection 


    I hope that helps.