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

    Google Spreadsheet: apostrophe is added in the beginning of the edit link after editing form

    Asked by prav9884 on March 26, 2016 at 06:49 AM

    Hi Team,


    Form url: https://form.jotform.com/53255690730254


    I have integrated my form with google spreadsheet. When I click on edit link in google spreadsheet and resubmit the form the hyperlink in edit link column of google spreadsheet is lost.

    I think an apostrophe is getting added after resubmitting the form at the start of the formula.


    An example 

    Before editing formula in edit link is =HYPERLINK("https://jotform.ca/form.php?formID=53255690730254&sid=333368073981847307&mode=edit";"Edit Submission")

    After editing formula in edit link is  '=HYPERLINK("https://jotform.ca/form.php?formID=53255690730254&sid=333368073981847307&mode=edit";"Edit Submission")


    Can you please check this bug and fix it at the earliest.



    Praveen N

    Page URL:

  • Profile Image

    Answered by victor on March 26, 2016 at 09:57 AM

    Sorry for the inconvenience. I after creating a small test form, I also was able to reproduce the error. 

    At first the link works perfectly, but when you press the edit link and re-submit the form with new data the link is broken. I also noticed that an apostrophe was added at the beginning of the formula:

    I have created a new ticket for our back end team. As soon as we have any update, we will be updating you through this thread.