Hello,
I’m having trouble figuring out how to automate email sends once a record is created.
Specifically, once the record is created I only want an email to go out to the property manager associated with that property and not to all property managers.
You would need to have at least the property info in your table. And then when you trigger the Bot, you could read the manager’s email address with something like LOOKUP([_THISROW].[PropertyID],“PropertiesTable”,“PropertyID”,“ManagerEmail”)
Alright, so I have the properties tab with the related info and a column header of PM and then the email that associates to the property
Column Headers
LOOKUP([_THISROW].[Facility ID],“Properties”,“Facility ID”,“PM”) if PM column contains the email address.
You are fantastic, thank you for your time.
You’re welcome