New integrated Google Spreadsheet displays "=TEXT()" in submission ID column value.

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.

Hello ramblenos,

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.

Thank you!

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. 

@mediatask

I created a separate thread for you. Please wait for our reply on this thread: https://www.jotform.com/answers/1095378.

Thank you.

Hello ramblenos,

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.

Thank you!

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. 

Hi ramblenos,

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:

=TEXT("365548609181377693","0")

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!

@mediatask

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.

Hello, 

Problem is fixed now. But you should re-integrate to fix previous submissions. Please let us know if the issue still persists. 

Regards