can the excel sheet be emailed automatically

  • Profile Image
    weddingday
    Asked on March 21, 2012 at 04:40 PM

    Hi, I'm wanting to find out if the xcel spreadsheet can be set to periodically email to a set address. Or alternatively whether it can be set to email the spreadsheet whenever a new entry is submitted.

     Cheers. Tonino.

  • Profile Image
    gori-mathew
    Answered on March 21, 2012 at 04:47 PM

    Hello;

    Yes this is possible, Just send him the Excel URL and he will be able to download the latest spreadsheet every time he clicks on the link. 

    More information on downloading excel reports can be achieved using this guide; http://www.jotform.com/answers/73958-Can-I-download-the-form-submissions-into-an-excel-sheet

    Hope this information is helpful.

  • Profile Image
    weddingday
    Answered on March 21, 2012 at 05:56 PM

    Thanks Gori-Mathew,

    Helpful...but. What is the Excel URL? Do you mean the URL of the submissions page?

    Does your explaination mean: Every time he clicks the link, it will initiate the download without opening a Safari browser window? (That would be ideal).

    OR is it; Everytime he clicks the link, it will open a Safari browser window, try to log into my JotForm account and then opens the submissions page, and then he has to manually click the 'download as Excel' button?

    Cheers

    Tonino

  • Profile Image
    fxr
    Answered on March 21, 2012 at 07:28 PM

    Hello Tonino,

    You can generate an excel report as per this guide : http://www.jotform.com/help/101-Generate-Excel-Report

    Then just email the link around to whoever you want to have access to it. 

    You can also password protect the report.