topic Re: Auto populate Related table from Parent table using Arcade in AGOL? in ArcGIS Online Questions

Auto populate Related table from Parent table using Arcade in AGOL?

KGalluccio — Fri, 22 Dec 2023 13:14:12 GMT

Is is possible to auto populate fields in a related table from the selected record in the parent table using Arcade in AGOL?

I have a AGOL web map that includes one hosted feature layer with a related table with a one to many relationship. The number of features in the feature layer is static. Using forms, the map allows the user to select a feature and edit it's attributes, including adding records to the related table.

The work process is that the current attributes of the selected feature need to be added as a new record in the related table, and then updated with new information.

When the user selects a feature to edit, then clicks to add a record to the related table, I would like the fields to auto populated with the selected features attributes.

Is this possible?

Re: Auto populate Related table from Parent table using Arcade in AGOL?

marksm_macomb — Fri, 22 Dec 2023 15:53:53 GMT

I've been implementing this arcade script in the smart forms for my related tables to auto populate the parent ID field in the related table, but you could use it for any additional fields as well. So this script would be applied to a calculated expression on the field you are trying to populate (my relationship class is based on GlobalIDs):

var parent_id = $feature.ParentGUID Var related_Features = FeatureSetById($datastore, "layerid") Var parent_Feature = First(Filter(related_Features, 'GlobalID = @parent_id')) if(parent_Feature == null){ return } else { return parent_Feature.FACILITYID }

Re: Auto populate Related table from Parent table using Arcade in AGOL?

ChristopherCounsell — Fri, 22 Dec 2023 22:15:59 GMT

No this is not directly possible. Here are your options:

User does second edit on point feature
Automated process to check for new related records, update parent, then flag related table field as processed
Set up the edit to use Survey123 Inbox. Custom url scheme, limit repeat count, calculations. User adds and updates directly

I think option 2 is best. Use ArcGIS Notebooks to run a python script every 15min. Cleanest data control without exposing the direct disability of the parent point to end users.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

KGalluccio — Thu, 04 Jan 2024 14:45:43 GMT

Thank you. This worked well.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

ChristopherCounsell — Fri, 05 Jan 2024 09:42:41 GMT

I read this incorrectly as populating the parent from the related record update. The above is possible.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

Laura — Thu, 11 Jan 2024 15:13:42 GMT

I am looking to populate the gravesiteid field from the parent into the gravesite id field in the related table, but running into issues

Could anyone write out what goes where?

Re: Auto populate Related table from Parent table using Arcade in AGOL?

KGalluccio — Thu, 11 Jan 2024 15:03:15 GMT

I would get the same error because I was not referencing the correct layer_id from the map.

Are you sure your layer_id is "gravesiteid"? From my limited experience it is usually not that descriptive.

For ex. a layer_id in one of my maps for a Road layer named "Roads" is "18cf513418f-layer-3".

The only way I have found so far to get a layer_id without using code is to use ArcGIS Assistant to view the JSON of the web map.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

Laura — Tue, 06 Feb 2024 14:16:45 GMT

I tried putting some #s in, but still get an error. I am very new to this so I guess I'm confused on what it is asking for.

Update:

This is what ended up working for me

Re: Auto populate Related table from Parent table using Arcade in AGOL?

KGalluccio — Thu, 11 Jan 2024 16:27:59 GMT

Issue might be in your third line for the filter. You have it filtering to 'gravesiteid = @gravesiteID'

I think it should be 'gravesiteid=' + gravesiteID.

Here is the code I am using that is working. In the featuresetbyid I am adding a third parameter to just grab the specific field.

var join_ID = $feature.ID

var fs_prevprojyear = FeatureSetById($map, "18cf513418f-layer-3", ['Project_Ye'])

var filter_relate_feature = First(Filter(fs_prevprojyear, 'ID=' + join_ID))

return filter_relate_feature.Project_Ye

Re: Auto populate Related table from Parent table using Arcade in AGOL?

marksm_macomb — Fri, 12 Jan 2024 14:23:10 GMT

@Laura I think the problem might be in your FeatureSetById expression as well, specifically with the layer id. You can auto-populate the FeatureSetById expression by using the profile variables in the arcade editor by going here:

Then choose the arrow next to the layer you are interested in and it will give you the expression with the correct layer id already filled out.

Another way to check your layer ID is to go to the overview page for your layer and look at the URL:

