-
AgilityAssoc.CanadaAsked 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?
They are showing on submission sheet.
Thank you,
Robert -
roneetReplied 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.CanadaReplied 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.
As you can see the same two are missing dates.
Robert
-
AgilityAssoc.CanadaReplied on March 23, 2019 at 2:23 PM
Also this sheets is missing all the data for those two because the dates are empty...
Note that it jumps from 1274 to 1277
Robert
-
AgilityAssoc.CanadaReplied on March 23, 2019 at 2:38 PM
I have decided to create an new integration.
Robert
-
AgilityAssoc.CanadaReplied on March 23, 2019 at 2:58 PM
Problem resolved with new integration, case closed.
Many thanks
Regards, Robert
-
jonathanReplied 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.CanadaReplied on March 24, 2019 at 8:43 AMYou are most welcome.
Robert B Cooper
AAC Forms Manager
Agility Association of Canada
...