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 Integration: Edit Link in Google Spreadsheets breaks showing Hyperlink Formula if a Submitted Submission is Edited

    Asked by KAORUBRADLEY on November 10, 2015 at 08:48 AM
    One small issue is that the Edit link changes to the hyperlink formula after I submit the change. I can still copy and paste the link in the hyperlink to edit the form so this is not critical to me.
    hyperlink formula broken edit link edited submission google spreadsheets
  • Profile Image
    JotForm Support

    Answered by KadeJM on November 10, 2015 at 09:16 AM

    Thank you for reporting this issue to us about the Edit Link becoming broken in the Google Spreadsheet after a related submission has been Edited.

    There does appear to be an issue with this as I am currently able to replicate the same issue. 

    I think this is either due to the comma being added either alongside the submission data when it is sent to the google spreadsheet. Or if not then it may be getting misread when generated after the adding in the edited data which is then broken when it is then updated in the spreadsheet.

    I have sent a bug report about this issue to our developers so we can get this problem fixed.

     

    First Submission of Data:

     

    After Submission is Edited then Resubmitted:

     

    After investigating and comparing the Hyperlinked Formulas between the working and non-working Edit Links I found this issue is occurring due to an Apostrophe that is applied as a prefix into the updated submission.

     

    If the apostrophe is removed then the default Hyperlink Formula works as expected converting the Edit Submission back to a Link.

     

  • Profile Image

    Answered by KAORUBRADLEY on November 10, 2015 at 09:34 AM

    Thank you very much for your response. I will remove the apostrophe for the time being.

  • Profile Image

    Answered by bfuentes on November 10, 2015 at 09:36 AM

    Is there an issue with google sheet integration? One of my forms has 8000 submissions and I removed the integration because I want to create a new Gsheet for it. Unfortunately, Integration fails - and it links me to an empty page in Google forms

  • Profile Image
    JotForm Support

    Answered by Charlie on November 10, 2015 at 11:55 AM

    @bfuentes

    Please refer to this thread link: http://www.jotform.com/answers/701555. I have responded to your concern there. Thank you for understanding.

  • Profile Image

    Answered by stevedellar on February 21, 2016 at 10:19 AM

    Any update on this as I am also having this problem

    you cannot even remove using =RIGHT(A1,LEN(A1)-1)

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 21, 2016 at 01:24 PM

    @stevedellar, unfortunately, we have not receive any updates on this matter yet. Our developers will update via this thread when there is a resolution.

  • Profile Image

    Answered by SolutionsUDS on April 08, 2016 at 08:10 PM

    So, any development on this issue? 

  • Profile Image
    JotForm Support

    Answered by liyam on April 09, 2016 at 01:26 AM

    Hello SolutionsUDS,

    Unfortunately there is still no word from the developer assigned to this issue as he might still be attending on resolving another issue. However, as soon as we have progress on this, we'll keep you posted.

    Thanks for your patience and we apologize for this inconvenience.