AnsweredAssumed Answered

Advance to next value in list

Question asked by danhmill on Dec 1, 2010
Latest reply on Dec 1, 2010 by danhmill


Advance to next value in list


Hello all new to FM and this forum. I know this is relatively easy (I think?), but I can't find the fix, and I've googled until my fingers bleed but still can't seem to find a solution (my terminology may be off?). Anyway I have a value list (text) which I use to populate a Field One. I have a second field (Field Two) that needs to calculate (thus display) the next value in the list. Ex:

Value list = Red, Green, Orange, Blue, Black

Field One (user has selected Green from dropdown list) = Green

Field Two (needs to calculate next value in list) = Orange

Any/all help appreciated.