Can I get a daily summary of the previous days completed forms?

  • tinman230
    Asked on April 19, 2016 at 10:52 PM

    I would like to receive an automated summary which shows each of my forms total entries from the previous day. Is there an app for this?

  • Chriistian Jotform Support
    Replied on April 20, 2016 at 2:26 AM

    If I understand correctly, you want to automatically receive a report on your forms? Unfortunately, that is currently not possible in jotform. I believe the closest app that is suitable for your requirement would be the Daily Digest app. The daily digest app will send you the submissions on all your forms within a set time. Please follow this link to view the app: http://digest.jotform.io/ 

    If you need further assistance, please let us know.
    Regards.

  • tinman230
    Replied on April 24, 2016 at 6:44 AM
    Actually what I am looking for is a simple summary of how many submissions I had from each form at the end of each day.
    So for example, I have 7 forms, All I want to know is how many submission each form received per day, but the key is I need it to be automated.
    So an email, or a file generation, what ever is out there, to simply say:
    Form 1 = 32 submissions
    Form 2 = 198 submissions
    Form 3 = 22 submissions
    Form 4 = 257 submissions
    Form 5 = 100 submissions
    Form 6 = 432 submissions
    Form 7 = 28 submissions
    It can be as simple as that or as complex as current apps allow, I just need to achieve a daily count of total submissions per each form, per day, automatically, if at all possible of course.
    I do use the email from Daily Digest, but it adds all of my forms submissions together, while I need to know how many submissions I totaled for each form.
    Please let me know if there is anything out there which could help me achieve this? Thanks for your help.
    CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution, or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please notify the sender and delete it from your system.
    ...
  • Mike_G JotForm Support
    Replied on April 24, 2016 at 12:35 PM

    I have created a workaround that you might want to use. I just hope that this is what you really wanted to achieve.

    The workaround I'm pertaining to would require you to integrate all the forms you want to count daily submissions to Google Spreadsheet.

    Once you have integrated the forms, please take note of the value of "key" from the link generated upon integration.

    Can I get a daily summary of the previous days completed forms? Image 1 Screenshot 60

    After that, access the link to go to the spreadsheet. On the spreadsheet, you will need three functions.

    1. =NOW()

    Since what you need is the submission per day, you need to have a way to find out what is the current date.

    Can I get a daily summary of the previous days completed forms? Image 2 Screenshot 71

    Then, you need to compare the value given by that function to the dates in the Submission Date column. Once the date matches, it will be counted.

    2. =SUMPRODUCT()

    This functions as a way to count the number of data in a range of cells that match or is equal to the data in a particular cell or range. On the image below, you will see that I have compared the data in column A (from A1 to A10001) to the data in cell H1 to see if it matches. The function will return the total of matches base on the data from the cells being compared.

    Can I get a daily summary of the previous days completed forms? Image 3 Screenshot 82

    3. =INT()

    On the image above, you will notice that the function "=INT()" was used. This will convert the value of cells in column A (from range A2 to A10001) to integer(rounded down). It is also used with the value of the cell where we have placed "=NOW()". The converted values are then compared in "=SUMPRODUCT()" using "=".

    Notice that the cells where we have placed the functions are cells in line with the headers(Row 1).

    Here's the "=SUMPRODUCT()" function shown on the image 

    =SUMPRODUCT(--(INT(A2:A10001)=INT(H1)))

    Please do the same to all of your forms Google Spreadsheet. And once you're done, you will need open/create a blank Google Spreadsheet where you will store the daily submission data of each of your forms.

    In that spreadsheet, you will use another function, "=IMPORTRANGE()". You will use this to gather data from different spreadsheets. To do that, you will use these:value of "key" from the integration, the title/name of the sheet from your spreadsheet, and the cell that has the data of the daily submission where you have used the "

    1. Value of "key" from the integration the title/name of the sheet from your spreadsheet, and the cell that has the data of the daily submission where you have used the "

    2. The title/name of the sheet from your spreadsheet

    3. The cell that has the data of the daily submission where you have used the "=SUMPRODUCT()"

    Here's how it is constructed:

    Can I get a daily summary of the previous days completed forms? Image 4 Screenshot 93

    Once you have listed all of the forms and their corresponding "=IMPORTRANGE()" function, it should work like this, (Please see screencast below)

    Can I get a daily summary of the previous days completed forms? Image 5 Screenshot 104

    By the way, I'm still looking for a way to automatically download the final spreadsheet every 11:59:59 PM so that we can keep a record of it on a daily basis. Unless you would like to download the final spreadsheet manually before the clock strikes 12 MN. Because I believe, the data will be back to zero come that time since there will be no submission date that will match the value of "=NOW()", if I am not mistaken.

    Anyway, I hope this helps. If you have any other questions, please feel free to let us know and we will be glad to help you. Thank you.

  • tinman230
    Replied on April 25, 2016 at 6:44 PM
    I think this will be great help. I already had the forms integrated to google sheets. I am going to attempt the formula builder this evening.
    Here is a thought, instead of the final spread sheet having to be downloaded by 11:59pm daily, is there a way to make the final spread sheet populate columns to the right or rows downward to continue a rolling count of form submissions per day?
    ...
  • Chriistian Jotform Support
    Replied on April 25, 2016 at 11:19 PM

    Unfortunately, I think the said logic is complicated in such way that it cannot be done using Google spreadsheet alone. We are still trying to find a way to automatically download the spreadsheet on a daily basis. We will inform you on this thread any updates.

  • tinman230
    Replied on April 26, 2016 at 8:44 AM
    Ok. Hey, this workaround you gave me is absolutely wonderful! It saves my analyst 30+ mins a day. So thank you for that. This support team at jotform is second to none. I value this greatly. So thanks again for all the help, support, and patience! Enjoy your day!
    ...
  • Kevin Support Team Lead
    Replied on April 26, 2016 at 10:12 AM

    Great to know the workaround provided by my colleagues helped, on behalf of them, you're welcome. 

    If you need help or have more questions, do not hesitate to contact us, we will be glad to help you.