I've Googled this but might just not be using the right search phrases. I'm building an RFP repository for my company. Each RFP question will have a Category assigned to it. Within Drupal, I'd like to:
- Automatically assign one or more users as the SME (subject matter expert) based on the Category that was assigned to the question, e.g. if Category = Analytics, then automatically assign user 'John Smith' as the SME upon node creation. The users assigned to the question should be viewable on the node.
- To do this, I'd need to have a mapping of Category => SME(s) table I'd assume.
- The end goal, would be to use something like the Flag module to be able to notify those users via email if an RFP question that they are the SME for needs updating.
- Ideally, there would be a way to automatically update existing nodes with the most current mapping of Category => SME (people leave, new people come onboard, etc.)