I have a application that consists of projects and tasks. A project can have many tasks linked by the project id. When I mark a project as complete or cancelled and then go to save it, I would like to check to see if any related tasks are open (not closed or cancelled). If any tasks have a status other than closed or cancelled, I would like to prevent the project from being saved.
What would be the best approach to accomplish this?
Thank you for the feedback. I have what you suggested mostly working. The only issue that I have is that if the task status is changed within the project form in grid edit mode, the task status summary field does not update and thus I cannot save the project (if I also mark the project as closed). In other words, if I edit the project and close all tasks via grid edit and mark the project as closed, I cannot save.
Any ideas on how to get around that?
Now, the question is who to fire the email to as the [Last Modified by] will be the Automation owner and not the person who tried to close the project.
So the first step in that Automation will need to be to copy the value in the field [Last Modified by] to a field called [Who to Notify of a Status reversal]. Then you have a field to email to.
Also, on the Form rule that I built, the message that displays on Abort Save shows not only the message that I created but also all the criteria that needs to be satisfied in order to Save. So the message is kind of messy. Is there a way to exclude the criteria from the message?