Where does the email code go?

Hi,

I'm trying to include the cf_id in the confirmation email as a reference number. From searching the forums, I've found this:

My form is called Xtra_Dog_Returns
My database table is called jos_chronoforms_Xtra_Dog_Returns

$cf_id = $MyForm->tablerow["jos_chronoforms_my_form_name"]->cf_id;

I customise that line to read:

$cf_id = $Xtra_Dog_Returns->tablerow["jos_chronoforms_Xtra_Dog_Returns"]->cf_id;

But, where do I put it? I'm guessing it needs to be inside <?php ?> tags, but I'm not sure where it should go...

By putting it in this place, I presume I can then include it on the final confirmation page shown after having submitted the form?

Thanks,

Matt

Hi Matt,

It is close to impossible to get this into the email simply because of the work-flow sequence of the current version of ChronoForms.

I prefer to use a random string as an identifier that you can create in the OnSubmit Before Email box and them include in the email and save in the database table. The code for doing this is in this extract from The ChronoForms Book.

Bob

PS If you need to get the cf_id then the code does indeed belong in <?php ?> tags. It usually goes in the OnSubmit After Email box, and then you need to set the Run Order so that the AutoGenerated Code (the DB Connection) runs first before the OnSubmit code.