topic Re: auto-populate fields when adding related records in ArcGIS Collector Questions

auto-populate fields when adding related records

CalebAnderson2 — Mon, 20 Jul 2015 21:16:03 GMT

Someone asked a similar question here with no replies so I'll ask it again in a different way.

Is it possible to auto-populate a field (in addition to the unique ID) from a parent feature service to a related record?

I currently have my unique ID auto-populating when creating new related records but I would like other fields to transfer to my related record as well. For example, I would like the manhole # and the serial # of the monitor to transfer from the original point feature service to the related table (maintenance records). Auto-populating fields would save the field-guys from typing this info over and over.

I've experimented with a few varieties of relationship classes without success. Any ideas would be great. Thanks

Message was edited by: Caleb Anderson

Contacted ESRI and was told by support that this is not possible

Message was edited by: Caleb Anderson

The best I could come up with for a workaround (after deep-diving into some other forums) is to move the data from the cloud to our local SDE. Our main brain GIS people will make the data available for collector and field collection work-flows will continue as usual. With the data stored locally, I can automate the following tool to "auto-populate" specified fields (field personnel leave the field blank and the tool runs nightly and replaced null values with data from a parent feature class field):

The "Calculate Field" in the above model builder tool has the following script:

I tried it out locally and it works but I haven't tried it through our SDE yet. There will have to be some coordination to make this happen but I don't see why it wouldn't work.

Re: auto-populate fields when adding related records

LisaCasey — Thu, 16 Aug 2018 16:43:30 GMT

I also would like to do this - preferably on AGOL

Re: auto-populate fields when adding related records

deleted-user-yC5VkbyXzrQR — Fri, 15 Feb 2019 04:33:29 GMT

How can this be done???

Re: auto-populate fields when adding related records

Anonymous User — Tue, 13 Oct 2020 14:44:03 GMT

Hello,

I've recently come across this issue myself and found a github that populates a parent FC from a populated related within ArcGIS Pro's Attribute Rules: arcade-expressions/UpdateParentFeature.md at master · Esri/arcade-expressions · GitHub

With a little tweaking I was able to reverse this to populate the related attribute table when populating the parent FC:

// This rule will update an attribute in the child table
// Build a relationship class from the Feature Class (origin) to the Table (foreign) based on GlobalID
// Store the child table globalID from the key field in the relationship class
var childGlobalID = $feature.ChildGlobalID;
if (IsEmpty(childGlobalID))
return childGlobalID;

// force to upper as the sql is case sensitive
childGlobalID = Upper(childGlobalID);

// Using the GDB name, get the parent classes records and Global ID field
var child_class = FeatureSetByName($datastore, "DBname.owner.TableName", ["GlobalID", 'ChildTableFeatureName'], false);
// Filter the parent class for only related features
var parent_records = Filter(child_class, "globalid = @childGlobalID");

var updates = [];
var i = 0;
var new_value = 'UpdatedFieldValue';

// Loop through each feature, create a dict of the Global ID and the new value date
for (var row in parent_records) {
// If the parent row is null or has a different value, updated it
if (IsEmpty(row['ChildTableFeatureName']) || row['ChildTableFeatureName'] != new_value)
{
updates[i++] = {
'globalid': childGlobalID,
'attributes': {"ChildTableFeatureName": new_value}
};
}
}

// Return the original value in the result parameter, as to not lost the entered value
// Using the edit parameter, return the class and list of updates
return {
'result': childGlobalID,
'edit': [
{'className': 'DBname.owner.TableName',
'updates': updates
}
]
};

I have not been able to get this working for AGOL yet but I am trying.

Re: auto-populate fields when adding related records

DougMorgenthaler — Fri, 16 Oct 2020 07:23:21 GMT

Brady Ross support for attribute rules is currently limited to ArcGIS Enterprise feature services.

Re: auto-populate fields when adding related records

Anonymous User — Fri, 16 Oct 2020 14:50:49 GMT

Aha! Thanks Doug Morgenthaler‌!

Re: auto-populate fields when adding related records

RitaMatildes — Thu, 04 Feb 2021 10:38:35 GMT

Hi Brady,

I have come across your code and I believe it is the answer to my problem. Unfortunatelly I am not being very successful in applying it to my case which I think is a bit different.

I am working in ArcGIS Pro 2.7 and Portal 10.7.1.

So I have a feature class with GlobalID and Fields A and B. I have a relationship class of 1:M to a table (FK: ParentGlobaIID) with corresponding fields A and B.

When adding a new entry in the related table, I'd like to auto populate fields A and B with the values of A and B in the parent feature class.

I am sorry if this is obvious but I cannot make this work for me. Could you please help me out?

Thanks is advance!

Re: auto-populate fields when adding related records

JohnWatson_EBA — Tue, 29 Jun 2021 18:14:27 GMT

@Anonymous User, did you create this rule in the related table attribute rules or the parent feature class? And what did you use for the UpdatedFieldValue? That should be a value from the parent FC, correct, so what should the syntax look like if this rule is being created in the related table list?

Re: auto-populate fields when adding related records

Anonymous User — Thu, 08 Jul 2021 19:33:18 GMT

I was able to use the below code to success with Attribute Rules in ArcPro using Arcade.

After relating the two fields, only thing is you need to alter a value to initiate the change.

// first read out the Foreign Key of the Destination Table (Feature Class) var fcID = $feature.F_streetnameid // access the Orgin table (Table) var tbl = FeatureSetByName($datastore, 'MasterRoadName'); // create a sql expression to query on Primary Key var sql = "streetnameid = '" + fcID + "'"; var related_data = Filter(tbl, sql); // count the resulting records var cnt = Count(related_data); // initiate a variable to hold the result var results = ""; // check if there are related records found for the current ID if (cnt > 0) { // loop through related records for (var row in related_data) { // read some data and create the line you want var line = row.roadpretype; // add the line to the result results +=line; } } else { results = "Need Segment Table relate"; } // return the result return results;

Re: auto-populate fields when adding related records

ILoveMap — Fri, 24 Feb 2023 13:59:55 GMT

I'm wondering if anyone has made progress on implementing this in AGO / Field Maps?

Re: auto-populate fields when adding related records

ChrisH2 — Wed, 08 Mar 2023 23:51:43 GMT

Also interested in a solution to this for hosted featureclasses and related tables in ArcGIS Enterprise10.9.

I understand that calculated expressions in Field Maps may solve it for us (at the point of data capture), but as an organisation we're at least 6 months away from upgrading to Enterprise 11.

Seeking a solution that allows this to be automated post data capture in the Portal environment, or at worst case the workaround is Attribute Rules in ArcPro and running this client-side?

Re: auto-populate fields when adding related records

MattyMaps — Tue, 20 Feb 2024 20:49:49 GMT

Yes, add a calculation, like the one in this video:

https://www.youtube.com/watch?v=BWXZzYAIkKk