send the form data to a different google sheet

  • Profile Image
    Mark Livings
    Asked on August 08, 2018 at 02: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.


  • Profile Image
    Richie_P
    Answered on August 08, 2018 at 02: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.