The blue highlighted section is the ITEM Id, and the green highlighted part is the LAYER Id.

Hope this helps!

Re: Auto populate Related table from Parent table using Arcade in AGOL?

cat206 — Tue, 06 Feb 2024 12:38:18 GMT

Hi, does anyone know if is this possible when you have more than one parent feature layer (points, line and polygon) feeding into one related table (inspection records)?

Re: Auto populate Related table from Parent table using Arcade in AGOL?

AmyCleare — Sat, 17 Feb 2024 21:32:14 GMT

Will this work to populate a new record of related table? This fieldmap was created from three feature classes related to a single table, then published as a referenced feature layer to AGOL. The field map users only edit the table with a new record. Can the functionality that allows for autopopulating for data from a feature with the FeatureSetbyName be used in the conditional expression on a field in a FieldMap form?

Re: Auto populate Related table from Parent table using Arcade in AGOL?

AdminNCCMA — Tue, 11 Jun 2024 00:13:02 GMT

Hi Mark,

I'm new to expressions in AGOL.

I have a related dataset and table published, the relationship is based on GlobalIDs. I'd like to populate in the related table a field named 'Bore_ID' from the field in my spatial data named 'Bore_ID_' and I am struggling to figure it out following your method. Any help would be VERY much appreciated.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

Marisa_Kordecki — Fri, 28 Jun 2024 15:53:07 GMT

I'm hoping someone here might have an idea of a similar issue I am having.

I am trying to populate my related table with a parent table field. I do not get any errors when I use the calculation in AGOL on the field, but as there is no undo I would really prefer to do the calculation in ArcPro.

Using the exact same code that would work in AGOL in my calculate field in ArcPro, I get an error that they cannot find the related tables.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

Marisa_Kordecki — Fri, 28 Jun 2024 15:59:34 GMT

I do not know why this is incorrectly marked as a solution.

Re: Auto populate Related table from Parent table using Arcade in AGOL?

AdamAull — Tue, 23 Jul 2024 15:10:42 GMT

I have a very similar workflow that needs a solution in ArcGIS Online Arcade.

A map was created with feature service containing a feature layer and its related table. The feature layer and related table both have an address field. The address field in the feature layer is calculated based upon an Arcade expression. The address field in the related table needs to be calculated based upon the related record's feature.

The workflow has a user creating a new feature and the Arcade expression populates the feature's address field. The user then creates a record related to the new feature and enters attribute values. An Arcade expression needs to pull the address from the feature into the related table record.

I can't seem to get the provided solution to run. Anyone have additional ideas?

Re: Auto populate Related table from Parent table using Arcade in AGOL?

NathanBush1 — Fri, 09 Aug 2024 18:23:07 GMT

Has there been any progress on this? Similar situation where I have point layer with a PairID field that I want passed to the related table. This is a 1:M, Unfortunately, the relationship was built on different field, so PairID is not carried over from the point to the related table.

Re: Auto populate Related table from Parent table using Arcade in AGOL

AdamAull — Fri, 09 Aug 2024 19:07:33 GMT

Hello Nathan,

Unfortunately I haven't been able to find an Arcade solution to this issue yet. The workaround I have is using Python run on a workstation as a task to pull the address from the source feature class and populate the field in the related table. Python could work in a Notebook, but I'm not willing to spend the credits each time the task runs.

-Adam

Re: Auto populate Related table from Parent table using Arcade in AGOL?

MonmouthNJGIS — Wed, 28 Aug 2024 13:25:49 GMT

Thanks for sharing this! I am trying to use this in my Organization's Field Mowing Operation. We have an Open Fields layer with a related Mowing table (1:M) based of the Field LINKID (' Park_Area'+ '-' + 'Filed ID'). I'd like to be able to pull the attributes for Park Area and Field ID automatically into the new related record.

I suppose I have two questions:

A. If I understand correctly, this is possible?

B. I am a little lost as to where this arcade expression is placed as I don't see an option to add Arcade Scripts to the related table.

Thank you for any help!

Re: Auto populate Related table from Parent table using Arcade in AGOL?

MonmouthNJGIS — Wed, 28 Aug 2024 13:26:32 GMT

I suppose I have two questions:

A. If I understand correctly, this is possible?

B. I am a little lost as to where this arcade expression is placed as I don't see an option to add Arcade Scripts to the related table.

Thank you for any help!