Attribute Assistant: Check for Multiple Allowable Values

1460
4
Jump to solution
09-22-2016 12:32 PM
JoeBorgione
MVP Emeritus

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

That should just about do it....
Tags (2)
0 Kudos
1 Solution

Accepted Solutions
MikeMillerGIS
Esri Frequent Contributor

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.

View solution in original post

4 Replies
MikeMillerGIS
Esri Frequent Contributor

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

MikeMillerGIS
Esri Frequent Contributor

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.

JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos
JoeBorgione
MVP Emeritus

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:

That should just about do it....
0 Kudos