2 Replies Latest reply on Dec 1, 2010 12:50 PM by danhmill

    Advance to next value in list



      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.