Adding data to an integrated spreadsheet

  • Profile Image
    llofland
    Asked on February 23, 2018 at 01: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

  • Profile Image
    Kevin_G
    Answered on February 23, 2018 at 02: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.