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?
Solved! Go to Solution.
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.
Validate Attribute Look up to the rescue - Validation - Attribute Assistant | ArcGIS Solutions
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.
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.
(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: