Time trigger :: extend the time?

283 views
Skip to first unread message

Ross Webb

unread,
Jul 16, 2019, 9:41:16 PM7/16/19
to NV Autocrat Add-on
Hi,

Is there any way to extend the time for a Autocrat trigger beyond 24 hours? I would like to trigger a merge say once a month.

Thanks

Joseph Schmidt

unread,
Jul 16, 2019, 10:51:35 PM7/16/19
to nv-autocr...@googlegroups.com
There is no way to extend the time.  You can add a column and calculate the day that you want the row to run. Put a "yes" or any other text to be used as a filter to Autocrat.

Set a time trigger to run.  Autocrat will run but no rows will be processed until the column has the correct text in the new column you add.

You need to set the processing options for the spreadsheet so that the column is calculated even when the spreadsheet is closed.



--
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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/92d520b0-6243-477a-8108-b6f360500b4e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ross Webb

unread,
Jul 17, 2019, 7:01:15 PM7/17/19
to NV Autocrat Add-on
Thanks for that Joe. You're a master at this, obviously!
Ross


On Wednesday, July 17, 2019 at 12:51:35 PM UTC+10, Joseph Schmidt wrote:
There is no way to extend the time.  You can add a column and calculate the day that you want the row to run. Put a "yes" or any other text to be used as a filter to Autocrat.

Set a time trigger to run.  Autocrat will run but no rows will be processed until the column has the correct text in the new column you add.

You need to set the processing options for the spreadsheet so that the column is calculated even when the spreadsheet is closed.



On Tue, Jul 16, 2019 at 9:41 PM Ross Webb <rnl...@gmail.com> wrote:
Hi,

Is there any way to extend the time for a Autocrat trigger beyond 24 hours? I would like to trigger a merge say once a month.

Thanks

--
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-on+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages