Creating a conditional form and running into logic issues

  • Profile Image
    interstatethemusical
    Asked on February 19, 2021 at 12:21 AM

    Hi, I'm trying to make a "which character are you?" type of personality quiz and I followed this really helpful how-to to create it: https://www.jotform.com/answers/2099256-Personality-Quiz-using-Calculations-or-conditional-logic. Instead of using a custom thank you screen, I instead opted to show/hide screens for the final reveal.

    This article was super helpful, except for one thing. It doesn't account for what to do if there was a tie. For example, if two "characters" got voted on 3 times, I'd like to be able to have a hierarchy, where I show a specific character first, and hide the others.

    I tried to figure it out but my brain is hurting from thinking about the logic. Do you have any ideas?

  • Profile Image
    Mike_G
    Answered on February 19, 2021 at 04:55 AM

    We will be glad to help you with your concern. To my understanding, you are only looking to show the first or the top "character. With regards to two characters getting the same number of votes, can you tell us how would you prefer dealing with tie scores, please? We'd like to know if you have any certain rules/criteria so we will be able to check if it is possible or not.

    We will wait for your response.

  • Profile Image
    interstatethemusical
    Answered on February 19, 2021 at 10:28 AM

    Thanks Mike_G! I actually managed to figure it out myself. I want to share with the Jotform community that in order for it to work properly, you have to follow the link I shared above (repasted here: https://www.jotform.com/answers/2099256-Personality-Quiz-using-Calculations-or-conditional-logic), except instead of assigning 1 point to the selected answer, you have to assign 10,000 points for one question, 10,001 points for the second question, 10,002 points for the third, 10,004 points for the fourth wherein each of the last digits are doubled. So for my example, which has 10 questions and 5 possible results for each, the largest amount of points I assigned was 10256.

    This is to "break the tie" in the event that there is one.

    Using this method, each question is also weighted slightly more or less depending on number of points, so it allows you to add weight to a question that maybe ought to be valued more in the calculations.

    My final result is here: https://form.jotform.com/210485620554150

    If others want to do something similar, I'm happy to explain as well.