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

  • Profile Image
    ramblenos
    Asked 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.

  • Profile Image
    ashwin_d
    Answered on March 17, 2017 at 12:18 PM

    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!

     

  • Profile Image
    ramblenos
    Answered on March 17, 2017 at 12:46 PM

    Now the same problem occurs to me in all my forms.

  • Profile Image
    Kiran
    Answered on March 17, 2017 at 03:09 PM

    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. 

  • Profile Image
    mediatask
    Answered on March 18, 2017 at 05:03 AM

    Hi Guys,

    We're experiencing the same issue.

    Some ID's are OK, while others are not, see below:

    EDIT:

    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!

  • Profile Image
    Jan
    Answered on March 18, 2017 at 05:48 PM

    @mediatask

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

    Thank you.

  • Profile Image
    ramblenos
    Answered on March 19, 2017 at 07:41 PM
    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.

     

     
  • Profile Image
    ashwin_d
    Answered on March 19, 2017 at 10:44 PM

    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!

  • Profile Image
    ramblenos
    Answered on March 20, 2017 at 02:58 AM

    First image, three unedited forms.

     

    Second image, edited test3 form, duplicates and kills the first line by replacing the Form1 form.

  • Profile Image
    Charlie
    Answered on March 20, 2017 at 04:44 AM

    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. 

  • Profile Image
    mediatask
    Answered on March 22, 2017 at 01:24 PM

    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!

  • Profile Image
    Jan
    Answered on March 22, 2017 at 06:01 PM

    @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!

  • Profile Image
    ramblenos
    Answered on March 23, 2017 at 10:57 AM

    @mediatask Thanks for sharing, I'll try, but I hope I have an official solution.

  • Profile Image
    Denis
    Answered on April 11, 2017 at 05:54 AM

    Hello, 

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

     

    Regards