Submission Counter: How to show the number of submissions per day in the reminder email?

  • Profile Image
    Edmon86
    Asked on November 28, 2020 at 05:12 PM

    Dear all,

    Is it possible to set up a mail digest including all form submissions of the previous XX hours, scheduled at a specific time of day and including custom fields only (e.g. "Dear XXX, today there were XXX submissions on your form")?

    Thanks !


  • Profile Image
    Roneet
    Answered on November 28, 2020 at 08:53 PM

    You may consider creating a report download link, see the next guide:

    How to Create an Excel Report

    Then, including it in the form reminder email. Please insert the URL of the report into the email content.

    15614021023.png15614021364.png

    This way you will be able to click on a link in the email to download the Excel report file.

    Thanks.

  • Profile Image
    Edmon86
    Answered on November 29, 2020 at 11:10 AM

    Thanks, this definitely goes into the right direction!

    And would you/anyone have an idea on how to embed some information directly in the reminder email (for example the number of subscribers), without linking to the full report ?



  • Profile Image
    Kenneth
    Answered on November 29, 2020 at 01:36 PM

    Hi there,

    If you meant to add in the number of guests to the Reminder emails, you may do so by inserting the Unique name:

    1606674867_5fc3e9b339f0f_y1.png

    I hope that helps.

    Best.

  • Profile Image
    Edmon86
    Answered on December 11, 2020 at 03:15 PM

    Thanks Kenneth,

    Any chance of also displaying the total amount of form submissions in the reminder email?

    For example: "Dear XXX, today you received XX form submissions".

    Thank you!





  • Profile Image
    Zahra_S
    Answered on December 11, 2020 at 07:01 PM

    Hi there,

    It looks like you want to have a submission count you want to display in the reminder email.

    We have a really cool widget for this purpose.

    SUBMISSION COUNTER WIDGET: https://www.jotform.com/widgets/submissions-counter

    What you can do with this widget:

    1. Add it to your form from the Widgets tab.
    2. Customize the text with the counter.
    3. Hide the field from the form.
    4. You have the option to display Today Submissions or Total Submissions.
    5. Use the unique name of the field to display it in your reminder email.
    6. You can customize the color, size, and look of the counter.
    7. Ensure that the unique name isn't mentioned in the autoresponder email because when we add any field in the form, it automatically adds to the email. You can easily edit your emails.

    Related Guide: how-to-edit-the-email-template-for-notifications-and-autoresponders

    Demo Form: https://form.jotform.com/60961441672962

    I hope this helps!

    Let us know if you need further assistance.