I have an issue that has me banging me head. I think at this point I am making it more complicated than it needs to be. Background - We needed a process to allow our Product Managers to enter new Products into SF and select internal contacts to be notified when a product is purchased. Since there was a lot of information that has to be entered by the SF admin as well we created a flow that takes all of the information about the product, creates the new product record (standard product object), asks if there are contacts to be added, once the contacts are selected there is an apex class that loops through the list and creates a record for each email address in a new Custom Object. There is a lookup field to the product name in the new custom object (custom object name = Notifications). All of this works as intended.
When a customer purchases an product a record is created on an object called "Our Products", which has a masterdetail with the Account and a lookup to the product. There is also a status field that is a picklist. When the picklist status is "Purchased" I need an email alert to be sent to the email addresses on the Notifications object.
Since there can be many "Our Product" records and Many "Notification" records I tried using a junction object, but I just don't think I understand what I am doing - or, as I fear - making this too complicated.
Do I need to include the code for the flow? I am looking for suggestions on how to resolve - can I do a trigger? I don't want anyone to write anything for me - just looking for some help. Maybe someone else has done something similar?
Any suggestions would be appreciated.