Google Spreadsheet Integration: Edit Link in Google Spreadsheets breaks showing Hyperlink Formula if a Submitted Submission is Edited

  • Profile Image
    KAORUBRADLEY
    Asked 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.
  • Profile Image
    KadeJM
    Answered 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
    KAORUBRADLEY
    Answered 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
    bfuentes
    Answered 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
    Charlie
    Answered 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
    stevedellar
    Answered 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
    BDAVID
    Answered 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
    SolutionsUDS
    Answered on April 08, 2016 at 08:10 PM

    So, any development on this issue? 

  • Profile Image
    liyam
    Answered 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.