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.
How to move form submissions to different spreadsheets based on the selection on the form?Asked by mahindrausa on August 29, 2016 at 02:37 PM
I would like the response to go into a different Google Sheet depending on the answer. For instance the question is "Who is this for?" The answers are "Person A, Person B, and Person C." Only Person C needs to see the responses made for Person C- can I make sheet for only responses concerning that person?
This is a re-post of a comment on How to Integrate a Form with Google Drive
I understand that you want to integrate multiple Google spreadsheets to your JotForm so that the responses send to different spreadsheets based on the selection on the form.
Unfortunately, it is not possible to integrate multiple spreadsheets to a single form. You may need to write a macro or use QUERY function something like below to copy the values to another sheet of the same workbook.
=query(all!A:E, "where C='Active'",1)
Learn more about QUERY from the Google support below:
Please be noted that any changes made to the main sheet receiving the submissions will break the integration and the form submissions cannot be sent to the spreadsheet.
Hope this information helps!