Edit Link syntax in Google Spreadsheet will give you an error when the spreadsheet locale is set to France

  • Profile Image
    Asked on September 25, 2015 at 05:18 AM


    The new feature "Edit Link" is great but is not consistent as the syntax of the hypertext link is sometime faulty as we get a "," (coma) instead of a ";" (semicolon) to separate hypertext target and hypertext text.

    See the 2 following examples:


    =HYPERLINK("http://jotformpro.com/form.php?formID=52426954348968&sid=317179161642674855&mode=edit";"Edit Submission")


    =HYPERLINK("http://jotformpro.com/form.php?formID=52426954348968&sid=317259057048363142&mode=edit","Edit Submission")

    Why deleted submissions still appear as active in the google spreadsheet, it should be tagged as deleted.


    Best Regards,


  • Profile Image
    Answered on September 25, 2015 at 09:10 AM

    Hi Georges,

    Well, my old spreadsheet integration is using a comma and even new one is using the same. Here's an example spreadsheet:


    Here's the test form: http://www.jotformpro.com/form/40585083549967.

    Please share us your Google Spreadsheet file and form URL here so we can check and test it. We can forward this thread to our developers if really needed.


  • Profile Image
    Answered on September 25, 2015 at 09:13 AM

    Your question about the deleted submission has been moved and will be answered here: http://www.jotform.com/answers/670171.


  • Profile Image
    Answered on September 30, 2015 at 05:09 AM

    Hi Welvin,

    Here is the Google Spreadsheet where I have a syntax error on the hyperlink of the "edit link" columns" starting row 9, the first 9 rows are OK. This may be probably the reverse on your side and issue seems related to language differences as in french language CSV file delimiters are ";" semi colons not "," comas.

    On my side the link requires a ";" between hyper-link address and hyper-link text.

    Nevertheless the link is niot consistent all through the file.


    The corresponding form is:



  • Profile Image
    Answered on September 30, 2015 at 09:46 AM

    Hi Georges,

    Thank you for sharing us the file. Indeed, the problem is on the file locale settings. I was able to replicate the problem after changing my spreadsheet locale to France.

    I have now forwarded this thread to our developers. If there are updates, you should know it in this thread.

    For now, you may consider changing the spreadsheet locale to United States (https://support.google.com/docs/answer/58515?hl=en). 


  • Profile Image
    Answered on October 01, 2015 at 09:26 PM


    The issue has now been fixed. Thank you very much for alerting and guiding us.

    Also it would be better to check "Preformat" when integrating to display date & time correctly on spreadsheets with locale. Otherwise they are shown incorrectly, as in above links.

    Kind regards