Google Spreadsheet/Old Layout: Integrated sheet does not update when you add new fields to the form.

  • Profile Image
    TMyersRandstad
    Asked on February 14, 2018 at 11:27 AM

    Hello!

    I have added a new field to my form and I am not seeing the new updates added to my already existing google spreadsheet.  How do I refresh my spreadsheet to include the new submissions.  


    Thanks

  • Profile Image
    Kevin_G
    Answered on February 14, 2018 at 12:51 PM

    I have been testing this and I can see what you're reporting, so far even with new submissions the new field does not appear on the form. 

    The only way to update the sheet is to remove the integration and add it again, I will also report this to our second level so this can be further inspected. 

    We will keep you updated via this thread. 


  • Profile Image
    TMyersRandstad
    Answered on February 14, 2018 at 12:53 PM

    Thanks for such a quick response.

    If I remove the integration and add it again will it still update the current spreadsheet or create a new spreadsheet?

    Several people use this spreadsheet and need to see the old information along with the newly added request.

  • Profile Image
    Kevin_G
    Answered on February 14, 2018 at 01:25 PM

    It will create a new spreadsheet on your Google account, but an alternative would be to link the new created sheet with the existing one you have already shared. 

    The importrange will help you copying the data from one sheet to another: https://support.google.com/docs/answer/3093340?hl=en 

    I hope this helps.