Setting automatic update request based on field data

Christopher Yellen · 01/16/18

It looks like the automated update requests need data in the row (or in a column) to change before an update can be requested.

I want to request updates on a given schedule - without having to manually request the update. Here's the situation - we have trainers in the field who create a new class using a form. The classes last several weeks, but we want a status update at the start of the class and at the end of every week.

I have created update request rules that should fire when each of the calculated dates are equal to today - but it looks like if nothing else on that row changes, the request doesn't actually get triggered.

Anyone have other ideas?

Eileen OH · 01/17/18

I have a similar issue - I want to know when something hasn't been updated. So if it has been 5 days since an update request was sent, and the item still hasn't been updated, I want it to send another update request.

Shesha_K · 07/10/18

I have also been looking for a simple solution for sending automated updates without a cell being "triggered". It seems as though there should be an option to simply have a request sent on a daily/weekly/bi-weekly etc. schedule..

J. Craig Williams · 08/02/18

What we could really use is the Reminder functionality for the other Alert types. I have my suspicions on why that has not been done (and maybe won't be).

Since we can't trigger without a change to the row, the obvious solution is to change the row.

For recurring tasks, I update the sheet nightly (after midnight) and that causes other things on the Sheet to be updated.

For the Update Request rule, it becomes

Where (Date column) is today.

It is a little more complicated than that, but does not take long to set it up if I've never seen the Sheet before.

Craig

Paul Newcome · 03/28/19

An update to this thread... You can now use a Date type column to trigger update requests. So if you want to send an update request 5 days after the submitted date, you could add a Reminder Column and enter the formula

=Submitted + 5

You would then set the Update Request to send on the date in the Reminder Column (and include in additional conditions for complete vs incomplete/checked vs unchecked/etc).

Setting automatic update request based on field data

Comments

Categories