Google Spreadsheet: After editing a date on form submission still shows old entry

  • Profile Image
    AgilityAssoc.Canada
    Asked on November 22, 2017 at 11:17 AM

    On form 52745887899988, I edited 3826666043917803061, unique # 158,  field Received date. It showed 15/09/2016 so I changed it to 15/09/2017 and submitted it. The email response shows the edit but if I look on the submission table it still has the old date. I checked the inbox and it shows the old date also. If I go back to edit it shows the new date. 

    Very confusing, so what is going on?

    Signed: Befuddled Robert 

    1511367563date-right.png

    1511367784edit-date.png

  • Profile Image
    AgilityAssoc.Canada
    Answered on November 22, 2017 at 11:31 AM

    1511368264MasterRelay.png


    Data showing on the integrated google sheet.

  • Profile Image
    AgilityAssoc.Canada
    Answered on November 22, 2017 at 11:54 AM

    I can go into my integrated master sheet and edit it there but I am very leery. I could make a new integrated master, but I really don't want to. I see that the submission table is now showing the change. Maybe in time it will update the integrated sheet, although I would have thought it would be faster then this.

    Robert

  • Profile Image
    Chriistian
    Answered on November 22, 2017 at 12:48 PM

    I can see the data is now correct in your Submissions page. Can you please try removing the integration and re-integrate to Google Spreadsheet. There might have been a disconnection in the integration and it has to be re-integrated.

    15113728982017-11-23_0146.png

  • Profile Image
    AgilityAssoc.Canada
    Answered on November 22, 2017 at 01:18 PM

    Hi,

    Well I really don't want to do that. It will create a lot of work for me as it is linked to a number of other sheets. If that is the solution then I 'am not prepared right now to do it. I will try something else first. 

    OK, I just changed the date on the master integrated sheet, all my other sheets are corrected.

    I will just wait and see if anything is broken now. I think I will create a slave master sheet to feed all the others. Then If I do have to create a new integration it will be an easy fix.

    This still is not explaining why this occurred in the first place. I have had a lot of problem with dates when integrating with sheets, switching days and month values. There is another thread for that issue.

    if you can offer an explanation for this it would be appreciated.

    Thank you, Robert

  • Profile Image
    aubreybourke
    Answered on November 22, 2017 at 02:11 PM

    I'm not sure why its behaving like that. If you like I can escalate the issue to Level 2 support? They would investigate the issue and post an answer for you.

  • Profile Image
    AgilityAssoc.Canada
    Answered on November 22, 2017 at 02:49 PM

    I'm going to let you folks decide. You have a lot more knowledge on the subject then I.

    I will say thought that I think you should. 

    Regards, Robert

  • Profile Image
    aubreybourke
    Answered on November 22, 2017 at 02:59 PM

    I have escalated this issue to Level 2 support. They will investigate the issue and post a response on this thread.