Copydown and Autocrat not working properly today?

53 views
Skip to first unread message

Joan Sw

unread,
Oct 15, 2024, 2:26:00 PM10/15/24
to NV Copy Down Add-on
Anyone else seeing sporadic issues with CopyDown or Autocrat?

1. The copyDown Add-on failed to execute on row 671 of the form response sheet 
in <a 
href=">Sheet name...</a>. <p>The merged doc for this row 
has not been created.  If you want to fix this, head over to the 
spreadsheet and copy your formulas into this row before running your 
autoCrat merge manually.<p>You you should probably also unset and re-set 
your copyDown settings on the form destination sheet to ensure the trigger 
is set properly.

2. Autocrat failed oddly when only scheduled for form submit that did not even occur recently.

The Google Sheets add-on AutoCrat is set to run automatically at a specific time interval, when a form is submitted, or both.

The add-on recently ran but was not able to complete successfully for the following reason:

Too many simultaneous invocations: Spreadsheets

Debra McCaffrey

unread,
Oct 17, 2024, 11:40:01 AM10/17/24
to NV Copy Down Add-on
Our district is also experiencing issues. My Auotcat job uses the copydown field as the condition to run. It seems like Copydown is delayed and Auocrat is timing out before the Copydown data is pasted. 

Ted Parker

unread,
Oct 17, 2024, 4:44:37 PM10/17/24
to NV Copy Down Add-on
I just installed Copy Down on my current account for the first time today, and it's just giving me a spinning wheel when I turn it on. 

Joseph Schmidt

unread,
Oct 18, 2024, 11:38:45 PM10/18/24
to nv-copy-d...@googlegroups.com
I use an Arrayformula instead of CopyDown.  I have a video in my YouTube.

Autocrat is supposed to wait for CopyDown to complete.  I don't know why it is failing.



--
You received this message because you are subscribed to the Google Groups "NV Copy Down Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-copy-down-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/dcd94638-c7db-4a4b-ad3f-cc12b8a623f9n%40googlegroups.com.

Joseph Schmidt

unread,
Oct 18, 2024, 11:39:27 PM10/18/24
to nv-copy-d...@googlegroups.com
Try submitting a response.
--
You received this message because you are subscribed to the Google Groups "NV Copy Down Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-copy-down-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/ed8287a7-e0a5-4b15-b112-ffabff5251bcn%40googlegroups.com.

Joan Sw

unread,
Oct 21, 2024, 9:22:12 AM10/21/24
to NV Copy Down Add-on
Thanks Joe.
I can't always used ArrayFormulas.  But I agree, I could add more of those in.
Depends on the type of formula you are trying to use.

Either way, when something works 99% of the time, and then suddenly doesn't work, it seems to me a problem with the product itself.

Although if CopyDown and AutoCrat are dependent upon Google Script & Google changes something I suspect we are all at the mercy of Google?

Do we know if anyone has made updates to Google Scripting, CopyDown or Autocrat in the last week?  

Joseph Schmidt

unread,
Oct 21, 2024, 9:44:59 AM10/21/24
to nv-copy-d...@googlegroups.com
Joan,

When something fails and you are the only one reporting the issue, it was a one-time hiccup in Google or something with the user data.

With the BY ROW function, you can use arrayformula more often.  The copy and paste, and the copy formats are the two things that require CopyDown.

There have been no changes that I'm aware of.

Did you try coping the formulas the same as CopyDown would have done?  Then reviewed the CopyDown settings to be sure it is still running.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/f6cedf7c-7d55-4acd-852a-e269af286f01n%40googlegroups.com.

Ted Parker

unread,
Oct 21, 2024, 11:19:32 AM10/21/24
to nv-copy-d...@googlegroups.com
Joan’s not the only one! I still can’t get CopyDown to work. I’m an experienced user but installed it on my present account for the first time on Friday. 

Ted


Ted Parker (he, him, his)
Head of Upper School
Ranney School
235 Hope Road
Tinton Falls, NJ  07724
(732) 542-4777, ext. 5106


You received this message because you are subscribed to a topic in the Google Groups "NV Copy Down Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-copy-down-add-on/sH6VFf_-8Ow/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-copy-down-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/CAPWPTOT5xKFSMY3TE%2BjCFfr5%3DFrASu5JdK1iUJ4coDajVi%3D9yQ%40mail.gmail.com.

Joseph Schmidt

unread,
Oct 21, 2024, 11:41:47 AM10/21/24
to nv-copy-d...@googlegroups.com
Can you tell us what failed?

Response sheet not found?  Didn't locate the formulas?  Didn't copy the formulas to new rows.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/CAGL2o2r5p6pBLE7X2vePeo2ne%2B%3DNrqghYqs10B_JdhdBS5M7Gw%40mail.gmail.com.

Ted Parker

unread,
Oct 21, 2024, 6:35:58 PM10/21/24
to nv-copy-d...@googlegroups.com
It just never stops spinning when I toggle the switch to on. 

Ted


Ted Parker (he, him, his)
Head of Upper School
Ranney School
235 Hope Road
Tinton Falls, NJ  07724
(732) 542-4777, ext. 5106

Joseph Schmidt

unread,
Oct 21, 2024, 9:01:46 PM10/21/24
to nv-copy-d...@googlegroups.com
Try submitting one response.  It may be having trouble locating the response sheet.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/CAGL2o2pwqM0qScSz0AuuO-%3D-hOahB%2BMAzGcC60-%3D_dzJ9puJJQ%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages