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

Hello,

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. 

Thanks 

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

https://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report

https://www.jotform.com/help/209-How-to-create-an-HTML-Table-Listing-Report 

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. 

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

 sheet.deleteColumn(17);

}

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.