topic Re: Update many-to-many relationship through selected items in ArcGIS Experience Builder Questions

Update many-to-many relationship through selected items

Service_SIG_CAPDFT — Mon, 14 Apr 2025 14:34:03 GMT

Hello,

I'm trying to create an Experience Builder application that allows a field agent performing an intervention on a network to link this intervention to the actual network segments involved.

The data consists of a point feature class called "interventions" and a line feature class called "network". Naturally, a network segment can be involved in multiple interventions, and a single intervention can concern multiple segments. Therefore, a many-to-many (M:N) relationship has been defined in the database.
The datas had been published as a service on our enterprise server then used through URL in Online portal.

Since it's not possible to know in advance which segments are involved, only the team leader in the field can determine which ones are affected. As the teams are not GIS experts, I believe the most user-friendly way to enter the data is to allow them to select the segments directly on the map then clic an "update" button.

In ArcGIS Pro, it's simply a matter of selecting the "intervention" and "network" features, then using the attribute pane and the tool "Add selected item to the relationship".https://pro.arcgis.com/en/pro-app/latest/help/data/relationships/populate-an-attributed-relationship-class-table.htm

Now I'm trying to replicate this action in Experience Builder (or in ArcGIS Online more generally).

The solution suggested by ChatGPT was to develop a custom widget, but I currently don't have the time or skills for that...

I'm open to any ideas.
Thank you.

Re: Update many-to-many relationship through selected items

Allen_Zhang — Fri, 18 Apr 2025 08:05:40 GMT

Hi @Service_SIG_CAPDFT

Have you tried the Edit widget's map mode? It supports editing related records.

Re: Update many-to-many relationship through selected items

Service_SIG_CAPDFT — Mon, 28 Apr 2025 08:33:27 GMT

I'm using an old version 10.9.1 of enterprise.
Related records are supported natively on published data from 11.2 enterprise.
I will have an update this autumn and will try the soltution.
Thx

Re: Update many-to-many relationship through selected items

Gene_Sipes — Tue, 03 Jun 2025 16:33:10 GMT

I want to do this same thing! What is the solution?

Re: Update many-to-many relationship through selected items

Gene_Sipes — Tue, 03 Jun 2025 16:33:33 GMT

What is this map mode? How do you enable that?

Re: Update many-to-many relationship through selected items

Allen_Zhang — Wed, 04 Jun 2025 02:22:59 GMT

Re: Update many-to-many relationship through selected items

Gene_Sipes — Wed, 04 Jun 2025 14:19:28 GMT

Thank you! Can you tell me more about your setup? Are your feature class and your related table hosted in either AGO or Portal? Or is it a service published from an SDE DB to a standalone/federated arcgis server?

The setup I am hoping to achieve is as follows:
-SDE DB Feature Class related many-to-many to a standalone Table
-Published as a feature service to a federated arcgis server to either use in my Portal, or added as URL to AGO.

Re: Update many-to-many relationship through selected items

Allen_Zhang — Thu, 05 Jun 2025 01:36:52 GMT

Mine is a hosted service. I searched and the doc said the SDE DB can be published as a service with relationships. But I never did that so I don't know the operatable steps.

Re: Update many-to-many relationship through selected items

EvanManrow — Fri, 06 Jun 2025 04:44:31 GMT

This doesn't work for many-to-many related tables. There isn't any way to add them to the Edit Form. Neither Map Viewer nor Field Maps allows it.

I say this somewhat over-confidently, in the hopes that someone will correct me with a working solution — but after spending this week fighting the issue, I'm pretty confident it's impossible. 😕

Re: Update many-to-many relationship through selected items

Allen_Zhang — Fri, 06 Jun 2025 05:10:00 GMT

It's true.

Re: Update many-to-many relationship through selected items

Gene_Sipes — Fri, 06 Jun 2025 13:24:20 GMT

Not that it helps your particular workflow, but have you tried this with a hosted feature service?

Re: Update many-to-many relationship through selected items

EvanManrow — Fri, 06 Jun 2025 14:39:18 GMT

Using a hosted feature service (via "Publish Web Layer" in Pro) gets one step closer: it will at least show the many-to-many records reliably in Popups. That doesn't really make sense to me, since I have to add the Service to a Web Map to load it into EB anyway.

But without a way to add the Relationship to a Smart Form on the feature layer, there is no way to edit the relationships in AGOL. From the intermediate Table I can delete records, and from the Related Table I can add new features to the related Feature Layer, but I can't associate existing Features and Records.

Re: Update many-to-many relationship through selected items

Service_SIG_CAPDFT — Thu, 19 Jun 2025 07:29:42 GMT

After checking with ESRI, it is not possible to perform this many-to-many join directly from AGOL.
Our solution, therefore, was to pay for the development of a custom web service by ESRI.
This web service, hosted on our Enterprise environment, will be called via the "Analysis" widget from an Experience Builder hosted on AGOL.
A feasibility study is currently underway and should be delivered to us before the end of the year. The constraint is to have an Enterprise server with version 11.2 or higher.

I will share the relevant information with you as soon as possible.

Re: Update many-to-many relationship through selected items

Gene_Sipes — Mon, 23 Jun 2025 13:28:56 GMT

Thanks for the update. I am interested in learning more!

Re: Update many-to-many relationship through selected items

Service_SIG_CAPDFT — Fri, 11 Jul 2025 08:09:51 GMT

We got news from ESRI. Il will cost between 25 to 30 k€ to get a custom widget on our enterpirse server.
It's not possible to get a script on our enterprise called by the analysis widget on our AGOL.

So basically the project is on hold because this solution does not suit us.

I will push futher investigations with the help of AIs to find a workaround but with little hope.

Re: Update many-to-many relationship through selected items

Service_SIG_CAPDFT — Fri, 11 Jul 2025 08:16:03 GMT

To update the chat, our setup is the following :
- A post GRE SQL database
- Create a relationship class through arcgis pro
- Publish the related layers and the raltionship table together in a single service on our enterprise
- Use the URLs on an AGOL map viewer

Re: Update many-to-many relationship through selected items

Gene_Sipes — Fri, 11 Jul 2025 13:53:31 GMT

Ouch, thats a bit high. I'm curious, did ESRI explain why it is not possible to have two feature classes or tables related many to many, published from an enterprise server, not have the capability to be edited?