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.
Different Google spreadsheet depending on submission input.Asked by phillipclose on November 07, 2013 at 05:03 AM
Can I have the google spreadsheet creat a new 'sheet' depending on the submissions.
I really like the google drive application because this allows me to then share the document with different people. However if it could divide the info onto different sheets this would be fantastic.
There is no quick feature to achieve this. However, a work around you can work on is to create different forms with google integration for each form (different spreadsheet), and link them to the one form (original form) and create a radio button or drop-down field with conditions to which form it will redirect.
Then for each form, you will integrate with google spreadsheet so their submission will depend on their chosen option. And different spreadsheet.
Please let us know if you have further clarification and if you need further assistance on this.
We're here to help.