I am currently working with a field in SugarCRM, which should be a calculated value according to the following criteria:
What I am currently doing is working with ifElse in the following way:
ifElse(equal($intk_concepto_des,"Operario"),
ifElse(equal($intk_zonadetallada_des,"distrito 1"),7574,
ifElse(equal($intk_zonadetallada_des,"distrito 2"),6457,
ifElse(equal($intk_zonadetallada_des,"distrito 3"),7079,
ifElse(equal($intk_zonadetallada_des,"distrito 4"),7079,
ifElse(equal($intk_zonadetallada_des,"distrito 5"),7782,
ifElse(equal($intk_zonadetallada_des,"distrito 6"),7186,
ifElse(equal($intk_zonadetallada_des,"distrito 7"),6443,
ifElse(equal($intk_zonadetallada_des,"distrito 8"),6659,
ifElse(equal($intk_zonadetallada_des,"distrito 9"),6982,
ifElse(equal($intk_zonadetallada_des,"distrito 10"),6843,
ifElse(equal($intk_zonadetallada_des,"distrito 11"),6240,
ifElse(equal($intk_zonadetallada_des,"distrito 12"),5837,
ifElse(equal($intk_zonadetallada_des,"distrito 13"),6240))))))))))))),
ifElse(equal(intk_concepto_des,"Montacarguista"),
Is there some type of switch to be able to do the whole validation process in a faster way?