What options are available for receiving an email when a particular tag is added or updated? More broadly what options exist if any for receiving an email when a people field such as member status is changed?
The current use case is small group notes. The ministry leader would like to know when a small group leader adds notes to a profile. More broadly I am just trying to understand what Arena is capable of.
There are several ways you could do this. If using the group leader toolbox the group leader has a choice on who to notify with the notes including an option for leaders or leaders & members. You could add the ministry leader as a leader in each group and then would be included in that. You could alternatively use a report from SSRS or a report grid from query that gets all the notes from all groups that the ministry leader is over. If you go the report grid from query route then make sure that the security is set properly so only the right people can see it.
Another method for handling this would be to create a query that looks for updates to the table.field: smgp_member.notes. This query could be scheduled to run as a job on SQL Server to process once a day, or several times a day, as you need.
Then, using the associated person_id, create a new Assignment with that person_id being either the requester_person_id or the person_id of a people workflow. (If you're not familiar with Assignments this might not make sense yet, but it'll work.) Then, your ministry leader would be the worker_person_id of the assignments, get notified of the new note being added via email.
This way, once the internals are setup, the process becomes automated and potentially hands-off for the IT team. I use this type of functionality all the time and it works GREAT! Plus it gives a level of accountability to ensure that things are getting done as needed.