JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Edit Link syntax in Google Spreadsheet will give you an error when the spreadsheet locale is set to FranceAsked by sudsport 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=317259057048363142&mode=edit","Edit Submission")Why deleted submissions still appear as active in the google spreadsheet, it should be tagged as deleted.
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.
Your question about the deleted submission has been moved and will be answered here: http://www.jotform.com/answers/670171.
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:
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).
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.