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

    Mailchimp Integration - Cannot matched date field

    Asked by stephencoverdale on December 28, 2013 at 02:06 AM

    Hey There

    I am trying to integrate Jotform to Mailchimp. But Mailchimp supports date in MMDD or DDMM format as against Jotform that supports date in MMDDYYYY or YYYYMMDD etc. So I could not match up the date field between two platforms. Please suggest a work around.

    Page URL:
    http://form.jotform.co/form/32758359156869?

    Screenshot
    JotForm date field format integrate
  • Profile Image
    JotForm Support

    Answered by EltonCris on December 28, 2013 at 03:52 AM

    Hi,

    I checked Mailchimp's date field, and it has the same date format with Jotform. Sorry but I can't find the format you mentioned (MMDD or DDMM). With this, I am able to mapped the two date fields.

    MailChimp Form:

    Jotform Form:

    Please try it again with the following setup as seen on the screen. Hope it would work this time.

    Thanks!

  • Profile Image

    Answered by stephencoverdale on December 28, 2013 at 04:27 AM

    Thanks Elton. Somehow it was not showing me the same format and when I inserted another date field, it showed the correct format. Please review below:

     

  • Profile Image
    JotForm Support

    Answered by EltonCris on December 28, 2013 at 04:47 AM

    @stephencoverdale

    Yes, that's right. I think recreating the date field might help. Can you mapped the new date field to your Jotform form? Please re-integrate your form with MailChimp with the new date field, that should work.

    Inform us here if you still have difficulties. Thanks!

  • Profile Image

    Answered by stephencoverdale on December 28, 2013 at 04:57 AM

    Yes, That worked perfect. Seems all set now. Thanks for all your help.

  • Profile Image
    JotForm Support

    Answered by EltonCris on December 28, 2013 at 05:15 AM

    You're welcome. Cheers! :)

  • Profile Image

    Answered by stephencoverdale on December 30, 2013 at 05:29 AM

    Elton

    I am in another trouble now. I could see that the form submissions are not being passed into Mailchimp. It passed the old records but new sign ups are not being added.

  • Profile Image
    JotForm Support

    Answered by EltonCris on December 30, 2013 at 07:02 AM

    @stephencoverdale

    Which form are you referring to, is it the same form? Have you tried re-integrating your form to MailChimp? Kindly provide more details so we can check your form further.

    I can't seem to reproduce the problem here. Thank you!

  • Profile Image

    Answered by stephencoverdale on December 30, 2013 at 07:45 AM

    Elton, yes it is the same form. I re-integrated it to Mailchimp and everything works good. The old contacts are added to Mailchimp but new contacts are not being added to Mailchimp. I have matched the fields as well but still the contacts are not getting added to Mailchimp.

  • Profile Image

    Answered by EliezerN on December 30, 2013 at 08:50 AM

    Thanks for providing the information.

    In  order to see if I was able to reproduce the issue I cloned your form and built the integration, but I was not able to reproduce the issue. So, could you please try cloning your form and then build the integration, that could help. Here is how to clone your form: Form cloning

    If the issue still persists with the cloned form, do not hesitate to contact us.

    Thanks

  • Profile Image

    Answered by stephencoverdale on December 31, 2013 at 12:32 AM

    Thanks Eliezer, I cloned the form at http://form.jotformpro.com/form/33640353486961? but it did not help. Just to cross check, do I need to match all the fields? As of now, I am matching only those fields that I really need in Mailchimp.

  • Profile Image

    Answered by stephencoverdale on December 31, 2013 at 12:43 AM

    Ah I got it. I was just testing with same email ID and so it was not being added. Thanks for all your help.