I've got a task list setup as part of a larger DB, that I'm trying to get emails sent from as reminders.
The task list is simple - Creation Date, Task, Assigned To and a Calculation that goes (Current Date - Creation Date) to determine how many days it's been assigned.
There are two things that I want to do.
1) When someone checks off a Yes box, for completing Task, I want the date to stop counting.
2) When a task has over 5 days due, I want an email sent to the Technician with the Repair ID number (fk in the Task table)
I have a script written, but the find doesn't work. Can anyone see an error in this?
Enter Find Mode
Go To Layout [Repairs]
Set Field [Tasks::Days Waiting ; < "5"]
If [Get (FoundCount)>0]
Send Mail [SMTP]
Go to Record [Last]