- PaulvanaackenAsked on May 14, 2015 at 11:22 AM
My church members tell me they do not like to fill in their email addresses over and over again, each time they register for an event. My question is can I manage to autofill a field using the parameters from another field?
- JotForm SupportdavidAnswered on May 14, 2015 at 01:19 PM
It is indeed possible to fill fields based on the entries in other fields using the "Update a form field value" condition:
Here is a quick test form to show you how it works:
If you need any help getting this setup in your form, just let us know and we will be happy to assist you.
- lagedorAnswered on May 14, 2015 at 03:48 PM
Thanks for your quick response.
I am actually looking for something else. Let me explain what I want to do.
I have a list of members with First & Last Names, email addresses etc..
What I would like to do is based upon the user input of their name search through the list of members and autofill the field email address with the value found in the list, corresponding with the last name as a pointer.
I hope I expressed myself better this time.
- JotForm SupportdavidAnswered on May 14, 2015 at 04:12 PM
It is, unfortunately, not possible to reference previous submissions in order to fill the form with the data of your users. It would be possible for them to select their name from a list and have the rest of the form populated with their data. However, this would require manually entering the form field updates for each person and adding them to your list.
The form would function something like this:
The conditions would be similar to this:
Depending on how many users you have and the number of fields you wish to update, this list could get fairly large rather quickly.
If you would like to give this a try and have any trouble setting it up, let us know and we will be happy to help.
- lagedorAnswered on May 14, 2015 at 05:57 PM
Thanks again for the quick turnaround.
I would like to further work on this possibility. If you could give me some pointers, I would appreciate it.
- JotForm SupportdavidAnswered on May 14, 2015 at 06:18 PM
To get started, you would need to create a dropdown or some other type of field for your users to enter their information. I used a dropdown due to direct selection being easier for users to directly select their full name, rather than having the fields update based off one name.
You would then setup your field update conditions to fill in your other fields based off that selection.
In my example form, if person1 is selected, then the name field is populated with "Person1 Person1" and the email field is populated with "Person1@person1.com". This is done via the conditions.
If you would like to see the specific setup of my demo form, you can clone it to your own account:
Using this URL:
- lagedorAnswered on May 15, 2015 at 05:51 AM
I went along and started to work using your example. I filled the box select name with a series of names, then started to work on the field conditions for Email. The first two entries work OK, but when I want to edit the third condition, in the field IF - field SELECT NAME - field IS EQUAL TO it starts to go wrong, even if I select number 3 from the list of possible names, the form persists in showing the first entry of the list after the field IS EQUAL TO.....
Can you have a look at what I am doing wrong?
The form lives at http://www.jotform.com/?formID=51342989705363
- BorisAnswered on May 15, 2015 at 08:48 AM
You are on the right track, Paul. Please note that you can remove the old conditions that are no longer being used in your form (they have a red field deleted text on them). You can remove them by clicking on the small red icon that appears when you hover over the conditions, as marked in the image below.
After removing unused conditions (marked with 1), we can see that two of the remaining conditions are conflicting (marked with 2).
They say something along the lines:
"If the name is equal to Boris, then email must be email@example.com.
But also, if name is equal to Boris, then email must be firstname.lastname@example.org"
As the email can't be two different things at the same time, there is a conflict in the Conditions. Please remove one of them, and after that you can add further conditions and everything should work correctly.
Please let us know how it goes, or if you need further help, and we will be happy to help you.
- lagedorAnswered on May 16, 2015 at 07:41 AM
However, even after cleaning the conflicting conditions, I still can't select the third name from the list of names in the "SELECT PERSON" list in the Conditions Wizard. It allows me to select the 1st and 2nd name, but not the 3rd and higher.
Is there a setting that limits the selection to 2? I have entered some 60 names in the SELECT PERSON list in the form. the form sits at http://www.jotform.com//?formID=51342989705363
thanks for the help.
- JotForm SupportJanAnswered on May 16, 2015 at 09:57 AM
I was able to replicate your issue. Every time I tried to create a condition, I cannot select some options. I removed the extra spaces on 3rd and 4th options and I was able to make it work.
Can you please try to avoid using unnecessary spaces or spaces after each option in the drop down. Please limit 1 space per word. (e.g FirstName LastName)
After doing that, you should be able to add the option in the condition.
Hope this helps. Thank you.
- lagedorAnswered on May 16, 2015 at 11:11 AM
I have found a great work around that gives me close to what I want.
In the FORM conditions (not the field conditions..!) I use IF - NAME - CONTAINS - NNN then insert in the the email field email@example.com.
This works like a beaty! fast and easy to work.
Maybe this will also help other users haveing the same requirement.
Paul van Aacken
- JotForm SupportJanAnswered on May 16, 2015 at 12:31 PM
Glad to hear that you found a workaround. Let us know if you need any help. Thank you.