For Submission Date no longer populating in Google Sheets

  • elijmartinez
    Asked on June 2, 2017 at 11:52 AM

    Hello, 

    For some reason, submissions on form 70895562680164 after June 1, 12:33 PM PST, are no longer pushing the submission date to Google Sheets, and edits/re-submissions are deleting the date from Sheets. 

    Please help. 

     

    Eli

  • liyam
    Replied on June 2, 2017 at 12:20 PM

    Hello Eli,

    I just manually resynced your form's data to Google Spreadsheets. Can you check to see if the missing submissions are now there?

    If you have made changes on your form, it's highly possible to be the cause of your integration to fail due to inconsistencies on field information between the form and the columns in the spreadsheet. With this, I would suggest to reintegrate the form to start fresh.

    In any case, please observe your submissions if you the next ones still fail.

    Thanks.

  • elijmartinez
    Replied on June 2, 2017 at 12:31 PM

    Hello Liyam,

    Missing submissions are not the issue.

    No changes to the form have been made. 

    The problem is the Submission Date data. The date of the submission is no longer populating in Sheets. Also, if I edit and re-submit an older entry, the submission date is removed when the data is synced. 

  • elijmartinez
    Replied on June 2, 2017 at 12:39 PM

    Will you please resync my form data again?

  • liyam
    Replied on June 2, 2017 at 12:57 PM

    My apologies for misreading your message. Anyhow, I have tried syncing again the data to your Spreadsheet Integration. Please let us know if the submissions date are still missing.

    If you don't mind me asking, is it necessary to keep the current link to your spreadsheet? If not, I would like to recommend to try reintegrating your form instead for a possible quick fix of the issue.

    Will look forward to your response.

    Thanks.

     

  • elijmartinez
    Replied on June 2, 2017 at 3:52 PM

    Hello,

    Unfortunately, the submission dates for yesterday's entries are still missing. 

    Also, today's submissions aren't populating at all. The integration broke somehow. 

     

    How do I reintegrate the same Sheet? I don't want to lose the work I've already done? 

  • David JotForm Support Manager
    Replied on June 2, 2017 at 6:00 PM

    You just need to remove the integration, and make a new integration. All the previous data will be automatically updated in the new Spreadsheet.

  • elijmartinez
    Replied on June 2, 2017 at 8:23 PM

    Ok. I've done that, but for some reason the form data I submitted after the new integration isn't populating.

    I gave the new Sheet a different file name but placed it in the folder previously created. Could that be causing the issue?   

  • liyam
    Replied on June 3, 2017 at 2:55 AM

    Hello,

    Changing the name of the sheet should not affect the population of it. The columns of its cells may affect the integration though. So I find this behavior on your spreadsheet a bit strange of it was just the name of the spreadsheet and its location was altered.

    Can you provide us a sharing/view access to your spreadsheet so for us to be able to view its contents? 

    Thanks.