How to access data from other tables or layers?

[Ulises]

We have a table that stores 2 fields with the required information: regional office and region email.

Example:

REGION	EMAIL
region 1	email 1
region 2	email 2

Our workflow documents the regional office for each assigned job as an extended property that is updated when the supervisor create the job.  Is there a was to linked or access the region email information (or any other value for that matter) at an specific step?  The idea is that depending on the regional office assigned to a job, when a step runs a notification is send to that regional office email.

Thanks in advance.

[MargoHuang]

Hi Ulises,

I believe you can use this Arcade function - 

JobExtendedProperty(job_id, table_name, field_name, {return_domain_description})

Please check out ESRI documentation here. Extended property functions 

Hope this helps!

Margo

[Ulises]

Hi Margo,

thanks for the feedback.  Not sure if this works since I do not capture the email in the extended properties, just the region name. Each region has a specific email address.  I haven't found a way to automatically insert email 1 for region 1 in the correspondent attribute.

[MargoHuang]

I see. How many regions do you have? If there is not a lot, I will create a dictionary using region as key and email as value. And use Arcade to get the email from the dictionary based on region input. Hope this helps!

Margo