How to compare different field values with conditional logic

  • carsontate
    Asked on January 27, 2015 at 3:09 PM

    Still unable to send individual emails based on highest score/scores

    I have been having so many issues with this survey, and nothing seems to work. I feel like it just has to be something simple and possible overlooked.

     

    Heres what I need:

    A survey with values added to the questions. (I have that set up already)

    Form calculation to add the totals of certain questions. (I have that set up already.)

    A customized email to go out depending on the calculation with the highest score (or scores if the highest score is tied). (I have 4 different ones set up already)

    Heres’s what I’ve tried:

    Created a max() Form Calculation to show the highest of the 4 form calculations and tried to send email based on that being greater than [the other choices]

    I have also tried doing the same thing, but with the actual totals ( not using the max() form calculation.

    I have previously asked for help but nothing seems to help. Both things I’ve tried but hasn’t worked. All 4 emails keep sending every time. I have attached a collage of photos of the conditions and calculations I have set up.

     

     

    PLEASE let me know what I can do next. Im getting desperate. 

    Jotform Thread 504598 Screenshot
  • Mike
    Replied on January 27, 2015 at 5:54 PM

    The problem is that we cannot compare field values using greater than conditions.

    How to compare different field values with conditional logic Image 1 Screenshot 40

    Field {tags} are not recognized properly in such conditional rules. I have attached a feature request ticket to this thread, to see if this situation can be improved at some point.

    In the meantime, I was able to come up with the next work around.

    http://form.jotformpro.com/form/50266410373953

    Please clone the form to check the back end.

    I have calculated the Max value, and then used it in compare calculation fields.

    How to compare different field values with conditional logic Image 2 Screenshot 51

    Then, used the compare fields in email conditions.

    How to compare different field values with conditional logic Image 3 Screenshot 62

    The same approach should work on your form.