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

    How can I use the MailChimp app to map data from JotForm Quick Tools fields?

    Asked by MikePMP on July 19, 2015 at 12:56 PM

    I'm trying to set up the MailChimp app in JotForm to automatically send my form data to MailChimp.  When I'm trying to map data fields, the fields I created using JotForm's Quick Tools, such as Full Name and Address, are apparently not able to be mapped correctly.  

     

    For example, I would like to map the First Name and Last Name from the QuickTools "Full Name" data field, but it only shows up as Full Name instead of two separate fields for First Name and Last Name.  Likewise, when I try to map the individual fields from Address, such as Street, City, Postal Code, etc., I only see the following in the MailChimp app's mapping screen:

    *Address
    *Address
    *Address
    *Address
    *Address

    Am I to assume that each of these entries represents a different data field, such as Street, City, State, etc.?

     

    Please clarify how the Quick Tools fields are to be correctly mapped to MailChimp using the MailChimp app in JotForm.

     

    Thanks.

     

     

     

    Page URL:
    http://pmppals.net/become-a-mentor-patients-and-caregivers/

    app mailchimp quick fields
  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2015 at 03:10 PM

    Please follow the suggestion on this same discussion thread.

    http://www.jotform.com/answers/409332-How-to-match-the-address-fields-in-mailchimp-when-the-jot-form-field-is-from-the-quick-tools-menu

    Let us know if you encounter any difficulty doing it.

    Thanks.

     

     

  • Profile Image

    Answered by MikePMP on July 19, 2015 at 04:01 PM

    That's a bit confusing for me.  Let's focus on the "Full Name" field coming from Quick Tools.  In Mailchimp, how do I combine First Name and Last Name into a Merge Field called Full Name that will accept a mapping from my Jotform form?

     http://screencast.com/t/RspmTKlQ

  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2015 at 04:19 PM

    Check the steps from step#4 onward...

     

    4. Delete First Name and Last Name then add it back again.
    5. Then choose Add a field then choose Text
     
    Once you have created back the First Name and Last Name field you can reintegrate the form then try to Add New Option
     
    a. Choose Add New Option
    b. You should now be able to see the field named "Full Name"

    --

    You must delete the FName and LName in your MC list (step#4)

    Then, add a new TEXT type field in your MC list, and name it "Full Name" (step#5)

    Save the MC list.

    Go back to the form and redo the integration. 

    Check if the "Full Name" option is now available in the dropdown list during integration

     

    Update us if still not successful.

    Thanks.

     

     

  • Profile Image

    Answered by MikePMP on July 19, 2015 at 04:29 PM

    Ok, I think I understand how this works.  My dilemma is that my Mailchimp database was imported from another source and has data in lots of different fields and over 400 contacts in it.  So if I start deleting fields to make room for new fields, I'm going to be losing the data from those fields. It seems like I'll need to manually clean up the data that's already there in order to go forward.

     

  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2015 at 04:42 PM

    Do not delete the existing fields in your MC list to avoid loosing your data.

    What you can do instead is create a new API key and use it to the integration.

    So far, I could not reproduce any issue with our MailChimp integration.

    I just test it again on my end, it it work just fine

     

    This is my existing MC list

     

    on the integration, the Quick tools fields (Full Name, Full Address) were available in the field mapping process

     

     

    --

    Try creating a new API key, then use it. See if this makes the difference.

    Let us know if still not resolve.

    Thanks.

  • Profile Image

    Answered by MikePMP on July 19, 2015 at 04:46 PM

    I'm thinking it might be better to just not use the Quick Tools fields, because it sounds to me like they are going to merge all the data into one field in Mailchimp.  For example, even though the Quick Tools "Full Name" field has a First Name and a Last Name, aren't those values going to go into one field called Full Name in Mailchimp?  

    Likewise, if I create an Address field in Mailchimp and then map the Address Quick Tools widget data from JotForm is all the data going to go into one field in Mailchimp?  Which means that I won't be able to filter that data in Mailchimp by a particular part of the address, like State or Country.

     

  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2015 at 05:26 PM

    It will also depends on how you setup your MC list fields...

    Example, in my test MC list, the Full Name field is 2 separate data while the Full Address field were merged into single field.

     

     

    For the Full Address field though, you will have to create separate fields in your form (not the Quick Tools Full Address) if you wanted to mapped each address parts into separate fields in MC list.

    So if you have existing data in your MC list that have separate fields for each Address part, then just create each Address field in the form separately as well so that you will be able to map them during integration.

    Thanks.

     

     

  • Profile Image

    Answered by MikePMP on July 19, 2015 at 05:28 PM

    Got it; thanks.

     

  • Profile Image
    JotForm Support

    Answered by jonathan on July 19, 2015 at 05:40 PM

    You're quite welcome. Feel free to contact us again anytime should you require further assistance.

    Cheers