AnsweredAssumed Answered

Script - Email

Question asked by mrtinvan on May 3, 2018
Latest reply on May 3, 2018 by philmodjunk

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"]

Perform Find

If [Get (FoundCount)>0]


          Send Mail [SMTP]

          Go to Record [Last]

     End Loop

End If