change value of another field when one field is being entered

Evan,
you can do it using Before record added or Before record updated event on the Events tab.

Here is a sample:

if ($values["SerialNumber"]!="")

where SerialNumber and Checkbox are your actual field names.

Evan,

Hello I have a similar problem and wonder if you could expand on the code a little. I am trying to get it so when someone leaves a dealt with comment the dealt with date, and dealt with time fields will automatically be updated with the date (thinking with the now()) and time... but really dont know how to go about this. As this ticket was the only one close to what I was searching for I thought I would ask here. Many thanks.
Got it working now thanks

Evan,

Hi,

I was wondering if changing the values means the fields will be updated or the user will have to refresh or something?

Thanks,

Evan

Evan,
this code write values to the database after you click on the Save button.
If you want to change values on the fly open generated include/commonfunction.php file and edit BuildEditControl function.

Evan,

Hi Jane,
Thanks for the tip but what does "on the fly" mean? also, what should I change or edit inside the BuildEditControl?
Thanks,

Evan

Evan,
to change values on the fly, i.e. change values on the Add/Edit page before saving you need to add some JavaScript code to the BuildEditControl function in the include/commonfunctions.php file.

Unfortunately we don't have a ready to go solution for this.

you can do it using Before record added or Before record updated event on the Events tab.

Here is a sample:

where SerialNumber and Checkbox are your actual field names.

[/quote]
Sorry to revive an old post but it is the closest to what I need

I need to check a value if yes then change a date to now()

and add one to another value

I have tried
Before Record Updated

if ($values["resend"]!= 1)

$values["intern_post_date"]= now();

$values["intern_renewed"]=+1;
Did not change the date, first time entered 1 for interned_renewed.
What am I doing wrong??

Thanks

Lori,
try to use this code:

if ($values["resend"]!= 1)

Lori,

The value for intern_renewed is still not adding any other feild is changing

I have reset intern_expired to 0

but it does not add 1 to intern_renewed <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=21255&image=1&table=forumreplies' class='bbcemoticon' alt='<<' />

First of all you need to print $values["resend"] value on the web page.

This can help you find what is wrong:
echo $values["resend"];

First of all you need to print $values["resend"] value on the web page.

The Value of ["resend"]; is one but I am getting no value for ["job_renewed"]
Even if it shows as 2 it turns it back to one.

I have discovered if I have it as a read only field (as they are not to change it ) it can not read it.

If I change it to a text field it works fine!
Bug?

Lori,
if intern_renewed field is readonly use this code:

if ($values["resend"]!= 1)

if ($values["resend"]!= 1)

{

$values["job_post_date"]= date("Y-m-d");

$values["job_renewed"]= $oldvalues["intern_renewed"]+1;

$values["job_okayed"]=0;

$values["job_expired"]=0;

$values["j_time"]=now();

}
Still no luck - echo $oldvalues["intern_renewed"] says 0??

All other values are what I expect. It's resetting J_okd to 0,job_expired to 0, post date to today....
Lori <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=21306&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

Lori,
$oldvalues["intern_renewed"] contains current intern_renewedfield value.

Not really sure what is your problem here.