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.
New integrated Google Spreadsheet displays "=TEXT()" in submission ID column value.Asked by ramblenos on March 17, 2017 at 04:50 AM
Hola, al exportar la información a Google sheet el campo ID sale ERROR, lo convierte en =TEXT("365548609181377693","0").
Necesito que solo aparezca 365548609181377693.
I did clone your form and integrated it to my google spreadsheet, I am able to replicate the issue you are having. I am not sure what is causing this issue but the other already integrated google spreadsheet does not display the =TEXT() in the submission ID column.
The issue seems to happen only with google spreadsheet which is newly integrated. I am reporting it to our backend team. We will get back to you as soon as we have any update from them.
Now the same problem occurs to me in all my forms.
We are sorry for the trouble caused. I see that the issue is already forwarded to our backend team by our colleague. Once the issue is fixed, you'll be updated here.
Thank you for your patience and understanding.
We're experiencing the same issue.
Some ID's are OK, while others are not, see below:
I made a test just now and made changes to the first form in the above list (ID 35071179...) and saved them.
Here's what happened:
So it looks as though only the newly created/changed form get the incorrect sumbission ID's
Hope this helps you fix this issue quickly!
I created a separate thread for you. Please wait for our reply on this thread: https://www.jotform.com/answers/1095378.
Another error detected, every time I update a form in google sheet creates a line at first duplicate and does not update the first one.
I am not sure if I have understood your issue correctly. Please explain your issue a bit more in detail and we will surely help you. You may also like to share a screenshot of the problem in google spreadsheet as well. The following guide should help you how to upload image in forum post: http://www.jotform.com/answers/277033
We will wait for your response.
First image, three unedited forms.
Second image, edited test3 form, duplicates and kills the first line by replacing the Form1 form.
Apologies for the inconvenience.
Unfortunately, I can't seem to replicate the problem, I presume the issue you have experienced is related to the formula or error showing under the "Submission ID" column, wherein the submission ID is one of the major requirement for the edit link.
The ticket is already assigned to one of our developer, unfortunately, we have not yet received any news or updates about this resolution. We will update you one we hear anything. Apologies.
I had the same problem and was able to find a workaround solution.
Try the following:
1. Go to File>Spreadsheet settings (Archivo>Configuración de la hoja de cálculo) and swith the locale to United States and the language to English:
2. Go back to Jotform, remove the Google Spreadsheets integration and activate it back.
This should solve the problem.
It works because the culprit was the mishandling of the comma in the formula:
Apparently it is not a universally accepted syntax throughout different locale settings in Google Spreadsheets. If it were a semicolon (and I think JotForm previously exported it as such) the problem would not exist.
I don't know why, but it seems this solution also fixed the overwriting issue.
Que tengas suerte!
Thank you for sharing that solution or workaround. The information you provided is very helpful.
If you need any help though, please don't hesitate to contact us. Have a great one!
@mediatask Thanks for sharing, I'll try, but I hope I have an official solution.
Problem is fixed now. But you should re-integrate to fix previous submissions. Please let us know if the issue still persists.