AnsweredAssumed Answered

Email Notifications with Record Info

Question asked by mrtinvan on May 9, 2018
Latest reply on May 9, 2018 by Jason Wood

Preface with the technical info:

FM Server 15

Office 365 for Email Provider.

 

I'd like to send email notifications to users when a Project Status (Which is a field in the DB) gets set to a Status that is part of a specific users workflow ie: when a project gets to "ready for invoicing" a email would be sent to our accounting person.

 

I know i can put a script trigger on the Popup Box assigned to Project Status, and If I set it to OnObjectSave, I can have it run an email script.

 

The script that I have is:

 

If

     Set Field [Project:Project Status ; "Ready for Invoicing"]

     Send Email via SMTP

Else

     ExitScript

End If

 

Can I continue this script with Else steps to look at all the different values for Project Status?

 

Also - In my email setup, I want to reference some of the record information, but the calculation doesn't like having a bunch of plain text in it. I tried the following:

 

"Hello"

"Project Number"Project::Project Number","Project::Project Name"Has changed status to:"Project::Project Status

"Please check the project for your tasks"

 

But it won't accept the calculation...

Outcomes