What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Populated spreadsheet fields based on a drop down selection

    Asked by snaplash on July 03, 2015 at 11:13 AM

    Hi Jotform!

    I would like users to select an option from the drop down and have additional invisible fields in the spreadsheet populated.

     

    So if a user selects "Windermere" the spreadsheet would look like the attached image.Is this possible? If so could you show me how :-)

    http://www.jotform.com//?formID=51744541391960

    Thank you!

     

    Mark

    spreadsheet
  • Profile Image
    JotForm Support

    Answered by BJoanna on July 03, 2015 at 12:41 PM

    It is possible to add additional fields inside of your form that will be hidden. Hidden fields will not be shown inside of your form but it will be shown in Google Spreadsheet or Excel. Also you will need set conditional logic  to Update a form field value inside of your form if you want to pass data from dropdown field to some hidden field.

      

    Inside of my demo form I have added three hidden fields and I have set conditional logic to pass values to those fields based on selection in dropdown field. 

    http://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

    http://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-another-Field 

    My Spreadsheet is looking like this.

     

    Hope this will help. Let us know if you need further assistance.