Can I create conditional reports or datbases?

  • Profile Image
    Asked on May 23, 2011 at 05:33 PM

    We're collecting leads for a client based on zip code. The client has multiple offices that share an area, and need to be sorted by corresponding zip codes before any leads are sent to the correct office. Is there any way to have conditions on the form that will read what zip code has been entered, then add it to the correct databse or list?

    As I write this, I'm thinking maybe the most feasible way would be to have a conditional zip code field that returns a hidden field for "office" that only shows up in the report. For instance, if there are 3 offices in an area containing zip codes A,B and C, each corresponding to a separate office, when the user inputs zipcode A, the hidden field will return Office #1, etc. We can then sort the report based on the hidden "office" field. Is there any way to accomplish this or something like it?

  • Profile Image
    Answered on May 24, 2011 at 09:56 AM

    Hello droidmarketing,

    Unfortunately, jotform has no feature with that kind of function that you are looking for.  Each form submission is sent to its corresponding submission record list and cannot be copied/transferred to another form/submission list.

    An alternative solution that I have in mind is create your own redirecting drop down menu field first.  This will then point to a specific form with the data that a certain office only collects.

    If you have a pretty good knowledge with programming with PHP and MySQL database, and you have your own website, maybe you can take advantage of Jotform's Send Post Data feature. 

    Let's say you have a leads database with 3 different tables representing the office branch for each.  When you set your form to use Send Post Data, you will be able to capture the submitted data from the person who submitted the form, then you can put a condition in your zip code and match it to which table the data should be inserted.

    Hope this helps.

    If you have other questions or concerns, please let us know.