Some Submission Edits not updating in Google Sheet

  • Profile Image
    brandxtshirts
    Asked on August 01, 2017 at 05:04 PM
  • Profile Image
    jonathan
    Answered on August 01, 2017 at 07:45 PM

    I checked your form and I found issue with the submission spreadsheet.

     

    It seems the integration was broken due to edition done on the form.

    I suggest you redo the google spreadsheet integration on your form at this time.

    See if this process resolve the issue.

    Let us know if issue persist.

     

  • Profile Image
    brandxtshirts
    Answered on August 04, 2017 at 04:43 PM
    Thanks for the info. What does "edition done on the form" mean?
    *CHARLES GOFFNETT * *|* Director, Brand X
    D: 480.398.2710 C: 480.203.2154 F: 480.398.2711
    [image: Brand X Custom T-Shirts]
    [image: New Deals]
    [image: Facebook Icon] [image:
    Instagram Icon] [image: LinkedIn
    Icon] [image:
    Google + Icon] [image:
    Twitter Icon]
    ...
  • Profile Image
    jonathan
    Answered on August 04, 2017 at 05:43 PM

    I apologize for the confusion. I was referring to the Sheet not the form.

    I meant the Sheet had been edited or modified in the Google spreadsheet used in the form integration. 

    Try redoing the integration by removing it and then add it again.

    Let us know if issue still persist even after doing this.

     

  • Profile Image
    brandxtshirts
    Answered on August 07, 2017 at 11:43 AM
    So if we want to re-arrange columns in the resulting Google Sheet, what is
    the best practice to do this? Can it be done without breaking the
    integration?
    *CHARLES GOFFNETT * *|* Director, Brand X
    D: 480.398.2710 C: 480.203.2154 F: 480.398.2711
    [image: Brand X Custom T-Shirts]
    [image: New Deals]
    [image: Facebook Icon] [image:
    Instagram Icon] [image: LinkedIn
    Icon] [image:
    Google + Icon] [image:
    Twitter Icon]
    ...
  • Profile Image
    david
    Answered on August 07, 2017 at 01:45 PM

    The integrated sheet should not be edited.  Rearranging the columns will indeed break the integration.  If you would like a sheet that can be edited, I would recommend creating a new sheet and using the import range function to import the data from the integrated sheet:

    https://support.google.com/docs/answer/3093340?hl=en