Adding data to an integrated spreadsheet

  • llofland
    Asked on February 23, 2018 at 1:26 PM

    Can I amend posted data to an existing row in an integrated spreadsheet.  I have integrated a Jotform:  Form I would like to add columns to the imported range spreadsheet.  Is this possible to add these column at the end (L, M, N) as shown in the attached screen shot.


    I am trying to reduce the need to "Edit Submission" by others

    Jotform Thread 1395125 Screenshot
  • Kevin Support Team Lead
    Replied on February 23, 2018 at 2:23 PM

    We do recommend you avoid making changes on the integrated sheet with your form, that would break up the integration and submissions may stop sending to the document. 

    Instead, you may import the sheet data to another spreadsheet using the importrange function, this way you can edit the other sheet and avoid breaking the integration. 

    This link will help you importing data from one sheet to another: https://support.google.com/docs/answer/3093340?hl=en 

    I hope this helps.