- VatcheAsked 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?
- JotForm SupportjonathanAnswered on March 04, 2013 at 01:04 AM
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.
- VatcheAnswered 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
- JotForm SupportWelvinAnswered on March 24, 2013 at 01:54 AM
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.
- VatcheAnswered 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..
- JotForm SupportMike_TAnswered 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.
- VatcheAnswered 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.
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
- JotForm SupportjonathanAnswered on April 10, 2013 at 07:19 PM
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.
- JotForm SupportjonathanAnswered on April 10, 2013 at 07:51 PM
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.
- VatcheAnswered 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..
- JotForm SupportjonathanAnswered 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).
- JotForm SupportjonathanAnswered on April 10, 2013 at 10:14 PM
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.
- VatcheAnswered 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..
- JotForm SupportjonathanAnswered 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.