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

    Create field based on other fields



      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"


           Category = "C3" (all others)


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


      Best Regards,

      Lasse Rolstad