I'm looking for a way to send a notification to users based on a field value of a category. I know users can modify thier interests on folders but this is not really what i'm looking for. Users don't need to be aware of ever record that is added to a folder but in some cases they do, nor do I want to create tasks, workflows, projects, or any other drawn out process to achieve this.
We have a listing of employee's and the various issues that they are responsible for, but the list changes from time to time as to who is the lead for various issues. I would like to manage the notifications for them if at all possable via a master list using the reports feature or some other way.
I was thinking of creating a table lookup within a category that would have two fields, one for (user:field) where the name of a current user can be dropped in and the other would be a drop down list with two options (notify) & (do not notify). This way I can still tag records to users but still have the option to decide whether or not to send them a notification. For historical purposes we could still look back to see who was in charge of an issue at any point in time, then write a sql statement, not sure if this would work or how to go about doing it?
Or create user groups based off of the (topic or subject matter) and add members to the various groups, but this does not solve my issue regarding having control over when or what is sent to them and I dont want to do this manually each time a record is added. As well it would become very combursume to manage and control the permissions for all folders and groups.
Can we create our own reports via the reports feature that might work and where is the documentation on this. I dont want to create projects or tasks or any other long drawn out process where the user has to click and jump all over the place to find things. There has to be a work around for this as I can't be the only one who has run into this type of problem.
