topic Re: Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row in ArcGIS Pro Questions

Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row

YinghongLi1 — Thu, 17 Jun 2021 19:05:45 GMT

My case is like following:

1. user selects a feature.

2. user creates a new row in the feature's relate table

3. An Arcade attribute rule in the relate table will get the selected feature's ID and assign the ID to the newly created row.

Not sure if this can be done since two $feature variables needed. have not see a sample which updates a table.

Note: database is Oracle/SDE. Table is registered with SDE so it has OID.

Thanks...

Re: Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row

JohannesLindner — Fri, 18 Jun 2021 07:10:20 GMT

What you describe isn't possible right now, because Arcade doesn't recognize selections.

It is absolutely possible to get other tables (take a look at the FeatureSetBy* functions) and to edit another table (take a look at this blog).

So you could get your feature class with FetaureSetBy* and then filter it. For that, you need a field that is in both tables. In your case, that is likely the ID, and you want to get that, so this way isn't possible.

If the table you're creating a new row in (step 2) is a feature class, maybe an intersect works for you ("If this new point intersects an existing polygon, take that polygon's ID").

If you have a feature class and a non-spatial table, and the only field linking those is ID, then you can't do this with Arcade.

What you could do:

Create a relationship class between the fc and table
Select a feature
Open the Attribute Pane
Expand the feature to see its relationships
Right click on the relationship you created, "Add New To Relationship"
ArcGIS creates a new record in the related table, puts the feature's ID in the field specified by the relationship class, and opens the new row in the Attribute pane.

Re: Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row

YinghongLi1 — Mon, 21 Jun 2021 12:41:20 GMT

Thanks! Too bad that i can't do the attribute rule on this. However your solution worth to explore.

Re: Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row

YinghongLi1 — Thu, 24 Jun 2021 15:37:20 GMT

I tried this out and it works very well. with editor tracking applied, all the values which need to be entered automatically are done. thanks. very smart!

Re: Arcade Attribute Rule--Get selected feature ID and assign it to a newly created row

JacobFulkerson — Fri, 04 Oct 2024 16:14:35 GMT

Hi there,

Is there a way to replicate this workflow if I have the data layer and relationship table published as a feature service in Enterprise?

Thanks