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

    When i change a field in a dropdown i want other fields to change

    Asked by Vatche on March 03, 2013 at 10:48 PM

    i want to be able to select an item from a dropdown., and then after the selection ., i need the other fields to reflect the change in that dropdown..

    for example: when i choose a project name from a dropdown., i want the other fields to reflect items such as the project manager., project engineer and so forth that have to do with the particular project name.. is this possible?

    thanks

    name Selection select PDF submission submission grid
  • Profile Image
    JotForm Support

    Answered by jonathan on March 04, 2013 at 01:04 AM

    Hi,

    Please test this form http://www.jotformpro.com/form/30620705386956

    Try the first 3 Project Name, there should be new fields that will show with project managers assigned.

    Tell us if this is how you meant it.

    You can clone the form to check how the condition logic was setup. (guide: How-to-clone-an-existing-form-from-a-URL)

    I used this guide -How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry to setup the condition logic

     

    Hope this help. Please inform us if you have more question.

    Thanks.

  • Profile Image

    Answered by Vatche on March 23, 2013 at 10:11 PM

    It looks great thank you!.. however., where are you doing the condition wizard., i try to find it but i can't .. is it on the stopper? i can't see it.. i wanted also to play with so that the address would also change but did not have any luck.. http://form.jotformpro.com/form/30818717960966

  • Profile Image
    JotForm Support

    Answered by Welvin on March 24, 2013 at 01:54 AM

    @Vatche,

    The Conditional Logic Settings is given on this thread: http://www.jotform.com/help/196-How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry.

    Also explain on this guide: http://www.jotform.com/help/57-Conditional-Logic-on-Forms.

     

    Thank you.

     

  • Profile Image

    Answered by Vatche on April 10, 2013 at 04:23 PM

    i got it working!.. BUT and a big but at that..

    now i have a ton of the same fields in my submission sheet when i submit.. so having a list of 15 in the drop down., multiply that by the number of fields., so i get a ton of columns in the submission sheet.. it makes it a bit useless.. as i have to spend so much time scrolling to the right to find the column where my data is:;

    check out the form.. http://form.jotformpro.com/form/30908544056960

    i hope there's a way that we don't have to use all the fields..

     

    thanks again for all your help..

     

    vk

  • Profile Image
    JotForm Support

    Answered by Mike_T on April 10, 2013 at 04:37 PM

    I am sorry to inform you, but we do not have any tool that can automatically populate form fields based on some selection.

  • Profile Image

    Answered by Vatche on April 10, 2013 at 06:25 PM

    You mean to tell me that i can't build a form that prepopulates the same form when i choose something from a drop down? on that same form?..so i must be very smart for making this work then?>

    i got these instructions on how to show/hide items from you guys!!$#@ are you kidding me?

    please see above instructions from Jonathan which i used to make this work.

    http://form.jotformpro.com/form/30908544056960

    my question was completely different in that .. while this form is working! on the face of it.. it is the submission part that i'm having problems with.. if anyone else has any ideas on this i would be grateful.. thanks

     

  • Profile Image
    JotForm Support

    Answered by jonathan on April 10, 2013 at 07:19 PM

    Hi VK,

    Unfortunately, this is how the submissions grid work for now. When you view the submissions data in the grid, all the forms fields will be available even if the are empty. Since you are using similarly named fields, they might be confusing when viewed on the submissions data grid.

     

    My suggestion is to use the PDF version of your submissions data... like this one https://shots.jotform.com/jonathan/files/30908544056960.pdf . You can download the PDF file of your submissions data, and it will auto-clear submissions data fields that are empty.

    Will this work for you? 

    Please update us.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by jonathan on April 10, 2013 at 07:51 PM

    Hi VK,

    If you replied to this post via your email, I'd like to inform you that your message came out empty on the thread. Please click on this link to reply again.

    Thanks.

  • Profile Image

    Answered by Vatche on April 10, 2013 at 08:04 PM

    Here you go..

    Thanks for the reply Jonathan.. that’s too bad.. it was working so beautifully.. I guess my only resort is to view them through the pdf.. is there a way for me to change the field names..

  • Profile Image
    JotForm Support

    Answered by jonathan on April 10, 2013 at 08:31 PM

    You can indeed change the form's labels/questions.

    Maybe make it similar to the sections name? This will make it also easier for you to identify the field/column name in the submission grid. 

    BUT I'll tell you ahead -- empty fields, will still be displayed in the grid. So, it does not suffice your long grid view with empty fields/columns on it.

    ---

    You can also use google spreadsheet integration. When you view the submissions in gdocs spreadsheet, you can use the gdocs auto filter function to for the column you want to show only(non empty names).

    Thanks.

  • Profile Image
    JotForm Support

    Answered by jonathan on April 10, 2013 at 10:14 PM

    VK,

    I am not sure what happen, but your post ended up in our inbox again, but it was devoid of message details. Please reply again using this link  so we can know your updated response.

    Thanks.

  • Profile Image

    Answered by Vatche on April 10, 2013 at 10:43 PM

    That’s a great idea ie the google docs as that’s what I was going to be using since I have to integrate the old submissions with the new submissions..

  • Profile Image
    JotForm Support

    Answered by jonathan on April 10, 2013 at 10:52 PM

    Glad to know that it is an option you can take. Feel free to contact us anytime should you have other inquiry.

    Thanks.