How to move form submissions to different spreadsheets based on the selection on the form?

  • Profile Image
    mahindrausa
    Asked 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

  • Profile Image
    Kiran
    Answered on August 29, 2016 at 04:01 PM

    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:

    https://support.google.com/docs/answer/3093343?hl=en

    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!