Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Hello,How can I update a field according to the value of another field. Example: a table with 2 columns COL1 and COL2. After updating my table COL2 will get "CLOSED" as value if COL1 = "DONE"Thank's for your help
Hi,use Before record updated event on the Eventstab for this purpose.Here is a sample:
if ($values["COL1"]=="DONE")$values["COL2"] = "CLOSED";