2 Replies Latest reply: Sep 5, 2013 8:04 AM by Lasse Rolstad RSS

    Create field based on other fields

      Hei,

       

      Is it possible to create a new field based on the value of other fields?

      Basically i want to cross reference different fields and return some category.

       

      if(field1 == "1" and field2=="2") Category = "C1"

      else if(field3 == "test") Category = "c2"

      else

           Category = "C3" (all others)

       

      Please don't hesitate to ask if i am being unclear.

       

      Best Regards,

      Lasse Rolstad