Mailchimp integration not passing data.

  • JRatcliff
    Asked on February 2, 2023 at 1:58 PM

    Good morning,

    I have a form to approve a persons email addition to a mailchimp account. I've used it in the past and it worked pretty well. Now, however, I can seem to get it to link to mailchimp even though I've done what I need to do, at least I think I have.

    I don't know if this is a jotform fix or a mailchimp fix.

    I've added my form here:

    https://form.jotform.com/222078182688061


    Thank you so much for all your help,

    Jane Ratcliff

    jratclif2002@yahoo.com

  • Mafe_M JotForm Support
    Replied on February 2, 2023 at 3:02 PM

    Hello Jane,

    Thank you for reaching out to Jotform Support. I am sorry this is happening. Rest assured, I am here to help. Can you explain a bit more about the issue so I can get a better idea of what's happening? If you can share a screenshot of what is happening that would be great so that we can provide you the best resolution for your concern. This guide will show you how to do that. 

    Once we hear back from you, we'll be able to move forward with a solution.



  • JRatcliff
    Replied on February 2, 2023 at 3:31 PM

    I've set up the form, the one I sent a link to, and here is a shot of the conditions I set up for information to be sent to the mailchimp account. However, when I go to mailchimp and try to enter an email address in the contacts, even though I have the Jotform form attached, the person who filled out the form does not show up. I followed the tutorial instructions on mailchimp, more than once and it just isn't working.

    1675369748 63dc1d148468b  Screenshot 10

  • JRatcliff
    Replied on February 2, 2023 at 3:46 PM

    When I go to mailchimp, contacts and enter new contact, the name and email are supposed to be there, but they are not. When I manually enter the email address and name, this is what I get:

    1675370759 63dc21077c83b  Screenshot 10

  • Mafe_M JotForm Support
    Replied on February 2, 2023 at 5:11 PM

    Hello Jane,

    Thank you for getting back at us. To confirm the email address that you are inputting in Mailchimp is a successful submission? If yes, then we send the data to Mailchimp from the submissions table. Let me show you how to do it:

    • In the submission table, Click +Add

    1674593752 63d045d8855f4  Screenshot 10

    • Go to Buttons tab and choose Send Data to Other Apps
    • Click Next

    1674593790 63d045fecf050  Screenshot 21

    • Enter a Column Name on the box provided
    • Click Next

    1674593889 63d046618dfc8  Screenshot 32

    • Choose Mailchimp by putting a checkmark on the tick box
    • Click Create Column

    1674593947 63d0469b93de6  Screenshot 43

    • It will look like this after the column has been created. Please see screenshot.

    1674594058 63d0470a9c49b  Screenshot 54

    • Now choose the submissions or submissions you want to send to MailChimp. You can do it one by one or you can select all submissions in one go and the click on three dots right beside delete and from the options you can select Send Data to Mailchimp.

    1674594340 63d0482499088  Screenshot 65

    Give it a try and let us know how it goes.

  • JRatcliff
    Replied on February 2, 2023 at 6:35 PM

    I've done this as instructed and have "sent" the email address from the form to mailchimp three times and it's still not working. I've tried sending via the "Send Data" column as well as from the three dots beside the name. I signed out of mailchimp and logged in again, I've refreshed the page, and still nothing.

    I've deleted the integration and reentered it again.

    Still don't know what I'm doing wrong.


  • Rene JotForm Support
    Replied on February 3, 2023 at 1:09 AM

    Hello Jane,

    Thanks for getting back to us. I cloned your form and tested it to see if I could replicate the issue, but everything was working properly. Check out the screencast below to see my results:

    1675404566 63dca51635cf6  Screenshot 10

    I've cleared your form caches to see if this would correct any unnecessary errors in the form. Can you try reintegrating Mailchimp again and see how it goes? If you run into the same problem again, let us know and we'll do some more testing to see what's going on. 

    Give it a try and let us know how it goes.

  • JRatcliff
    Replied on February 3, 2023 at 8:51 AM

    I went to my form and the integration was still there, so I deleted it. Closed jotform, went back to jotform and reintegrated Mailchimp again. Resent the submission to mailchimp - twice and still nothing. I've refreshed the mailchimp page, logged out, logged back in, and still nothing.

    I never get the "mission accomplished" green tag across the screen anywhere, and if I try to enter the email directly to mailchimp, I still get the orange message line at the top of the page, and it won't let me add her to the contact list.

    I went back to the integration page and set it to send only the email address and it still doesn't work.

    1675432608 63dd12a0c75dc  Screenshot 10

  • Olivia JotForm Support
    Replied on February 3, 2023 at 9:38 AM

    Hi JRatcliff,

    Thanks for getting back to us. As per further investigation, this error comes from Mailchimp’s side. To integrate Mailchimp, we are using their public API and, for security/spam reasons, users who were deleted cannot re-subscribe. You can check this guide in order to fix this problem or contact Mailchimp’s support

    Let us know if you need any other help.

  • JRatcliff
    Replied on February 7, 2023 at 6:16 PM

    I've tried to get information from Mailchimp support, have followed all their instructions, and even generated a new Jotform signup form and it still doesn't work. This is the message I get: This contact was previously removed from this audience. To rejoin, they'll need to sign up using a Mailchimp form.

    As a non-profit, mailchimp support will not offer any support.

    This is my new form: https://form.jotform.com/230376461910150


  • Rene JotForm Support
    Replied on February 7, 2023 at 10:28 PM

    Hello Jane,

    I'm sorry that you're having issues with this. The link to your new form is directing me to a deleted form. However, to isolate the issue, could you please try the integration to a newly created form by only adding a name and email field to see if this would make any difference?

    Give it a try and let us know how it goes.

  • JRatcliff
    Replied on February 7, 2023 at 11:17 PM

    That's what I did. I created a new form with name and email, still didn't work.

    I finally created a form on Mailchimp so I can copy the url, send it to the person and they can sign up there. Their name and email comes right in to my email list on Mailchimp.

    I don't like having to do the copy/paste thing, but it works.


  • Rene JotForm Support
    Replied on February 8, 2023 at 12:23 AM

    Hello Jane,

    Thanks for getting back to us and for keeping us updated. It is good to know that you were able to find a way in resolving the issue. Please don't hesitate to let us know if you have any other concerns related to Jotform, we are happy to help.

    Let us know if there's anything else we can help you with.

  • JRatcliff
    Replied on February 9, 2023 at 1:50 PM
    Unfortunately, you couldn't help me with the issue.  So I ended up going with another software to solve the issue.
    On Thursday, February 9, 2023 at 10:00:55 AM PST, noreply@jotform.com wrote:

    Subject: Your ticket has been answered. Tell us how we did!#yiv1097779945 :root {}#yiv1097779945 html, #yiv1097779945 body {margin:0 auto !important;padding:0 !important;min-height:100% !important;width:100% !important;}#yiv1097779945 body {}#yiv1097779945 .yiv1097779945body {margin:0 auto !important;}#yiv1097779945 * {}#yiv1097779945 div, #yiv1097779945 p, #yiv1097779945 a, #yiv1097779945 li, #yiv1097779945 td {}#yiv1097779945 div .yiv1097779945filtered99999 {margin:0 !important;}#yiv1097779945 table, #yiv1097779945 td {}#yiv1097779945 table {border-spacing:0 !important;border-collapse:collapse !important;table-layout:fixed !important;margin:0 auto !important;}#yiv1097779945 table table table {table-layout:auto;}#yiv1097779945 table, #yiv1097779945 td {border-spacing:0 !important;border-collapse:collapse !important;}#yiv1097779945 a {text-decoration:none;}#yiv1097779945 img {}#yiv1097779945 * .yiv1097779945filtered99999 , #yiv1097779945 .yiv1097779945unstyle-auto-detected-links *, #yiv1097779945 .yiv1097779945aBn {border-bottom:0 !important;cursor:default !important;color:inherit !important;text-decoration:none !important;font-size:inherit !important;font-family:inherit !important;font-weight:inherit !important;line-height:inherit !important;}#yiv1097779945 .yiv1097779945im {color:inherit !important;}#yiv1097779945 .yiv1097779945a6S {display:none !important;}#yiv1097779945 img.yiv1097779945g-img+div {display:none !important;}#yiv1097779945 .yiv1097779945nounderline-text {color:#0099FF;text-decoration:none;display:inline-block;}@media screen and (max-width:563px) {#yiv1097779945 .yiv1097779945mobile-full-width {width:100% !important;max-width:100% !important;}#yiv1097779945 .yiv1097779945mobile-nopadding {padding:0 !important;}#yiv1097779945 .yiv1097779945mobile-padding {padding:0 2% 0 2% !important;}#yiv1097779945 .yiv1097779945pricing-box {display:block;margin:0 auto;width:85%;max-width:250px;}#yiv1097779945 .yiv1097779945pricing-box table {max-width:100% !important;}}@media () {#yiv1097779945 h1, #yiv1097779945 h2, #yiv1097779945 h3, #yiv1097779945 p, #yiv1097779945 td, #yiv1097779945 .yiv1097779945form-head {color:#FFFFFF !important;}#yiv1097779945 h1>a {color:#FFFFFF !important;}#yiv1097779945 .yiv1097779945body-bg {background-color:#373740 !important;}#yiv1097779945 .yiv1097779945content-bg {background-color:#333333 !important;}#yiv1097779945 .yiv1097779945dark-img {display:block !important;overflow:visible !important;float:none !important;max-height:inherit !important;max-width:inherit !important;margin-top:0px !important;visibility:inherit !important;}#yiv1097779945 .yiv1097779945light-img {display:none;display:none !important;}#yiv1097779945 .yiv1097779945divider-bg {background-color:#414862 !important;}#yiv1097779945 .yiv1097779945divider-img-bg {background-color:#333333 !important;}#yiv1097779945 .yiv1097779945button-td-primary {background-color:#FF6100 !important;color:#FFFFFF !important;}#yiv1097779945 .yiv1097779945button-a-primary {background-color:#FF6100 !important;color:#FFFFFF !important;}#yiv1097779945 .yiv1097779945transparent-content-img {background-color:#333333 !important;}}@media () {#yiv1097779945 .yiv1097779945light-img {display:block !important;overflow:visible !important;float:none !important;max-height:inherit !important;max-width:inherit !important;margin-top:0px !important;visibility:inherit !important;}#yiv1097779945 .yiv1097779945dark-img {display:none;display:none !important;}}#yiv1097779945 .yiv1097779945filtered99999 .yiv1097779945dark-img {display:block !important;overflow:visible !important;float:none !important;max-height:inherit !important;max-width:inherit !important;margin-top:0px !important;visibility:inherit !important;}#yiv1097779945 .yiv1097779945filtered99999 .yiv1097779945light-img {display:none;display:none !important;}#yiv1097779945 .yiv1097779945button-td, #yiv1097779945 .yiv1097779945button-a {transition:100ms ease-in;}#yiv1097779945 .yiv1097779945show-on-responsive {display:none !important;}#yiv1097779945 u+.yiv1097779945body .yiv1097779945gmail-blend-screen {background:#000;}#yiv1097779945 u+.yiv1097779945body .yiv1097779945gmail-blend-difference {background:#000;}@media screen and (max-width:720px) {#yiv1097779945 .yiv1097779945email-container {width:100% !important;margin:auto !important;}#yiv1097779945 .yiv1097779945padding-container {padding:0px 15px 0px 15px !important;}#yiv1097779945 * .yiv1097779945filtered99999 .yiv1097779945mobile {width:100% !important;}#yiv1097779945 .yiv1097779945fluid {max-width:100% !important;height:auto !important;margin-left:auto !important;margin-right:auto !important;}#yiv1097779945 .yiv1097779945stack-column, #yiv1097779945 .yiv1097779945stack-column-center {display:block !important;width:100% !important;max-width:100% !important;direction:ltr !important;}#yiv1097779945 .yiv1097779945stack-column-center {text-align:center !important;}#yiv1097779945 .yiv1097779945stack-column-center h2, #yiv1097779945 .yiv1097779945stack-column-center p {text-align:center !important;}#yiv1097779945 .yiv1097779945center-on-narrow {text-align:center !important;display:block !important;margin-left:auto !important;margin-right:auto !important;float:none !important;}#yiv1097779945 table.yiv1097779945center-on-narrow {display:inline-block !important;}#yiv1097779945 .yiv1097779945email-container p {}#yiv1097779945 .yiv1097779945button-a {font-size:16px !important;line-height:1 !important;}#yiv1097779945 table td {}#yiv1097779945 .yiv1097779945social-networks {max-width:200px !important;}#yiv1097779945 .yiv1097779945inline-on-responsive {display:block !important;width:100% !important;text-align:center !important;}#yiv1097779945 .yiv1097779945hide-on-responsive {display:none !important;}#yiv1097779945 .yiv1097779945show-on-responsive {display:block !important;}#yiv1097779945 .yiv1097779945full-center-responsive-logo {width:100%;}#yiv1097779945 .yiv1097779945full-center-responsive-logo img {margin:0 auto;}#yiv1097779945 .yiv1097779945mobile-padding-fix {padding-left:15px !important;padding-right:15px !important;}#yiv1097779945 .yiv1097779945mobile-pt-0 {padding-top:0 !important;}#yiv1097779945 .yiv1097779945mobile-pt-16 {padding-top:16px !important;}#yiv1097779945 .yiv1097779945mobile-pt-32 {padding-top:32px !important;}#yiv1097779945 .yiv1097779945mobile-pb-0 {padding-bottom:0 !important;}#yiv1097779945 .yiv1097779945mobile-pb-16 {padding-bottom:16px !important;}#yiv1097779945 .yiv1097779945mobile-pb-32 {padding-bottom:32px !important;}#yiv1097779945 .yiv1097779945mobile-pl-0 {padding-left:0 !important;}#yiv1097779945 .yiv1097779945mobile-pl-16 {padding-left:16px !important;}#yiv1097779945 .yiv1097779945mobile-pl-32 {padding-left:32px !important;}#yiv1097779945 .yiv1097779945mobile-pr-0 {padding-right:0 !important;}#yiv1097779945 .yiv1097779945mobile-pr-16 {padding-right:16px !important;}#yiv1097779945 .yiv1097779945mobile-pr-32 {padding-top:32px !important;}#yiv1097779945 .yiv1097779945g-img {width:100%;height:auto;}}@media screen and (max-width:525px) {#yiv1097779945 .yiv1097779945mobile-hidden {display:none !important;}#yiv1097779945 .yiv1097779945mobile-header-fix {font-size:30px !important;line-height:40px !important;}#yiv1097779945 .yiv1097779945stack-payment-info {display:block !important;width:100% !important;max-width:100% !important;direction:ltr !important;text-align:left !important;min-height:18px !important;padding-top:14px;}#yiv1097779945 .yiv1097779945stack-payment-info.yiv1097779945value-field {padding-bottom:14px;border-bottom:1px solid #EEEEEE;width:100% !important;}}@media screen and (max-width:374px) {#yiv1097779945 .yiv1097779945footer-text-link {display:block !important;width:100% !important;max-width:100% !important;direction:ltr !important;}#yiv1097779945 .yiv1097779945footer-text-link {text-align:center !important;}#yiv1097779945 .yiv1097779945hide-line {display:none !important;}#yiv1097779945 .yiv1097779945inline-on-responsive-min {display:block !important;width:100% !important;text-align:center !important;}#yiv1097779945 .yiv1097779945hide-on-responsive-min {display:none !important;}#yiv1097779945 .yiv1097779945mobile-min-pl-0 {padding-left:0 !important;}}@media only screen and (min-width:320px) and (max-width:374px) {#yiv1097779945 u+.yiv1097779945body {min-width:320px !important;margin:0 auto !important;}#yiv1097779945 .yiv1097779945mobile-header-fix {font-size:22px !important;line-height:32px !important;}}@media only screen and (min-width:375px) and (max-width:413px) {#yiv1097779945 u+.yiv1097779945body {min-width:375px !important;margin:0 auto !important;}#yiv1097779945 .yiv1097779945mobile-header-fix {font-size:26px !important;line-height:36px !important;}}@media only screen and (min-width:414px) {#yiv1097779945 u+.yiv1097779945body {min-width:414px !important;margin:0 auto !important;}}@media only screen and (min-width:526px) and (max-width:600px) {#yiv1097779945 .yiv1097779945mobile-header-fix {font-size:36px !important;line-height:46px !important;}}@media only screen and (min-width:375px) and (max-width:413px) {#yiv1097779945 u+.yiv1097779945body {min-width:375px !important;width:375px !important;margin:0 auto !important;}}#yiv1097779945 #yiv1097779945MessageViewBody, #yiv1097779945 #yiv1097779945MessageWebViewDiv {width:100% !important;margin:0 auto !important;}#yiv1097779945 html .yiv1097779945filtered99999 td p .yiv1097779945filtered99999 , #yiv1097779945 html .yiv1097779945filtered99999 * .yiv1097779945filtered99999 , #yiv1097779945 html .yiv1097779945filtered99999 td h1 {text-align:right !important;}#yiv1097779945 html .yiv1097779945filtered99999 table.yiv1097779945social-area {max-width:350px !important;}#yiv1097779945 html .yiv1097779945filtered99999 .yiv1097779945full-center-responsive-logo {text-align:right;}@media only screen and (min-width:720px) {#yiv1097779945 html .yiv1097779945filtered99999 p.yiv1097779945forRtl-left {text-align:left !important;}#yiv1097779945 html .yiv1097779945filtered99999 p.yiv1097779945forRtl-right {text-align:right !important;}#yiv1097779945 html .yiv1097779945filtered99999 .yiv1097779945hide-on-responsive {text-align:left !important;}}@media screen and (max-width:375px) {#yiv1097779945 .yiv1097779945stack-column-center-min {display:block !important;width:100% !important;max-width:100% !important;direction:ltr !important;}#yiv1097779945 .yiv1097779945mobile-hidden-image {display:none;}}
    | |
    | |

    |   |
    | |
    | View this email in your browser |

    |
    | |
    |
    | |
    | Support ticket answered: |
    |
    Mailchimp integration not passing data.
    |
    |
    |
    |
    |   |
    |   |
    |
    |
    |
    HelloJRatcliff,
    |
    |
    |
    |
    Yoursupport ticket "Mailchimp integrationnot passing data." has been answered. If you still need assistance, justreply to this email.
    |
    |
    |
    |
    Click oneof the icons below to let us know what you think of our service and how we canimprove.
    |
    |
    |
    |
    | |
    |
    | |
    |
    | |
    |
    | |
    |
    | |
    |
    |
    |
    |
    Thank youas always!
    |
    |
    |

    |   |
    |

    |
    |   |
    |
    4 Embarcadero Center, Suite 780, San Francisco CA 94111
    |
    |   |
    |
    |
    |
    24/7 Support
    | |
    Unsubscribe Thread
    |
    |
    |
    |   |

    ...