Hey! Spent days banging my head against a wall (learning make at the same time, everything is new 
) and finally figured out a way to take a form, then have make.com use the location field to go into a database (Fibery in our case) and “find” the salesperson and the manager of that location and send the notification and form fields to those people. We have multiple locations and new employees all the time, so I did not want more manual work every time we got a new employee.
Mapping was so hard, but between the ai in make and my own chatgpt account, (and about 100 tests over and over to figure it out), was finally able to get the variables I needed for the emails. Was hard because some locations have 1 salesperson and others have 2 salespeaople, so needed to set independent variables either way. Luckily leaving it blank didn’t mess up the email module (a blank “to” field was fine).
Anyway, if you have any questions I’ll answer them below. 