What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Can I create multiple Google Spreadsheets based on Data being submitted?Asked by nolitahouse on January 21, 2014 at 07:28 AM
I am wondering if all submissions need to go into one Google Spreadsheet or is there a way to create a rule to create a new spreadsheet when certain data requirements are met. I am looking to capture a single day's data in one spreadsheet and then when the submission date changes a new Google spreadsheet is created with the next day's data.
Unfortunately, it is not possible. When you integrate your form with google spreadsheet, immediately an excel spreadsheet in created in your google drive and the URL is attached to your form.
Every new submission will go to this google spreadsheet only and there is no feature where you can create a new spreadsheet for everyday.
Thanks for the quick reply. I'd have to say that you guys at Jotform are very on point with your responses and I love your product. Keep up the great work.
Thank you for the kind words. =)
As I reviewed your original question, I think there can be also a workaround that you may want to try to achieve what you need.
My suggestion will not create a new spreadsheet base on everyday submissions (as explained by our colleague already, this is not an available option)
BUT if you look at google spreadsheet, there is a way to filter its content/data -- what I am saying is, you can just create a custom filter or query within the Google docs spreadsheet application base on Date(daily).
You can then create a new spreadsheet and copy all the filtered data from the spreadsheet to the new spreadsheet.
I search google and found this article.