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

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

    Asked by sudsport on September 25, 2015 at 05:18 AM

    Hi,

    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:

    Correct:

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

    Incorrect:

    =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,

    Georges

    edit link Google Spreadsheet hyperlink syntax
  • Profile Image
    JotForm Support

    Answered by Welvin 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:

    https://docs.google.com/a/jotform.com/spreadsheets/d/1IqXnQF1qUBIVI0ZwgY2tw90aY2fMqeYx3pAp_zaOCXI/edit?usp=sharing

    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.

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin 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.

    Thanks

  • Profile Image

    Answered by sudsport 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.

    https://drive.google.com/open?id=1UzLyE9CeDTz-W9katfMcjVZFu7iy_M3-siRFHek3meI

    The corresponding form is:

    http://form.jotformpro.com/form/52426954348968

    Regards,
    Georges

  • Profile Image
    JotForm Support

    Answered by Welvin 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). 

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on October 01, 2015 at 09:26 PM

    Hello,

    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