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.
MailChimp Integration: Separating First Name and Last Name FieldAsked by nbromyard on July 30, 2013 at 06:47 PM
I'm trying to link my form to a MC list. The first problem is the field on the left Full Name doesnt exist on my MC list. It should be first name last name but I cant even select these or add them as an option. Then Membership Type only lets me select date of birth 3 times instead of a hidden field membership type. I have left the integration connected so you can see. I have tried clearing the cache 2 x different API keys and clearing all of my data down.
Can you help please?
integrate problem name cache hidden
To map the Full Name, you have to use Full Name tool under Quick Tools to match it to your MailChimp Form.
However, if you'd like to use two separate fields for the full name (firstname & lastname), follow this guide:
1. Delete the Mail Chimp's default "First Name" and "Last Name" fields (You should set them first as unrequired and then delete). After that, recreate the two fields.
2. Re-integrate your form to MC, you should be able to set them after that.
For the membership type, if it still doesn't allow you to map using hidden box, replace it with normal text box instead and hide it using custom CSS injection. You can use the following code.
Replace the #fieldID with the field ID of the membership text box. Here's How to find Field IDs & Names on the fields.
Let us know if you have any difficulties with the steps above so we can assist you further.
By the way, you have to recreate the First Name and Last Name field in your MailChimp form after deleting the default fields. I forgot to mention it, sorry.
Thanks for the prompr response. However removing the fields in the MC list and the nrecreating them even with slightly different names doesnt help. When you run the integration it still prompts to link an MC field called Full name which doesnt exist in the MC list or thew form.
Im your MailChimp account, please go to your List Setting > List Fields then remove the First Name and Last Name Field (not in the form) then create a new text field e.g. First Name and Last Name, please do these step before integrating MailChimp in Jotform. This is similar to what Elton said but we are using a different approach this time.
In your form builder, create two text field e.g First Name and Last Name
Set the field in the Match Form Fields window.
Then you will be to separate the first name and last name as shown below. Note that some delay may occur like 2-3 seconds.
Thanks for the reply. But what you are describing from the MC side is
exactly what I Did twice. Once with the same field names and once with
slightly different names. The only difference is I didn't need to create the
fields on the Jot form as they already existed. Are you saying it won't work
unless I remove them on the Jot form and but them back again?
You do not need to remove the field in your form builder, you only need to match the field on your Jotform and MailChimp. Also, I have checked account did not find any MailChimp Integration in any of your forms.
the integration wasn't in place because the form is live. I have put it back
but the fields mapped are incorrect.
1. This is the MC list the first and last name fields have been removed and
replaced by First-name and Last-name (both Text fields)
2. This is part of my Jot form showing two text fields for the name
4. This is the screen I get when I try to map the fields. Note the Full name
which I can't change
I hope this shows the problem more clearly. How do I get the integration
screen to show me first and last names in the left hand column? So I can map
Can you please provide us a screenshot of the MailChimp field setting you have created for the List called 'All Members' in your MailChimp account. A similar screenshot below would really be helpful.
The left hand columns fields are the MailChimp Fields and right column is the jotform fields, click add new option to show that option of matching fields.
Here is a screen shoot of the All members list in Mail Chimp as requested
there are other fields that are not showing but none called Full Name.
Please note I have tried to integrate with the required flag not set as well
in case that had an effect.:-
We are unable to see the screenshot in your response. Please use this link and paste the url here to share the screenshot you made.
Please try setting the FNAME and LNAME to MERGE1 and MERGE2.
After removing the integration and clearing the forms cache this now works.
The next problem is membership type! is there anyway I can put a hidden drop
down or radio button on the jot form?
Many Thanks for the help so far.
Please create a separate thread for the next question as it would be irrelavant to the thread title. Our team would also be able to provide much better assistance then.