Can I use the form conditional logic to send to two separate Google Sheets?

  • Profile Image
    chubster22
    Asked on April 29, 2019 at 12:43 PM

    I have integrated my Google Sheets with the form and it is working brilliantly. I would like the form data to send to different sheets (two different sheets) depending on answers submitted from a question on the form. 

    Is this possible?

    I'm guessing the integration provides one connection so the answer is to create another Google sheet and reference the required data using the IMPORTRANGE function of Google from the original sheet?

  • Profile Image
    denis_calin
    Answered on April 29, 2019 at 03:08 PM

    Hi @chubster22!

    The Google Sheet integration creates only one Sheet per form. Currently, there is no conditional logic that would send some data to one sheet and some to the other. You can create a separate Google Sheet integrated form and redirect to it based on the respondent's answer. My colleague Richie_P has created a sample form to show you how this would work:

    Form: https://form.jotform.com/82195835504966

    Guide: Change-Thank-You-Page-URL-Based-on-a-Condition

    Another approach would be to use the =IMPORTRANGE function, as you have suggested. Here is one of the better guides on how to implement this: https://www.blog.google/products/g-suite/g-suite-pro-tips-how-sync-one-spreadsheet-another-google-sheets/