Auto populate related table with parent feature attributes

LukeRoyle

I am trying to populate the fields of my related table from the attributes of a feature class.

This would be in order to create workflow that retains previous data for the position within the table, before the feature class it updated. Ideally,  the user opens the form for the related table, that auto populates and captures the current data. Then they update the feature class, retaining the previous data in the table.

I am unable to achieve this currently. I tried to use 2. from this Common calculated expressions for ArcGIS Field Maps.

But can't get it to work.

The site is on a grid, so I first tried to auto populate the grid number from the polygon into the related table for management of data. I have put the following into the calculated expression of the table itself:

 

var parentgrid = FeatureSetByRelationshipName($feature, 'HSV_Record', ['GridSquare'], false)

var relatedgrid = First(parentgrid)

if (!IsEmpty(relatedgrid)) {

    return relatedgrid['GridSquare']

}

else {

    return null

}

 

Where am I going wrong?

Thanks.

More details attached.

 

 

 

 

CalcExp.png

ParentFeatureTable.png

parentform.png

editfeature.png

addrecord.png

Form.png

ApplyAssetPackage.PNG

Parsing Error.png

Extend_įrankis_2.jpg

Extend_įrankis_3.jpg

Extend_įrankis_1.jpg

Notebook_ArcGIS_Error.JPG

Ruth_JiatengXu_0-1736867464283.png

Scott_Harris_0-1736867369491.png

Portal_Tabs.PNG

GIS_Weasel_0-1736866915379.png

MatthewParkman_0-1736866654381.png

Cat and Map.jpg

dougbrowning

You have to wrap Filter() around the feature set to query out the one you want since that just lists all of them.

I have 32 different RelationshipByName and they all work but I know there has been many posts that it does not.

On the count I think if relategrid is empty then you try and do Forst() it may fail.  Not sure really.  Always good to use Console() to print out what it is getting.

May need to be 

relatedgrid = (Filter(FeatureSet(), the SQL query)

If Count(relatedgrid) > 0 {

            return First(relatedgrid).GridSquare

else

    return null