JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can i change the integration destination file (spreadsheet) to change daily.Asked by karthiksilambu 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.
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.