AnsweredAssumed Answered

Attribute Assistant: Check for Multiple Allowable Values

Question asked by jborgion Champion on Sep 22, 2016
Latest reply on Sep 30, 2016 by jborgion

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