Hello!
I have a location drop down field that loads a list of locations from a DB read. That part works great. In that same DB table, there are multiple columns like location manager name, email and phone. What I want to do is have the user select a location and then when we get to sending an email, I want the email of the selected location to be populated in the email 'to' field so that the location manager get's a copy of the confirmation email.
My question is: How do I set those variables so when a location is selected, the other associated variables from the table are also loaded and are assigned a label I can reference?
Thank you!
You will need a Read Data before the Email action to read the record of the selected location then use {var:read_data_name.email} in the Email action Recipients field
