Calculate a value using an intersect and a related table

ColinCampbell1

Hi everyone,

I was wondering if anyone could tell me if the following was possible in theory?  I'd also love to know how to do it, but I'm happy to try to work out how if I know it can be done.

I have a point layer which allows people to collect species observations and a separate polygon layer of recording areas where people go to record their species.  The recording areas layer has a related table of visits which a user updates each time they visit an area to record species.

When people add a species observation I would like to intersect that point with the recording areas layer and pull information across from the most recent visit record of the intersecting area - with that information being populated into fields on the observation record.

For the workflow I'm using this needs to be done in the Field Maps app as the species observations records are being created, rather than it being something that can be done outside of FM afterwards.

Is this something that's possible?

Many thanks in advance for any help people can offer.

Colin

ZachBodenner

Alright, so here's a rule that worked for me as an attribute rule. In your case given the context, what you might do is instead of using the $datastore of FeatureSetByName, you might choose $map. Otherwise, you could use FeatureSetByPortalItem, which would allow you to access the layer even if it isn't in the map. 

Essentially, in Field Maps form designer, you would add this as a Calculated Expression, making that field uneditable for the user. You might need to tweak this because Arcade profiled are different across applications, but this should get you a good chunk of the way there. Just adjust your layer names, feature names etc as necessary.

// This is the polygon feature
var nrAreas = FeatureSetbyName($datastore,'NR_Management')
// intersect the polygons
var interArea = first(intersects($feature,nrAreas))
// This is the relted table
var matchTable = FeatureSetbyName($datastore,'NR_Management_Form')

// if there's no intersecting area, end the expression
if (interArea == null){return}

// get the global ID of the polygon
var interAreaGlobal = interArea.GlobalID
// Filter polygons based on shared ID. In this case, NRArea_Rel is a GUID type
var filterStatement = 'NRArea_Rel = @interAreaGlobal'

// Filter all the related forms
var relatedForms = Filter(matchTable,filterStatement)
// Get the data from the most recent form, determined by the 'Date' Field
var recentForm = first(OrderBy(relatedForms, 'Date ASC'))

// Identify the maintenance performed
var maint = recentForm.MaintPerformed

// Write the above value into the attribute this rule runs on
return maint