send the form data to a different google sheet

  • Mark Livings
    Asked on August 8, 2018 at 2:03 PM

    I want to be able to send the form data to a different google sheet based on what a person answers on the Jot form.

    I would setup a drop down that has two options ( A and B ).   If the user selects A then the data they enter in the remanning part of the form gets saved in Google Sheets A.  If they select B then the data gets saved in Google Sheets B.


  • Richie JotForm Support
    Replied on August 8, 2018 at 2:39 PM

    You can only integrate one Google Sheet per form. To be able to do this, you need to have two forms with different Google Sheets and redirect the form depending on the options selected.

    Guide:https://www.jotform.com/help/317-Change-Thank-You-Page-URL-Based-on-a-Condition

    Here is my sample form:https://form.jotform.com/82195835504966

    Hope this information helps.

    Please let us know if you have further questions.

    Thank you.