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:
Set Field [Project:Project Status ; "Ready for Invoicing"]
Send Email via SMTP
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:
"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...