How do I get one Report Field using Conditions & Hide Field

  • Profile Image
    CSBK
    Asked on February 06, 2013 at 10:51 PM

    I like the Conditions -> Show / Hide a form field Options in Jotform so when a user chooses/enters a value then the next field can be hidden and another shown, making it appear as if the it was the same field but more applicable and easer for the user. For example, a user would have a shorter list that is more applicable to the field above. The problem is, when making a Excel Report, there will be multiple columns report 'Fields' representing one answer.

     

    For a work around, could I automatically fill out one field using multiple hidden conditions fields. How Can I make a hidden field that is automatically filled by multiple drop-down selections. Some topics that shows possibilities.


    Thanks

    csbk

    Can I create drop downs that are dependant on other drop downs?

    How to Enable Prepopulating Fields

    http://www.jotform.com/help/107-How-to-Enable-Prepopulating-Fields

     

    Create an HTML Table Listing Report

    http://www.jotform.com/help/209-Create-an-HTML-Table-Listing-Report

    Generate Excel Report

    http://www.jotform.com/help/101-Generate-Excel-Report

    http://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive

    http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

  • Profile Image
    EltonCris
    Answered on February 07, 2013 at 12:54 AM

    Hi CSBK,

    Are you saying that what ever selected on a "dropdown field", will be dynamically prepopulated on the "hidden field"? If so, this would be possible using your form source code and apply custom scripts there to create such function. We can help you create the script if it's possible. We would suggest to finish the form first containing those mentioned fields then provide to us the form URL and we'll see how best we can deal with that.

    Thanks!

  • Profile Image
    CSBK
    Answered on February 07, 2013 at 11:47 AM

    OK Great. This will take som time on my part.