- KadeJMAnswered 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.
- KAORUBRADLEYAnswered on November 10, 2015 at 09:34 AM
Thank you very much for your response. I will remove the apostrophe for the time being.
- bfuentesAnswered 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
- CharlieAnswered on November 10, 2015 at 11:55 AM
Please refer to this thread link: http://www.jotform.com/answers/701555. I have responded to your concern there. Thank you for understanding.
- stevedellarAnswered 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)
- JotForm SupportBDAVIDAnswered 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.
- SolutionsUDSAnswered on April 08, 2016 at 08:10 PM
So, any development on this issue?
- JotForm SupportliyamAnswered on April 09, 2016 at 01:26 AM
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.