Latest Contributions by DarrenLacina1

IIF and IsNull...have reviewed a number of posts here but I am having issues getting my scripting to work.  I am trying to build a rule to populate a Name field based on values in one of a number of other fields, if there are non-null values in one of the other fields.  For the first test I am including one IIF statement.  If PARCELID is not null, I want to populate the Name field with it's value.  Here is the syntax that is not working: IIF(IsNull([PARCELID]),Nothing,[PARCELID]) Here is the info from the AA log: Row Info Row Number 2 TableName: ParcelFabric_Parcels FieldName: Name ValueInfo: IIF(IsNull([PARCELID]),Nothing,[PARCELID]) ValueMethod: FIELD On Create: 0 On Change: 0 Checking for Subtype Restriction Field Name: Name was found at index: 3 Trying: Field IIF(IsNull([PARCELID]),Nothing,[PARCELID]) is not found Finished: Field Instead of Nothing in the scripting, I have also tried Null and "<Null>". I am using ArcGIS 10.4.1, SQL Server 2014, Attribute Assistant 2017.3.1 Any suggestions? ... View more