Select to view content in your preferred language

Restrict editing to related table only in Feature Layer settings

1474
9
06-11-2024 09:23 AM
Status: Open
Zrobinson_SFPUC
Occasional Contributor

This idea stems from this post in the Esri Community: Re: Restrict editing to related record only; not a... - Page 2 - Esri Community

There are editing workflows in our organization that require the ability for field workers to add, update, and delete related records that have been joined to a parent feature layer. However, we do not want users to be able to add, update, or delete the parent features. 

For example, we have a layer for water pipes and a related table for field observations related to the pipes. We publish the water pipes layer with a relationship class to the observation table to Portal. But the edit settings for a Feature Layer apply to both the parent features and the related table. This makes it possible for field workers to create and delete water pipes which is not what we want them to be able to do. 

This idea is to allow for more fine-grain editing controls between parent features and related tables so that users can edit related records but not the related parent features. 

9 Comments
HeatherBell

This is critical for our workflow with our nature based solutions inspections in Field Maps. It's a real issue and we need to split out the editing capabilities between the parent and related table which used to be possible with the classic map viewer, but would be better handled through the layer settings. Thanks!

Heather GIS Analyst @The Rivers Trust

StefanUseldinger

It is also critical for us, the capital of Luxembourg.

Geraldine

We also need this. Amanda's workaround in https://community.esri.com/t5/arcgis-field-maps-questions/restrict-editing-to-related-record-only-no... is very creative but not a clean option, sorry

HanRit
by

Very much needed for City of Milwaukee, as well.

CharlesPetersen

Also very much needed here. It is amazing that this is not possible as of now.

apgis16

I have a survey123 layer with a repeatable section in it (which produces the related table in the hosted feature layer). I have URL parameters in a text element in the popup for the user to click on the link and open up the form in S123. However, it still technically lets the user add to the related table in Field Maps even when i don't have it show in the form or in the templates that I configured in the web map. I don't want the user to be able to edit the related table through that way, is there a way to hide it?

SarahSaint-Ruth

Hi everyone,

There is a setting in the Map Viewer under Properties where you can disable editing per layer. If you select the parent layer, open the Properties there is a toggle to disable editing. To speed up editing in Field Maps I'd also recommend using the Related Record popup element on the parent feature:

SarahSaintRuth_0-1764949268027.png

Doc for ArcGIS Online 
Doc for ArcGIS Enterprise

Can I confirm whether the settings at the map level satisfy the requirements you have?

CWKAdmin

@SarahSaint-Ruth Do you not need to be able to edit the layer in order to edit that layer's related tables?  Did you test this workflow?  Ex. I have asset layer and its related maintenance table published for field data collection.   I do not want the field worker to update the asset geometry or attribution.  But they have to select this in order to generate a related maintenance record.  This is what I need to have them edit.

SarahSaint-Ruth

You would have the services as editable, and then disable editing of your asset layer in the map. When you open it in Field Maps teams will be able to select an asset and view, edit and add new maintenance records. I did test, the behaviour was as described. 

Please let me know if this doesn't behave how you would expect.