Integration not copying dates to google sheet

  • AgilityAssoc.Canada
    Asked on March 23, 2019 at 10:07 AM

    Hi,

    RE: CA Assignments Report 81646514559970

    Today I noticed the last two submissions did not record the submission date to the integrated G-Sheet. Because this didn't occur the G-Sheets that feed off of it did not update because they rely on that cell having data. Can you help me find the cause of this problem please?

    1553350005JF CAReport missingDates Screenshot 10

    They are showing on submission sheet.

    1553350219JF CAReport missingDates 2 Screenshot 21

    Thank you,
    Robert

  • roneet
    Replied on March 23, 2019 at 12:41 PM

    Have you edited the Form or the Google Sheet?

    The sheets usually stop receiving data if the Form/Sheet is edited or Google updates their Authentication token.

    I have manually pushed the data to your sheet. Could you please check now.

    Thanks.

  • AgilityAssoc.Canada
    Replied on March 23, 2019 at 2:08 PM

    No edits made to anything in a while. Now I see more recent ones are showing dates. Here is a copy of one of the sheets that uses the data.

    1553364432JF CAReport missingDates 3 Screenshot 10

    As you can see the same two are missing dates.

    Robert

  • AgilityAssoc.Canada
    Replied on March 23, 2019 at 2:23 PM

    Also this sheets is missing all the data for those two because the dates are empty...

    1553365375JF CAReport missingDates 4 Screenshot 10

    Note that it jumps from 1274 to 1277

    Robert

  • AgilityAssoc.Canada
    Replied on March 23, 2019 at 2:38 PM

    I have decided to create an new integration. 

    Robert

  • AgilityAssoc.Canada
    Replied on March 23, 2019 at 2:58 PM

    Problem resolved with new integration, case closed.

    Many thanks 

    Regards, Robert

  • jonathan
    Replied on March 23, 2019 at 6:03 PM

    Hi Robert,

    Thank you for taking the time updating us on the status and letting us know all is good now.

    Contact us anytime should you require assistance again.


    Best


  • AgilityAssoc.Canada
    Replied on March 24, 2019 at 8:43 AM
    You are most welcome.

    Robert B Cooper
    AAC Forms Manager
    Agility Association of Canada


    ...