Hello,
could you please advise how to create dynamic email notification for this case?
We have a table called Request where people from our company can request access to our clients. The field client is linked to another table called Clients where we have the list of all clients and responsible people from our company who approves the access (list of responsible people is linked to another table called Employees where we have their email addresses). The goal is to notify the right person for each client.
The logic is following Request.client = Clients.Client then Employee.Responsible Person.Email
What can be the best way to set it up?