What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by mxpi 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
    JotForm Support

    Answered by Welvin 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
    JotForm Support

    Answered by Welvin 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.