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

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

    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 

  • Profile Image
    Welvin
    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:

    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. 

  • Profile Image
    Welvin
    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

     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.