https://www.mockaroo.com/28307210
I’m building out an organizational hierarchy file. When I run my schema to generate new users, I want it to look at the department_name and level, so if finds a someone who is an “Executive-Level” and in “Operations”, it will return that user’s email address to be their manager.
sounds like you want to populate a managers e-mail field from a defined list?
You probably want to create a Dataset for the manager detail
and then you can use the from_dataset() function as a custom formula
from_dataset(“dataset”, “column”, join_criteria)
I would probably do something simple in the data set like Key / Value pairs e.g.
Key | Email
Executive-Level Operations | [email protected]
Executive-Level Strategy | [email protected]
and then in the formula something like :
from_dataset(“dataset”, “Email”, ‘Key’:concat(field(‘level’), " ", field(‘department_name’)) )
Something like that should bring back a consistent email for a level / department
