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

Outcomes