I reconnected my form with Google Sheets and it created a brand new sheet

  • Profile Image
    JamesRiverAssociation
    Asked on April 03, 2019 at 01:47 PM

    I have a form that integrates with Google Sheets. https://form.jotform.com/90793189751975

    I had to set it up with the training dates in multiple questions, because volunteers may choose more than one option, and it makes sorting by training date in excel difficult if there are many in one column.

    I integrated it into google sheets, and then made formulas in other tabs to just pull the information from the people who registered for each date in a separate tab.

    When I went to add more training date questions, google sheets did not pull in the new columns. I tried un-connecting and reconnecting, hoping it would send the new columns, but it just created a brand new sheet with the same name.

    Is there a way to set it up, so it pulls in the new training dates?

    If I set it up for one question for the training dates, and multiple Answers, will the Query formula in Google work if there is more data in the cell than just the answer?  Right now the Google Query is =QUERY('Master Volunteer List - DO NOT EDIT'!A2:Z, "Select * Where B = 'Albemarle County'")

    I can set it up to be one question, and edit all the responses we have received so far, but am hesitant to do so until I know it will work.


    Thanks for the help

  • Profile Image
    Jim_R
    Answered on April 03, 2019 at 03:31 PM

    If your formula resides in a separate sheet/tab, then it shouldn't cause your current integration to stop working. What most likely caused the integration to break were the fields you added to your form. We generally advise our users to not make any changes to both the form and the integrated sheet once the connection is established.

    When I went to add more training date questions, google sheets did not pull in the new columns. I tried un-connecting and reconnecting, hoping it would send the new columns, but it just created a brand new sheet with the same name.

    That's correct. Redoing the integration will always create a newly integrated sheet. If you still have plans to make changes to your form, I recommend you do it now before you redo the integration. The goal is to not make any changes on both sides (form and sheet) once you're done with the integration. If it's imperative to make changes in the future, you may need to redo the integration in case it breaks.

    If I set it up for one question for the training dates, and multiple Answers, will the Query formula in Google work if there is more data in the cell than just the answer?  Right now the Google Query is =QUERY('Master Volunteer List - DO NOT EDIT'!A2:Z, "Select * Where B = 'Albemarle County'").

    I think it should still work with minor modification to your formula. Instead of using =, try using the "contains" keyword:

    =QUERY('Master Volunteer List - DO NOT EDIT'!A2:Z, "Select * Where B contains 'Albemarle County'")

    https://developers.google.com/chart/interactive/docs/querylanguage#where