topic Re: Issues with editing related tables in a web map and with widgets in WAB in ArcGIS Online Questions

Issues with editing related tables in a web map and with widgets in WAB

TimConfare — Thu, 01 Feb 2018 19:44:38 GMT

Thought I would start a discussion on editing related tables. I am finding this process frustrating as it doesn't appear to be very flexible. I simply want to edit attributes in a related table and not allow any geometry changes. For example, a user selects a parcel and adds/edits a zoning category and rezone number from a related table. I have a parcel layer that has a relationship class with a zoning table (1-M). That part works fine. Editing it in a simple manner is pretty tricky. Here is what I have tried:

Editing it in the web map - As far as I know you cannot enable editing only on attributes. The option to add a feature appears to be available which I definitely do not want. When I click on a parcel and select Edit in the popup, related fields do not appear....only the parcel number of the layer, even though I have the edit boxes checked in the Configure Attributes window for the related fields that I want to edit. If I disable editing for the layer, it disables editing on the table automatically.
Crowdsource Manager template - It appears this template is set up to edit attributes related to point features that was added by a Crowdsource reporter application. I need to edit attributes related to existing polygon features.
Batch Attribute widget - This would be the ideal widget to use as our users may want to edit the same attribute for multiple records (change all zoning categories to RH-2 for a subdivision for example). This widget does not work with related tables. You can select by a related attribute but can't edit it.
Smart Editor widget - Unfortunately, this widget does not work with related tables
Edit Widget - This appears to be the only way to edit related attributes but the process is excruciating. First, you click on the New Selection icon to select polygon(s). Once selected, you have to click on it again or select the Attributes button to bring up the pop-up. The Related table appears at the bottom of the pop-up with an edit icon. Clicking on that takes me another page that just shows the Related records again. You have to click on that to finally brings up the attributes to edit. I'm not sure if clicking three times just to get to the attributes is really going to work with users, especially if you can only do this one feature at a time. Plus, there is a delete button on the bottom that will delete the feature.....I don't seem to be able to disable that...even if I disabled the "Allow geometry updates" when publishing the service.

Am I missing anything?

Re: Issues with editing related tables in a web map and with widgets in WAB

RussRoberts — Fri, 02 Feb 2018 13:57:30 GMT

For editing attributes only, you will have to set this on your hosted feature layer:

Choose Update attributes only if you want editors to enter attribute information without changing any feature geometry.Manage hosted feature layers—ArcGIS Online Help | ArcGIS

Note this is a control on the whole feature layer so all layers and tables will have the same editing property. If you want to hide editing on the parent feature I would disable editing on that layer in the Map Viewer and save the web map.

Re: Issues with editing related tables in a web map and with widgets in WAB

TimConfare — Fri, 02 Feb 2018 15:16:11 GMT

Thank you for your reply! I forgot to mention we don't use hosted feature layers. Our feature and map services point to our SDE. We typically refrain from hosted layers so that we don't use up our credits. However, if this is the only way to force attribute editing only we could definitely upload this dataset.

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Fri, 02 Feb 2018 20:57:20 GMT

A good summary of editing capability at Online platform. The Smart Editor widget will support related table editing in the coming April release, with better UI/UX. Batch Attribute Editor is under our consideration to edit related records, no timeline yet. As for the Edit widget, the delete button should be disable when geometry update is set to false. We will take a close look. Thanks for your feedback.

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Sat, 03 Feb 2018 04:33:22 GMT

Double check the operations for ArcGIS Server service as shown below. The Update Features operation does not include Delete. So we will make enhancement to disable Delete button when Delete Features is disabled but not Update Features. In your case, make sure disable the Delete Feature operation when publishing the service. In this way, Delete button on Edit should not be able to delete the feature.

Layer: Damage to Commercial Buildings (ID: 0)

Re: Issues with editing related tables in a web map and with widgets in WAB

DamianoMorosi1 — Thu, 29 Mar 2018 07:45:25 GMT

I would like to add that even if you create a 1:1 relationship class, actually the Edit widget let you add more than 1 child object, despite in the service description the property "cardinality" : "esriRelCardinalityOneToOne" is correctly displayed.

Jianxia Song will this be addressed in the upcoming April release of the smart editor? Thanks

Re: Issues with editing related tables in a web map and with widgets in WAB

ÖmerÜNSAL — Thu, 10 Oct 2019 07:53:36 GMT

Hi Jianxia,

We would like to edit m-n related table in wab. What is status for developments?

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Tue, 15 Oct 2019 03:18:34 GMT

The Edit widget supports editing m-n related tables.

Re: Issues with editing related tables in a web map and with widgets in WAB

Amanda__Huber — Wed, 16 Oct 2019 23:02:01 GMT

