Submission ID in google spreadsheet appear as ERROR value only

  • Profile Image
    aleaguilar1512
    Asked on April 04, 2017 at 04:57 PM

    Here's the link so you can check. The previous one was limited to my organization, sorry about that.

    https://docs.google.com/spreadsheets/d/1FgeHA_yfpFX4ZUZFS8-qnAkMF1Nj3CcBVZQwVlcB6KU/edit?usp=sharing

     

    As a precaution, I disabled the clear on submit. I'll retry, but I'd like you to take a look at the spreadsheet. There's a column that shows ERROR on every row.

     

  • Profile Image
    Kiran
    Answered on April 04, 2017 at 10:28 PM

    It seems that there is an issue with the integration or an update with the integration might have caused this. Could you try removing the existing integration on the form and reintegrate again to see if the Submission ID is displaying correctly in the spreadsheet? 

    Please get back to us if the issue still persists. We will be happy to assist you further. 

  • Profile Image
    aleaguilar1512
    Answered on April 05, 2017 at 10:18 AM

    Hey Kiran,

    I redid the integration and it keeps showing error. Now, there's another issue with the same integration, it freezes and doesn't update new submissions. It stopped yesterday at 723 subs and I had 1023+ when I rebuilt the integration today it worked, but it keeps freezing.

    any thoughts?

  • Profile Image
    Kiran
    Answered on April 05, 2017 at 11:34 AM

    I have cloned your JotForm and tried integrating the spreadsheet. I see that the Submission IDs are displayed normally on the integrated spreadsheet at my end. Could you confirm that you are not making any changes to integrated spreadsheet? 

    Also, I have pushed the missing submissions if any to the spreadsheet. Please check and let us know if the issue still persists. We will be happy to assist you further.