Scheduled template issue

[Eric Sawyer]

Hello - We have 2 scheduled (check/send every hour) templates on a google sheet which has stopped working. A different email is supposed to be sent depending upon a text match in a column. AutoCrat had been working smoothly and a stopped a couple weeks ago. We're only signed into one Google account in the browser and recently (today) cleared the cache. We cannot use form submission trigger because we need to add the Edit URL via a script and include that in the email. The form submission happens too quickly. Thanks for any ideas!

[Joseph Schmidt]

Does formmule work?

Joe Schmidt

On Thu, Oct 30, 2025, 12:34 AM Eric Sawyer <secr...@mainesearchandrescue.org> wrote:

Hello - We have 2 scheduled (check/send every hour) templates on a google sheet which has stopped working. A different email is supposed to be sent depending upon a text match in a column. AutoCrat had been working smoothly and a stopped a couple weeks ago. We're only signed into one Google account in the browser and recently (today) cleared the cache. We cannot use form submission trigger because we need to add the Edit URL via a script and include that in the email. The form submission happens too quickly. Thanks for any ideas!

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/d6d83a50-6714-491c-859a-c64dcf708c51n%40googlegroups.com.

[Joseph Schmidt]

I have given this some more thought.  I have a script that submits a dummy form.  That form can be used to trigger Autocrat.

The way it could operate is.

• Your script could be sent to run on edit or on change. However, you currently control.
• At the end of your script would be a modified version of my script to send a dummy submission.
• Autocreat could be set to run on a form trigger.  The merge job doesn't have to be on the response sheet.

You could program in any delay before you send the form.

See Submit a form from a script

Listen to Notebooklm podcast

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Thu, Oct 30, 2025 at 12:34 AM Eric Sawyer <secr...@mainesearchandrescue.org> wrote:

Hello - We have 2 scheduled (check/send every hour) templates on a google sheet which has stopped working. A different email is supposed to be sent depending upon a text match in a column. AutoCrat had been working smoothly and a stopped a couple weeks ago. We're only signed into one Google account in the browser and recently (today) cleared the cache. We cannot use form submission trigger because we need to add the Edit URL via a script and include that in the email. The form submission happens too quickly. Thanks for any ideas!

--