How Do I Remove "Edit Submission" link from Google Integration

  • Profile Image
    Asked on March 22, 2017 at 12:45 AM


    I'd like to have a customer view the form submissions from a Google spreadsheet. But I don't want them to see the edit submission link which is included. I've tried deleting that column but each new submission adds a new link. 


  • Profile Image
    Answered on March 22, 2017 at 07:37 AM

    I'm sorry, but that is not possible. A workaround would be to create a report through one of our reporting features: 


    If you really want to keep the google spreadsheet, a workaround would be to add a script that would auto clear/delete the column values when new data is added. I am trying to get this for you. I'll let you know. 

  • Profile Image
    Answered on March 22, 2017 at 07:48 AM

    2. Copy this script:

    function myFunction() {

         // Spreadsheet ID

    var ss = SpreadsheetApp.openById("1ZC0X6mGiO8ECX0bglmYMuVMJV2DJTZyeJuw6cvTsJyg");

     var sheet = ss.getSheets()[0];

       // Columns start at "1" - this will delete the first column



    Replace the spreadsheet ID: 1ZC0X6mGiO8ECX0bglmYMuVMJV2DJTZyeJuw6cvTsJyg

    Replace the column number: If your Edit Link is in the column H, put 8 in this section (replacing 17). 

    2. Go to Script Editor in your spreadsheet file. Tools > Script Editor:


    3. Paste the script in the editor and save.


    4. Create a trigger to auto run the script on every change made in the spreadsheet. Edit > All Triggers:

    5. Configure the trigger like this:


    6. Save and run and that's it!


    Let us know if you need further assistance.