topic Re: Edit Related Table Directly in Web App Builder ?? in ArcGIS Web AppBuilder Questions

Edit Related Table Directly in Web App Builder ??

JarrettLivesey1 — Fri, 15 Nov 2019 18:12:02 GMT

Hello all !!

My Organization has a Web App Editor set up for our Police department to edit Traffic data. The data-set has a related table attached to it. I am wondering if it is possible to click a point on the map, using Smart Editor, and have only the Related table come up to be edited (see pic below) ?? The idea is to simplify the process so the Officers don't have to spend the time to find the place where they would enter the new Related table entry.

Thanks for your help.

Jarrett

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Wed, 01 Jul 2020 23:04:49 GMT

Jarrett Livesey

An enhancement in the Smart Editor widget should now allow you to do this.

In the widget configuration, check the box for Expand all related tables/layers on load.

When clicking a feature on the map, the fields for the parent feature will be collapsed and the available related records will be shown expanded. The record itself won't be open, so the user will still need to click on a record to edit it, but this still removes a few clicks for the person editing related records.

Re: Edit Related Table Directly in Web App Builder ??

JarrettLivesey1 — Thu, 02 Jul 2020 15:44:50 GMT

Hi Alix,

Thanks for letting me know about this upgrade !! You’re right it does save some mouse clicks and, perhaps, make it a more intuitive process for the editor.

Thanks again, and all the best.

Jarrett Livesey

GIS Specialist

City of New Berlin, WI

262-797-2445 X 2555

Re: Edit Related Table Directly in Web App Builder ??

SeanLavallee__MES_ — Mon, 11 Jan 2021 14:42:13 GMT

Is this not for ArcGIS Enterprise? We are on 10.8.1

Re: Edit Related Table Directly in Web App Builder ??

HayleighFisher — Fri, 11 Jun 2021 21:32:24 GMT

Hi,

I have a feature service that has related features (points, lines, polygons) and a related table. I am only able to add features the related table via the smart editor, the related features are marked as "update only" however I am able to add features in Field Maps/Collector to these records. Is there a step I am missing to enable these to be editable in the smart editor? Currently it is grayed out-- see screenshot below all the point/line/polygon features say update only with a warning symbol but the table I can edit (add/delete) records from

Thank you,

Hayleigh

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Tue, 15 Jun 2021 16:43:03 GMT

Hi @HayleighFisher ,

The Smart Editor only supports updating related tables (which means you can create new rows in the related table for a given related feature), but does not support creating new related feature geometries.

Re: Edit Related Table Directly in Web App Builder ??

HayleighFisher — Tue, 15 Jun 2021 16:50:04 GMT

Hi,

Thank you for the response. Is there any way to edit (add/delete/update) related feature geometries? Our group wants to be able to not only generated related features in the field but in the office as well via a web application. Perhaps a different widget or workaround?

Thanks,

Hayleigh

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Tue, 15 Jun 2021 18:11:08 GMT

Perhaps the Edit widget will be more appropriate for your workflow as it will allow you to edit the geometry of a related feature from its source feature?

For example below, if I click to edit the Line layer, the related point feature is listed in the edit pop-up.

And if I click through, I can now edit the point feature.

Re: Edit Related Table Directly in Web App Builder ??

HayleighFisher — Tue, 15 Jun 2021 18:21:49 GMT

Hi,

Thanks again for the quick response. I will take a deeper look into the edit widget, however it is not very user friendly or intuitive to get to those related features and I believe you can't add new records. Do you know if there is any plans to enhance the smart editor to allow related feature creation? Or if this can be customized via the widget code? Our users are looking for a editing experience similar to field maps/collector-- create a main record, then add related records easily and quickly.

Thanks again for your help,

Hayleigh

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Tue, 15 Jun 2021 18:34:02 GMT

We are aware this capability is missing but it is not currently in the project plan since development is starting to focus on the next generation editor for Experience Builder where new capabilities will be provided over time. If this changes, I will make sure to let you know. You are welcome to expand the Smart Editor widget as a custom widget for your needs with WebAppbuilder Developer Edition. You would need to expand the widget code to provide the capability to create new related features directly from an existing feature's attribute inspector.

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Tue, 15 Jun 2021 18:48:29 GMT

There is one more capability in Smart Editor that may be useful though. It's not exactly the workflow you require, but it could be considered:

If the related features you are creating are intersecting (directly on top or within a distance) with the source feature, you could setup an Intersection attribute action that would grab the key identifier so the features will be automatically related without having to manually enter that key?

In this case, new related features can be created using the main template picker like shown in my example below. If there are multiple features intersected, you can enable the Value Picker option so the user can select which feature to related with (by selecting the key value).

Re: Edit Related Table Directly in Web App Builder ??

KumuduDesilva — Mon, 06 Nov 2023 21:33:37 GMT

Hi,

Why is it not allowed to turn off relate table update only function on smart editor?

Re: Edit Related Table Directly in Web App Builder ??

AlixVezina — Mon, 06 Nov 2023 21:36:36 GMT

Hi @KumuduDesilva , I am not sure I understand your question. Please would you be able to explain in more detail and perhaps illustrate what you are trying to do? Thank you!

Re: Edit Related Table Directly in Web App Builder ??

KumuduDesilva — Mon, 06 Nov 2023 22:39:37 GMT

I was able to resolve the issue. Thank you very much.