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; } } }

Attribute Assistant

GIS_geek

I am trying to set a condition using Attribute Assistant. I have a feature layer (GPS_Meter) with a field called SYSTEM. The SYSTEM field is populated with Potable, Non-Potable, and Sewer. I am trying to auto populate another field (UID) with either DW, RW, or SS and the OBJECTID. I have the following populated in the DynamicValue table,

Table Name: GPS_Meter

Field Name: UID

Value Method: EXPRESSION

Value Info: IIF([SYSTEM]=Potable, "DW", IIF([SYSTEM]=Non-Potable, "RW", IIF([SYSTEM]=Sewer, "SS"))) & [OBJECTID]

I run AA for selected GPS_Meter points and the UID field does not get populated. Any help will be greatly appreciated.

Trouver plus de publications taguées avec

Stormwater

Wastewater

Water Distribution

Accepted answers

GIS_geek

Thank you all for your help. I had the last part of the IIF statement incorrect. I removed the IIF([SYSTEM]="Sewer" and it worked. Below is the updated expression

IIF([SYSTEM]="Potable", "DW", IIF([SYSTEM]="Non-Potable", "RW", "SS")) & [OBJECTID]

All comments

GIS_geek

Thank you all for your help. I had the last part of the IIF statement incorrect. I removed the IIF([SYSTEM]="Sewer" and it worked. Below is the updated expression

IIF([SYSTEM]="Potable", "DW", IIF([SYSTEM]="Non-Potable", "RW", "SS")) & [OBJECTID]

MikeMillerGIS

IIF was monkeypatched in the msscriptcontrol. I believe you need to do & inside it. I have never tested this. The logic may not work and you might need a second expression statement that fires after this one. Which is <The Edited Field> & [OBJECTID]

IIF([SYSTEM]=Potable, "DW" & [OBJECTID], IIF([SYSTEM]=Non-Potable, "RW" & [OBJECTID], IIF([SYSTEM]=Sewer, "SS" & [OBJECTID])))

GIS_geek

Paul,

Thanks for the reply. It is a text field. I added the quotes and still getting no results. The UID field does not get populated.

PaulLeBlanc1

Is the SYSTEM field text? You'll need to enclose the values in quotes:

IIF([SYSTEM]="Potable", "DW", IIF([SYSTEM]="Non-Potable", "RW", IIF([SYSTEM]="Sewer", "SS"))) & [OBJECTID]

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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