Forums

I have searched the forums for an answer to this, but I am unable to figure out exactly what I need to do to accomplish my needs...

I have a chronoform that has a connection action to my table...

In that table, I have put in a text field with the field name of "reviewedOn" and I have successfully utilized the following code in a custom code box above the render html action on the setup page to insert a date into a text field...

<?php
if ( !isset($form->data['reveiwedOn']) || !$form->data['reviewedOn'] ) {
  $form->data['reviewedOn'] = date('Y-m-d');
}
?>

However, the form is a connectivity form, so in order for that date to be saved to the database table, it needs to insert into a field labeled "dvopid[reviewedOn]".

It is at this point that I need help, nothing that I do saves this into the database, so I know there is some trick to this.

I have even tried setting it like this:

<?php
if ( !isset($form->data['dvopid[reveiwedOn]']) || !$form->data['dvopid[reviewedOn]'] ) {
  $form->data['dvopid[reviewedOn]'] = date('Y-m-d');
}
?>

and it doesnt change the field (even when I change the field name to "dvopid[reviewedOn]"

That works now, thank you.