nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update field in all feature which match value

JamesMitchell8

Hi all,

I would like to be able to update all the features which have the same attribute. For example, all features that has a field 'ID' with value 1, i would like all the features to have the field 'Result' updated with 'Yes' when a 'Yes; is entered into 1 feature.

I believe i need to filter the layer but i cant work out how to do this.

Any help would be greatly appreciated.

Encontre mais publicações marcadas com

Accepted answers

All comments

RPGIS

This capability must have been added for Enterprise releases 11.0 and later. We are currently using 10.9.1 which is why I originally thought it wouldn't work. I suppose with later updates that this will be possible.

ZachBodenner

Oh I see what you're saying here. So in Field Maps, this will affect all future additions to the dataset. If you need to do it in batch, then @RPGIS is right, you can't do that in Field Maps and you'll need to use the Field Calculator.

JamesMitchell8

Hi Zach,

I don't understand how that will update all the features in the feature layer which have an id of 1? It looks like it only updates the current feature.

Thank you

James

ZachBodenner

You should absolutely be able to do this in Field Maps. In your form designer, click on the Results atteibute and click calculated expressions. Here's an example from an app of mine:

Then you can basically use the same code that either myself or @RPGIS provided.

RPGIS

This cannot be done in field maps rather it has to be set up as an attribute rule or ran as a field calculation. Field maps is intended for allowing changes to the behavior of the form itself.

JamesMitchell8

Hi,

Thank you, i would like to do this in field maps. When one record 'Result' is updated, i want all the other features 'Result' field to update too where ID = 1.

RPGIS

The other question is are you talking about different features within the same feature class or the same ID in multiple feature classes. If it is the first then a field calculation using @ZachBodenner solution would work.

A simpler way to write @ZachBodenner attribute rule is:

iif( $feature.ID == 1 && $feature.Result != 'YES' , 'YES' , $feature.Result )

But that is assuming that you simply don't want any changes, otherwise you can change $feature.Result to NULL or whatever returned value you want in its place.

If it is the latter then you would need to use an attribute rule for a python script to accomplish that.

ZachBodenner

Are you planning to do this using attribute rules, or a field calculator? An attribute rule might look like

var i = $feature.ID
var r = $feature.Result
// if ID is 1, enter 'Yes' in result, otherwise leave empty)
var resultValue = When(i==1,'Yes','')
return resultValue

If you want to use a field calculator, you would do a Select by Attribute:

WHERE ID = 1 (or, WHERE ID 'is equal to' 1)

Then your attribute table will have only 1's selected, and you can run your field calculator and enter 'Yes' into the value box.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.