How can i change the integration destination file (spreadsheet) to change daily.

  • Profile Image
    karthiksilambu
    Asked on February 08, 2016 at 05:10 PM

    I am using spreadsheet as my integration type. My requirement is to create separate spreadsheet daily (or weekly). Is it possible to change the integration dynamically like nightly jobs?

    Say today (2/8/2016) my backend spreadsheet file name should be result_2_8_16.xls. Entries happening tomorrow (2/9/2016), should be stored in separate file say result_2_9_16.xls.

    Is it possible? if so, how can i achieve it?

    Thanks in advance.

    Karthik. S

  • Profile Image
    ashwin_d
    Answered on February 09, 2016 at 12:44 AM

    Hello Karthik,

    Unfortunately it is not possible to achieve your requirement. Please be noted that once your integrate your form with google spreadsheet, it remains active unless you reintegrate your form.

    If your requirement is to just download the submission data in excel, you may like to take a look at the following options:

    #1. You may like to take a look at "Reports To Cloud" app which will download the submission excel every day.

    #2. You can create a "Excel Report" which will give you a download URL. You can click on teh URL to download the up to date submissions any time:  http://www.jotform.com/help/101-How-to-create-an-Excel-Report 

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!