Is there a way you can import data into mailchimp HTML text - eg total submissions?

  • tomboy
    Asked on April 19, 2017 at 3:11 AM

    Is there a way you can import data into mailchimp HTML text - eg total submissions?

    Congratulations; your form has received 26 submissions this week.

    We have found the daily digest email aesthetically limited.

  • Charlie
    Replied on April 19, 2017 at 3:27 AM

    I am not quite familiar with MailChimp's HTML text, is this just a plain field where you can embed things? Or what do you mean by import? You can check this guide regarding some reports that you can embed on websites: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm. But if you are looking for something similar to our Daily Digest app that can be customizable, then I'm sorry to say that we do not have one. 

    You can check our apps page to see if there's something that might work for you there: https://apps.jotform.com/

    The next solution that I can think of is quite advanced and involves programming. 

    Solution #1:

    1. Integrate your form to Google Spreadsheet

    2. Create a script in your Google Spreadsheet that will automatically count submissions based on a date range and send an email to you.

    Something similar to this: https://developers.google.com/apps-script/articles/sending_emails. The only concern that I have is running it on a scheduled basis like once a week. 

     

    Solution #2:

    If you have your own server where you can execute scripts or set cron job, then you can create a script that involves JotForm's API. Using the API, you can count submissions on your forms based on a date range, then send an email from your own server. The cron job will allow you to schedule the script to run on a scheduled basis. To learn more about this, you can check the following links:

    JotForm API: http://api.jotform.com/docs/ 

    Cron Job depends on the web hosting service that you have, you can consult your support team there if they have cron job that you can set up.

     

    I hope that helps.