Some Submission Edits not updating in Google Sheet

  • brandxtshirts
    Asked on August 1, 2017 at 5:04 PM

    2 Submissions, despite being edited, do not update in the Google Sheet:

    https://docs.google.com/a/alphagraphics.com/spreadsheets/d/1OW1oChYGdUEFZrFOi-X3OsunlShQ6cV9_v348XsPAlg/edit?usp=sharing

     

    Line 10 & Line 19

  • jonathan
    Replied on August 1, 2017 at 7:45 PM

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

    Some Submission Edits not updating in Google Sheet Image 1 Screenshot 20

     

    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.

     

  • brandxtshirts
    Replied on August 4, 2017 at 4: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]
    ...
  • jonathan
    Replied on August 4, 2017 at 5: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.

     

  • brandxtshirts
    Replied on August 7, 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]
    ...
  • David JotForm Support
    Replied on August 7, 2017 at 1: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