YES, thank you Tim Confare‌ for starting this thread. This is a constant pain point in our organization as well. Outside of the recent release of the WAB Smart Editor Widget, there is no solution for simply editing related records in the ArcGIS Online platform. This is a problem. As more organizations turn to data collection/editing data with 1:M relationships there needs to be a solution for collecting information in related records tables. Please continue to advocate for the support of related table editing in ArcGIS Online

Re: Issues with editing related tables in a web map and with widgets in WAB

BrettSanders — Wed, 08 Jul 2020 14:17:28 GMT

I am at 10.7.1 and editing is still a mess. It is a royal pain if you have ever tried to use it. I am trying to get an app up and running that allows edits of sign poles and the related signs (table in 1:n relationship class). Absolutely frustrating. From the editing widget, you can't get to the related features. If I have a pole open in the editor popup, I scroll down to the related signs and click on the link, a popup comes up that hangs and never lists the street signs:

If I start with the popup, I can click on the arrow to the right of the related signs, I can get a list of the related records that I can edit one at a time if I know which is which by default (there is a list of related records, but you can't pre-configure what that list looks like...just has 3 lines that say Street Signs.

You can change the attribute shown after the list comes up to an attribute that distinguishes it from the others, such as the UniqueID. If you click on the arrow to the right, ithe editor for that record pops up. After that, you can't get back into it unless you get out of the editor and start again with the pop-up. No moving to another related record. It is basically a hot mess. I thought the smart editor widget was going to be the ticket going forward, but nothing has changed and again, no easy way to use it for related records/Features unless you start with the pop-up, find the right related record and use the smart editor to edit that record only. Also have not found any way to relate another existing record to the feature or to add a new related record. Rinse repeat..........

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Wed, 08 Jul 2020 20:38:42 GMT

Brett, thanks for letting us know. We will look into the workflow you described.

cc to Lemao Wu‌

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Mon, 13 Jul 2020 05:54:10 GMT

Brett, for the first issue of opening a pole in the editor popup, is it possible to share the service so we can take a close look as to why it hangs? We could not reproduce it in 10.7.1 with the testing data. Thanks.

Re: Issues with editing related tables in a web map and with widgets in WAB

BrettSanders — Wed, 15 Jul 2020 13:19:56 GMT

Sorry I have not returned your message, but I have ben busy this week with ESRI UC added to my regular work…If you don’t mind, Friday or very early next week may be a better time.

Thank you,

Cary (Brett) Sanders

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Mon, 20 Jul 2020 23:30:17 GMT

Understand. No rush.

Re: Issues with editing related tables in a web map and with widgets in WAB

AdministrátorJihlava — Wed, 22 Jul 2020 06:11:43 GMT

Hi Jianxia,

I have completely the same issue like Brett. I can't see any option to add a related record in WAB (no matter if I go via Editor widget or via popup). If I click on pencil button after related table row in pop up while editing, the window with loading symbol appears and gets suck and there is no option to come back but close the pop up window and open it again. I suppose there should be at least a plus and edit buttons.

I tried to edit and add a related record into the same table (same service and webmap) through Collector and there is no problem. I can edit existing and even add a new related record.

This is my FeatureServer service URL: ost/Ji_majetek_test (FeatureServer) . Can you please try to check where is the problem?

Thank you in advance

Jane

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Tue, 28 Jul 2020 05:09:08 GMT

Hi Jane,

Thanks for sharing data. I was not able to reproduce the issue with the feature service you provided though. In ArcGIS Online, I created a map with the feature service, then brought the map in Web AppBuilder with Edit widget. It works fine as shown below.

Which browser/version are you using? I use Chrome with the latest version 84.0.4147.89 (Official Build) (64-bit).

Re: Issues with editing related tables in a web map and with widgets in WAB

Beth-AnneLee — Tue, 28 Jul 2020 20:28:19 GMT

I have the exact same issue. I click the edit icon to create a related record and the next window just hangs. No errors in the dev console, portaladmin or server logs. I've tried several hosted feature layers, some created by publishing from ArcGIS Pro, and another created in the Portal using the backflow inspection template.

I'm using ArcGIS Enterprise 10.7.1 in a chrome browser.

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Tue, 28 Jul 2020 21:48:27 GMT

Beth-Anne and Brett, could you please contact Esri Support for the related table editing issue in ArcGIS Enterprise and let me know the case number?

Re: Issues with editing related tables in a web map and with widgets in WAB

Beth-AnneLee — Wed, 29 Jul 2020 20:34:59 GMT

Hi Jianxia. I've logged this with support. The case number is 02603929.

Thanks very much.

Re: Issues with editing related tables in a web map and with widgets in WAB

Jianxia — Thu, 30 Jul 2020 17:41:35 GMT

Thank you! I will follow up.