topic Re: Attribute Assistant: Check for Multiple Allowable Values in State & Local Government Questions

Attribute Assistant: Check for Multiple Allowable Values

JoeBorgione — Thu, 22 Sep 2016 19:32:49 GMT

In an earlier thread, ( IIF function in Dynamic Value table ) Jennifer Stone‌ discusses a rather long, nested IIF statement she was wrestling with to update a numeric column based on a entered city name. She has since gone on to win that match!

I have a similar but slightly different situation: rather than update a field based on another field's value, I need to check the value of a field to see if the entered value is valid with respect to the entered (earlier in the workflow) value of another field.

Lets say I have 3 city codes, A, B, & C. Each of these cities have a list of allowable zip code values associated with them:

City Zip(s)

A 84120, 84121, 84123

B 84020

C 84124, 84125

The city code is entered before the zip code.

The idea is to have the editor enter the values as (s)he goes along, but, if for example, city A is entered and 84020 is entered as the zip code, we get an error.

Can Attribute Assistant be used to check for errors in data entry? Or is this more of a task for the Data Reviewer extension?

Michael Miller‌

Re: Attribute Assistant: Check for Multiple Allowable Values

MikeMillerGIS — Thu, 22 Sep 2016 20:21:05 GMT

Validate Attribute Look up to the rescue - Validation - Attribute Assistant | ArcGIS Solutions

Re: Attribute Assistant: Check for Multiple Allowable Values

MikeMillerGIS — Thu, 22 Sep 2016 20:22:10 GMT

Can you create a table with two columns? One for the zips and one for the town? The rule will use the town to look up the valid zips and reject an invalid one and present a dialog for valid ones.

Re: Attribute Assistant: Check for Multiple Allowable Values

JoeBorgione — Thu, 22 Sep 2016 20:39:01 GMT

Coool... I'll take a look at this right now! Thanks Michael!

edited sometime later:

The VALIDATE_ATTRIBUTES_LOOKUP method is the bomb. Not only can I do this for zip codes, but ESN's as well.

Michael Miller‌

Re: Attribute Assistant: Check for Multiple Allowable Values

JoeBorgione — Fri, 30 Sep 2016 17:05:41 GMT

Michael Miller‌

(Back to this project a week later....)

At least I thought it was the bomb; I was only running the rule by selecting an existing record and the rule. When I add a new record (On Create = True), it pops up a window prompting me for a city code if choose Select I'm able to add a record. Not sure what that's about:

But if I choose Cancel and try continue adding a new record it fails with this pop up:

I have several other rules that I've given the weight of 999 to and this one I given a weight of 1. When I actually do add a record and subsequent data to the other fields, all my rules work and this rule works when I add a CityCode and an incorrect ESN: