Retain FacilityID Value when Creating Records if Not Null

drWood — Fri, 04 Aug 2023 14:59:43 GMT

Hello all,

I am trying to update my attribute rule for calculating object FacilityIDs to retain existing values of FacilityID when appending data rather than creating a new one each time. Any help would be much appreciated. I have tried using the IsEmpty function with no avail.

//Assign initial FacilityID value to variable FID var IdSeq = NextSequenceValue("esSeq1") var FID = "ES_" + text(Date(), "MMDDYYYY_") + IdSeq; //Test first sequence value if(IdSeq<=100010){ return FID} else {IdSeq = NextSequenceValue("esSeq2"); FID = "ES_" + text(Date(), "MMDDYYYY_") + IdSeq}; //Test second sequence value if necessary if(IdSeq<=100010){ return FID} else {FID = "Update Attribute Rule"; return FID};

Re: Retain FacilityID Value when Creating Records if Not Null

RichlandGIS — Mon, 07 Aug 2023 20:55:03 GMT

Did you try Not is empty (!IsEmpty)?

The following will return the existing FacilityID if it exists, if not, moves on to the else block (assuming the FID field is named 'FacilityID').

if (!IsEmpty($feature.FacilityID)){ return $feature.FacilityID } else{ // get and assign new sequence here }

topic Retain FacilityID Value when Creating Records if Not Null in ArcGIS Pro Questions

Retain FacilityID Value when Creating Records if Not Null

Re: Retain FacilityID Value when Creating Records if Not Null