Changing a field value after submit

Also have ChronoConnectivity 5.0.1.

I have created a connection that allows me to enter and edit records. All of that works great, I can go in and edit and save no problem, all of those fields work like I would expect.

The problem is that I also want to track the last date modified. It was working fine when I had it in CF4, but now the modified date is not being updated for some reason. I added a custom code action in the submit event before calling the connectivity action. This is the code I am using -

<?php
$form->data['Location.cf_modified'] = date("Y-m-d H:i:s");
?>

What am i missing?

I think Location.cf_modified is Model.fieldname.. try use only the table field name like this:

<?php
$form->data['cf_modified'] = date("Y-m-d H:i:s");
?>

Hi BNRBranding,

What is the name of the table column? If the table was created in CFV5 then it will probably be 'modified' rather than 'cf_modified'. Could that be the problem?

Bob

The original table was created in CF4, that is the correct column name. I've tried both with and without the model on the field name. I'm pretty sure it needs to be there, I know it's required in the email template. Location.cf_modified works in the email that is sent after submit, but it uses the value from the DB rather than the value I am trying to assign.

Hi BNRBranding;

Please try

<?php
$form->data['Location']['cf_modified'] = date("Y-m-d H:i:s");
?>

Bob

You're 9 minutes late Bob! Thanks though, that is the correct solution.