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: Populate Field if NULL

MikeLong

We have a field (EventID) in our database (APDM) that behaves as the unique identifier for each feature . We have used a class extension that would generate a GUID value and populate this field only if the field was NULL. Is it possible to have Attribute Assistant behave in this same fashion? I have tried using the GUID option, the Copy Field option and even the Expression option (IIF [EVENID] is Null, [GlobalID] else "Do Nothing")(this is not the exact expression I used).

Any ideas on how we might be able to do this?

-Mike

Encuentra más publicaciones etiquetadas con

Local

Accepted answers

MikeMillerGIS

You could use the Expression method to detect a null field

try this

IIF(IsNull([EventID]),[GlobalID],[EventID])

All comments

JeremiahMartin

I'm an idiot! That was it. I stared at this forever and didn't catch that.

You rock and thanks for the fast reply!

MikeMillerGIS

It is IIF, not IFF, give that a shot

JeremiahMartin

I have tried the same thing, but I get a Type Mismatch error. Do you know what might cause this?

Row Info
Row Number 29
TableName: Building
FieldName: CityVillage
ValueInfo: IFF(isNull([CityVillage]), [Township], [CityVillage])
ValueMethod: EXPRESSION
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field Name: City Village was found at index: 20
Trying: EXPRESSION
replace field: Township with a value
replace field: CityVillage with a value
replace field: CityVillage with a value
Checking to verify there is a field to store the expression
Expression to be eval: IFF(True, "OAKLAND", "")
ERROR: evaluating the expression for feature in Building with OID of 15859
System.Runtime.InteropServices.COMException (0x800A000D): Type mismatch: 'IFF'
at MSScriptControl.ScriptControlClass.Eval(String Expression)
at ArcGIS4LocalGovernment.AttributeAssistantEditorExtension.SetDynamicValues(IObject inObject, String mode, List`1& ChangeFeatureList, List`1& NewFeatureList, List`1& ChangeFeatureGeoList) in C:\Projects\GitHub\local-government-desktop-addins\Attribute Assistant Add In\AttributeAssistantAddIn\AttributeAssistantEditorExtension.cs:line 12514
Finished: EXPRESSION

MikeLong

Thanks Mike, that worked. I had to make a minor change since the destination is a text field.

IIF(IsNull([EventID]),"[GlobalID]","[EventID]")

-Mike

MikeMillerGIS

You could use the Expression method to detect a null field

try this

IIF(IsNull([EventID]),[GlobalID],[EventID])

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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