Jump to content
  • 0

Scheduled Task Email Not Sending


Question

Hi - I'm trying to send an email once a day to students that have registered in an upcoming class to let them know how to join the class. I created a task to retrieve the correct records and scheduled the task to execute each day at midnight. It should send emails to students in classes that begin in four days. I used this article as an example (Example 2: Event Reminder): https://howto.caspio.com/tasks/

I've attached my logic. The task runs successfully but no email is ever sent. If I change the Where Criteria to have the Course Start Date = the literal date I'm trying to target, and run the task, the email sends. But with the logic to test for four days out, the task runs but no emails are sent. Any thoughts are appreciated.

Screenshot 2021-03-29 093523.png

Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 1

Hi @JayDub,

Have you tried swapping the timestamp and CourseStartDate fields? "WHERE CourseStartDate EQUALS TimeStamp - 4 days'

You could also try the 'difference in days' block under Date. 'WHERE difference in days between CourseStartDate and Timestamp equals -4'

I have not been able to test these, but thought I would try to help.

Link to post
Share on other sites
  • 1

Hello @JayDub,

The previous comment by kpcollier is absolutely correct. The email may not be sent because the WHERE condition is not met.

I usually like to use the 'difference in days' block for this type of task. Basically, if a field with a date is in the future - then the Timestamp should be set in the first place. That said, to select the records with classes that begin in four days, the difference in days should be equal to 4.

Here is the example, just swap the fields to yours:

image.png

Hope this helps!

Link to post
Share on other sites
  • 0

Thanks @kpcollier and @sandy159. I will try the difference in days option and let you know if it works. It's strange to me, though, that the example Caspio uses in their post about tasks, which is illustrating essentially what I'm trying to do, uses the other method, which (unless I'm missing something) does not seem to work!

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...