This topic is locked

Updating a field

12/27/2010 8:25:20 PM
PHPRunner General questions
P
pidejean author

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

J
Jane 12/28/2010

Hi,
use Before record updated event on the Eventstab for this purpose.

Here is a sample:

if ($values["COL1"]=="DONE")

$values["COL2"] = "CLOSED";