Pull date from previous record in a child table

[AustinPhelps1]

I am trying to calculate a field in field maps using the arcade expression.

I have a parent/child relationship and I need to pull the last recording date to populate a field on the new record created.

Here is what I have, and it is currently not working. What am I missing in my expression?

//Fetch the related inspections from the related table using the relationship name

var inspections = FeatureSetByRelationshipName($feature, "Corrosometer_Probe_Data_Records", ["Read_Date"], false);

//Sort inspections by the read date in descending order to get the most recent

var sortedInspections = OrderBy(inspections, "Read_Date DESC");

//Get the first (latest) inspection date

var latestInspection = First(sortedInspections);

//If there are previous inspections, get the date of the latest inspection

if (!IsEmpty(latestInspection)) {

  return latestInspection["Read_Date"];

} else {

  //If no previous inspections exist, return null or a default value

  return null;

}

Thanks for any help!

[Amanda__Huber]

Hi @AustinPhelps1 , 

This sounds very similar to on of our current projects which uses relationship classes (1:Many) with related table information being pulled into our parent table's popup. 

Here is example for what we did to pull the top 3 records and diplay in a popup. I believe you could just pull the top one record instead. 

I believe you might need the "Top()" function for your script for it to work. https://developers.arcgis.com/arcade/function-reference/featureset_functions/#top

Hope this helps! 

Best, 

Amanda Huber

[AustinPhelps1]

Doesn't seem to have worked, but thank you for the suggestion. I keep getting this when running it: Test execution error: Execution error - Invalid parameter. Verify test data.

I have 1500 records in my child table and 28 points in the parent so I know there is data in them

[Amanda__Huber]

Try adding this as well, this matches up the parent's GlobalID with the related table's GUID so it knows what parent record to pull from. 

Best of luck, 

Amanda Huber