topic Re: Experience Builder Edit Related Tables in ArcGIS Experience Builder Questions

Experience Builder Edit Related Tables

ChristopherBarrow1 — Wed, 28 Dec 2022 21:19:15 GMT

Hi, I am trying to solve a tabular data issue in the ArcGIS Online environment.

I want any of my 4 or 5 users to be able to edit a coded list (domain). When we add a new record, for example a work order in our work order table, and the requesting customer is not listed in the domain drop down list for the customer attribute, only I as the feature layer owner can go back to the data tab in the feature layer properties and add another customer in the coded list.

I have tried sharing the feature layer in a shared update group, and they can't edit it there.

The environment I am looking at for the front end is the experience builder edit widget, b/c it allows us to add a new record. I have tried linking related tables together, but can't come up with a solution.

Does anyone have any ideas? I am up for any solution, just as long as any user can still add a record.

Thanks.

Re: Experience Builder Edit Related Tables

AlixVezina — Thu, 26 Jan 2023 15:29:35 GMT

@ChristopherBarrow1

Unfortunately there is not straightforward way to do this right now. But I've heard this request before and it makes a lot of sense.

Perhaps this workaround would work?:

Layer 1 (customers layer): has records for the customers (each row is a new customer), with the customer name/id field. This layer could be displayed in a List or Table widget.
Layer 2 (work order layer): Has a field to enter the customer name/id.

In your app, you'd probably use 2 Edit widgets:

Edit 1: add a new customer to Layer 1
Edit 2: add new work orders to Layer 2

The users could create a new Work Orders (Edit 2) and refer to the Customer layer list (Layer 1) to copy-paste the customer name/id. If the name/id is not available, they can create a new record in the Customers layer (Edit 1). Downside: there's a risk the value is not properly copy-pasted.

This workflow would be simpified once editing related records will be available in the Edit widget. Then you should be able to add new customers to the Customers layer (Layer 1) and then add new related Work Orders directly for each of the customers. Being able to create and update related records in the Edit widget is currently being worked on by our dev teams.

I hope that makes sense...

Alix

Re: Experience Builder Edit Related Tables

ThomasColson — Thu, 18 May 2023 19:41:49 GMT

It seems like Experience Builder shouldn't be released until it has the same functionality as WAB? What is the incentive to switch to EB if there's no functionality?

Re: Experience Builder Edit Related Tables

NathanR — Thu, 03 Aug 2023 15:21:09 GMT

100% Agree. I'm stuck using WAB because EB does not have smart editor. There is no way to add a related record without manual copy/paste. So frustrating!

Re: Experience Builder Edit Related Tables

AlixVezina — Thu, 03 Aug 2023 16:17:27 GMT

Editing related tables in Experience Builder is currently in the product plan. The target release is this fall 2023, usually in October.

Re: Experience Builder Edit Related Tables

BenCunningham — Wed, 16 Aug 2023 14:23:31 GMT

Ugh, if this is so, then why is Web AppBuilder being retired July 2024? This means I can't make the Experience I need right now, and if I invest time in making one in WAB it will soon need to be replaced... with Experience Builder.

Re: Experience Builder Edit Related Tables

AlixVezina — Wed, 16 Aug 2023 16:58:14 GMT

@BenCunningham Only the developer edition is being retired in July 2024 - which means no new developer editions will be released after that date. Retirement for ArcGIS Online is not until the end of 2025.

Re: Experience Builder Edit Related Tables

BenCunningham — Wed, 16 Aug 2023 18:07:41 GMT

Ok thank you for your prompt response. I'll move forward with WAB now since it is stable and I know how to make it.

Re: Experience Builder Edit Related Tables

KumuduDesilva — Thu, 02 Nov 2023 17:47:35 GMT

Hi,

Is it released now? I am having issues with connecting relate table editing on EB.

thank you.

Re: Experience Builder Edit Related Tables

AlixVezina — Thu, 02 Nov 2023 18:10:40 GMT

Yes, this is supported in ArcGIS Online, in Experience Builder. See What's new—ArcGIS Experience Builder | Documentation

Make sure to first specify a related records element in Map Viewer.

Re: Experience Builder Edit Related Tables

KumuduDesilva — Thu, 02 Nov 2023 19:06:19 GMT

Thank you very much.

Re: Experience Builder Edit Related Tables

BenCunningham — Mon, 06 Nov 2023 14:48:56 GMT

Glad to see this addition in the newest October release. @AlixVezina Is this only available for fully-hosted features though? I have feature services with related tables that I would like our users to be able to edit from Experience Builder's Edit Widget. Is this possible?

Re: Experience Builder Edit Related Tables

AlixVezina — Mon, 13 Nov 2023 21:37:24 GMT

Hi Ben,

It is supported for feature services but only starting at Enterprise 11.2.

Reminder: to edit related records and features, this needs to be configured in the Smart Form.

Re: Experience Builder Edit Related Tables

Laura — Tue, 14 Nov 2023 21:29:04 GMT

I have not used forms before, can you elaborate so I can edit the tables in EXB?

Re: Experience Builder Edit Related Tables

AlixVezina — Tue, 14 Nov 2023 21:50:50 GMT

Please follow the steps from this blog to setup the smart form which will allow you to edit related records both while editing in the Map Viewer and in Experience Builder: Introducing Related Record Editing in Map Viewer (esri.com)

Re: Experience Builder Edit Related Tables

Laura — Tue, 14 Nov 2023 21:54:35 GMT

I did follow it from your previous post however it does not show in EXB.

Re: Experience Builder Edit Related Tables

AlixVezina — Tue, 14 Nov 2023 21:58:55 GMT

When you add the Edit widget to your ExB application and connect it to the web map for which you've configured forms, the related table editing should just work as expected.

Re: Experience Builder Edit Related Tables

Laura — Tue, 14 Nov 2023 22:09:23 GMT

Would it show up down here under some related tables heading? I even deleted and reconnected my map to the app.

Re: Experience Builder Edit Related Tables

AlixVezina — Wed, 15 Nov 2023 15:53:02 GMT

From the web map in Map Viewer, when you build the Form for your parent layer, make sure to add the related records to the Form.

Re: Experience Builder Edit Related Tables

Laura — Wed, 15 Nov 2023 16:05:03 GMT

I did! Turns out I had customize as my option for editing in EXB but you have to choose web map setting instead.