Reminders on time

Wonder how to send the reminder on a specified time? Or sending it 20 minutes after the record was created? Well, it’s easy…

First, some general information:

TeamDesk supports Date, Time, and Timestamp columns. Timestamp is the combination of the date and time.

You may construct the timestamp from the date and time using ToTimestamp(date, time) function.

The reminder can be set up to use either date or timestamp column. The date column in reminders behaves exactly the same as timestamp constructed from the date and the midnight time (0:00 a.m.). It is triggered on the date and time specified in the column’s value (or midnight for the dates). You may optionally specify the offset to send the reminders some days after or before.

The problem is that we can not specify the offset in the units other than days. The solution would be to calculate the moment in time to send the reminder. The calculation can be done via Formula – Timestamp columns. Let’s name it Reminder Time. The reminder should use this column and specify 0 as the offset.

Now, let’s put it all together:

Task 1: Sending the reminder on specified date at 8:00am

Populate the Reminder Time column with the following formula:

ToTimestamp([Alert Date], Time(8, 0, 0))

Task 2: Sending the reminder 20 minutes after the record is created

Use following formula for the Reminder Time column:

[Date Created] + Minutes(20)

That’s all folks 🙂

Tweet about this on TwitterShare on Facebook0Share on Google+0