Can the forms do simple queries to filter a submission?

  • Profile Image
    Timothy Suh 
    Asked on April 11, 2019 at 03:47 PM

    can the forms do simple queries to filter a submission?


    We have an appointment request form that has multiple services, multiple practitioners, and multiple locations so I wanted to see if I could use filters.  Like limiting practitioners by service and location on the form. 

  • Profile Image
    Welvin
    Answered on April 11, 2019 at 04:40 PM

    I'm sorry, but there is no way to do that in the form. A workaround would be to have multiple fields, each that corresponds to the options of the previous field. You can have each field to show when their corresponding option from the parent field is selected.

    https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer 

    In this case, if you have 10 practitioners, add 10 location dropdowns. 1 location for each practitioner.