Conditional logic on input table results

  • Profile Image
    ohmydogschool
    Asked on February 13, 2020 at 01:11 PM

    I would like to have a question appear depending on the answers in this table. 


    Question 1 = as in screenshot below, it's a table. 


    1581617234bite damage table.PNG

    The multiple choice options under 'How often' are:


    Never

    Once

    Twice

    Three times

    Four times

    More than four times


    I'd like for the following question to only be visible if: 

    Shallow puncture, ¬Deep puncture, Tear wound or Stitches are NOT Never 


    Is this possible? I can't seem to find how to do conditional logic on table data. 

  • Profile Image
    JohnRex
    Answered on February 13, 2020 at 03:29 PM

    Since you cannot directly use the value of each field of the Input Table in the criteria of a condition, a workaround is to create a Short Text Entry field to where we can put the value of the selected options.

    15816254952161935.png

    Then use the UPDATE/CALCULATE FIELD condition to copy the value of the selected option in the Input Table to its corresponding text field. Here's an example condition:

    15816256102161935 2.png

    Do this for the Shallow puncture¬Deep punctureTear wound or Stitches options. 

    Here's what will happen:

    15816256752161935.gif

    Now, instead of the input table values, you can use the SHORT TEXT ENTRY fields value in your condition to show/hide fields.

    Please try that and let us know how it goes.


  • Profile Image
    ohmydogschool
    Answered on February 14, 2020 at 03:50 AM
    Thank you SO much for your quick responses, you guys. I really appreciate
    the video demo using my own example, and of course, your ingenious
    work-around.
    I am going to get cracking on this.
    I am so impressed with Jotform that I've just submitted a review here
    .
    Right now, I am working on a couple of pilot form and, should it be
    successful in terms of increased response rates and no usability problems,
    I will advise that the company moves to the paid version.
    Keep up the good work!
    [image: photo]
    *Laure-Anne Viselé-Jonkman, oprichter*
    OhMyDog! Hondenkenniscentrum
    MSc, BSc (Zoology), PGDip Appl. An. Beh., O&O-certified trainer
    https://www.ohmydogschool.com
    Wijndaelerweg 12, 2554BZ Den Haag

    Get your own email signature

    ...
  • Profile Image
    jherwin
    Answered on February 14, 2020 at 05:46 AM

    Thanks for the feedback :)

    Let us know if you need any further assistance. We will be happy to help :)

  • Profile Image
    ohmydogschool
    Answered on February 14, 2020 at 06:50 AM
    For your information, I've tried your brilliant work-around and tested it.
    It worked! Thanks again SO much!
    [image: photo]
    *Laure-Anne Viselé-Jonkman, oprichter*
    OhMyDog! Hondenkenniscentrum
    MSc, BSc (Zoology), PGDip Appl. An. Beh., O&O-certified trainer
    https://www.ohmydogschool.com
    Wijndaelerweg 12, 2554BZ Den Haag

    Get your own email signature

    ...