on Sep 22, 2016In 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?
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.