How can auto generate daily csv/excel file to email?

  • swtemp999
    Asked on April 23, 2019 at 9:25 PM

    How can auto generate daily csv/excel file to email. Like every day 12am will send the submission details on that day. Then next day 12am again will receive a new csv/excel file again

  • roneet
    Replied on April 23, 2019 at 11:17 PM

    There are a couple of reports which you could use:

    How can auto generate daily csv/excel file to email? Image 10

    To create an Excel report, please check this guide:

    https://www.jotform.com/help/101-How-to-Create-an-Excel-Report

    Thanks.

  • swtemp999
    Replied on April 23, 2019 at 11:34 PM

    I dont want manually to generate the excel report, may I know gt another ways to generate the daily/weekly excel report?

  • roneet
    Replied on April 24, 2019 at 12:17 AM

    These Excel/CSV/Grid/HTML/Table report once generated could be used in future. The URL would not be changed and you do not have to generate the report manually every time. Whenever you like to view the report you may use the URL to check the submissions. It would be auto updated.

    Please generate any of the reports to check this. It would be generated once and you can use this every time.

    Do let us know if you are referring to something else.

    Thanks.

  • swtemp999
    Replied on May 2, 2019 at 11:10 PM

    But I also need manually to copy and paste the URL to download the excel file

    do u have any another ways to automatic download the excel file?

  • roneet
    Replied on May 3, 2019 at 3:05 AM

    I am afraid that there is no other way to automatically download the file but I think the following should work:

    1. Create an excel report: https://www.jotform.com/help/101-How-to-create-an-Excel-Report. The excel report will generate a link for you to download the report. This is static, and you can use the same link if you want to generate a new file.

    2. Put this the excel report link in the notification email of the form. This way, once you have a new submission, the link will be included there, and you can simply click on it to download a file.

    Thanks.