onAfterProcess does not update

[bruno123]

Sorry, probably wrong somewhere, but I put in Form Php Plugin onAfterProcess some code and nothing was update.
I simple put:
$formModel->updateFormData('tableelement___fieldelement', 'string value', true);
but after insert new record from form the field elemet was blank.

I start from this thread (because I want ID) and make more test but nothing:
http://fabrikar.com/forums/index.ph...w-id-on-calc-in-new-record.32813/#post-167571

Can you help me?

 

[troester]

updateFormData is updating the form data.
onAfterProcess is running "end of form submission" and "after data stored", so the form data won't be accessed at all.
onAfter Process you must update directly into the database.

 

[bruno123]

Ok, I use the suggestion on that post:

$rowid = $formModel->getRowId();
if (!empty($rowid)) {
   $db = JFactory::getDBO();
   $newNumber = "ECR-" . $rowid;
   $query = $db->getQuery(true);
   $query->update('eng_eco_request')->set("number = '$newNumber'")->where("id = $rowid");
   $db->setQuery($query);
   $db->query();
}

and obviously changed the table and field name.

I also test it removing the "where" condition but nothing change non my field.

 

[bruno123]

I found that the update fails because $rowid is always empty. I test with this 2 method:
$rowid=$formModel->getRowId();
or
$rowid=$formModel->_formData[id];

 

[bruno123]

Sorry, I solved with this line:
$rowid= JArrayHelper::getValue($formModel->formData,'rowid','');