How to show the top 3 field values in the Thank You page?

  • catherine.damayo
    Asked on June 29, 2020 at 5:47 PM

    I am now almost done with my Assessment survey. How can I customize my thank you message? I want my Thank you message only shows the TOP 3 highest percentage. Can I convert it also with a pie graph? Please see attached file. Thank you. 

    Jotform Thread 2419347 Screenshot
  • John Support Team Lead
    Replied on June 29, 2020 at 9:25 PM

    Hello Catherine - You can use the nth and MAX function in the FORM CALCULATION widget to determine the top 3 values.

    Here's a guide for that: Form-Calculation-Math-Function-Reference.

    This should be done within the form, then just add the new fields into the Thank you page.

    I will create a demo form to better illustrate the workaround. I'll be posting it here shortly.

  • John Support Team Lead
    Replied on June 30, 2020 at 11:11 PM

    Thank you for waiting!

    I have conducted a few tests on this until I make it to work. Here's what I came up with. This is a bit long:

    1. Add 3 form calculation widgets on the last page of the form. This will house the 1st, 2nd, and 3rd largest percentage values. Here we'll be using the nth function. Here's an example:

    How to show the top 3 field values in the Thank You page? Image 10

    Do this for the two other widgets replacing the value in the nth function as 2 and 3 respectively.

    2. Add 3 Long Text Entry fields. We'll need it to construct the TOP 3 Statements that we'll be showing in the Thank you page:

    15935723212419347 2 Screenshot 21

    3. Now, the fun part. Let's create the conditions. We'll be using the UPDATE/CALCULATE FIELD condition.

    Please see this example condition below:

    15935724482419347 3 Screenshot 32

    How does it work? Since we cannot extract the field labels to show in the Thank You Page, we'll be creating the labels instead. In this condition above, if the TOP 1's (form calculation) value is equal to the value of FAMILY PERCENTAGE field, we'll write "Family - (% value of Family)" to the TOP 1 Long Text field.

    Do this for every percentage fields. So in total, you'll be creating 15 conditions for this. 5 conditions for each TOP form calculation fields.

    And here's how it will look like:

    15935728302419347 4 Screenshot 43

    4. Lastly, we'll now add the TOP long text fields to the Thank You Page:

    15935729202419347 5 Screenshot 54

    Here's the result:

    15935729652419347 6 Screenshot 65

    I have implemented this in a cloned form. Here's a link that you can test: https://form.jotform.com/201818547156964 

    You can clone it for you to inspect the conditions I created. Here's a guide on How-to-Clone-an-Existing-Form-from-a-URL.