[solved] cf_id in mail message after form submit/saved to DB

Hi,

Chronoforms: v3.2

One form that saves data when submitted and also two emails are being sent.
One to admin (TO) and one the guest user who filled in the form(Dynamic TO).
I put in the second mail (to the user) a link in the message and I'd like to send the cf_id of the table in the link instead of the email.
So now I put in the mail message the following:

http://www.domain.com/index.php?option=com_content&view=article&id=47&Itemid=54&email={email}

Is there a way to get the cf_id of the just submitted form?

Thanks.

Hi SAGO,

Did you check the forums before asking? I think this has been asked at least twenty times before, maybe fifty or more. See this post for example.

Bob

Hi Bob,

I did search in the question & answers section but cf_id get's filtered away and ignored so I couldn't get a result that had to with what I was looking for.

I have to admit that I forgot about the how to section since I'm used to check this questions & answers.

Thanks

Here are the steps again for those that need it:
1 in Setup Emails turn 'Use Template' off and apply and the email properties
2 use the follwing code:

<?php
$MyForm =& CFChronoForm::getInstance('db1_form');
$cf_id = $MyForm->tablerow['jos_chronoforms_db1_form']->cf_id;
echo "<p>$cf_id</p>";
?>

3 Under DB CONNECTION Tab -> Saving Data/Emails order: Before Email
4 Under RunOrder tab -> Order of Autogenerated block to for example 2 and Order of OnSubmit block to 3

Hope I didn't forget something.

Cheers

I am tying to set this up in CF 3.2 I don't see where I can do Step 1

I don't see a place to Turn Off "Use Templates"

...and one quick question here. I am receiving the form information in an email, will this process simple add the cf_id to that same email?

Thanks for any help.

Hi riceman,

a) In the Email Setup | Properties box

b) Yes

Bob

Thanks, working now, with two emails.

One with Submitted info using a template and Another with just the ID

Is there a way to combine these into one email?

Hi riceman,

Yes, add the id to the form data

<?php
$cf_id = . . . // whatever code you now have
JRequest::setVar('cf_id', $cf_id);
?>

and put {cf_id } into the template.

Bob

Greyhead,

Do you mean the Form HTML in the Form Code tab,

or maybe the On Submit code...before sending?

Hi riceman,

Not the form HTML. I think it has to be the On Submit Before email box and the DB Connection set to Before Email. If you search the forums you'll find several threads on this with more detail.

Bob

Sorry to bug you on this, but searches for cfid, cf_id, and cf are turning up nothing.

This is my code in the On Submit Before: (the second bit is working, I just included it here in case having both is an issue) I also have Save Data/Emails in DB Connection set to "Before".

Now I'm not getting the cf_id, I have also tried the code below without the

echo $cf_id;

<?php
$MyForm =& CFChronoForm::getInstance('PropertySubmissionMobile');
$cf_id = $MyForm->tablerow['jos_chronoforms_PropertySubmissionMobile']->cf_id;
echo $cf_id;
JRequest::setVar('cf_id', $cf_id);
?>    
<?php
$fname = JRequest::getString('full_name', '', 'post');
$mls = JRequest::getString('mls','','post');
JRequest::setVar('subject_propsub', 'P-Submit - '.$fname.' '.$mls');
?>

Hi Riceman,

here's one

Bob

Thanks,

yes, i saw this one earlier through a link. I wish my search for cf_id would give me results so I don't have to keep bugging you. The post you referred to helped me get it functioning with two emails.

One, with the template, that sends all the form info
Two, without the template that sends the cf_id. Fortunately the Dynamic subject allows me to keep the two together when they come in to my inbox.

If this is the only solution, it will work for now. But it would be great to get it all working in one email, the email with the template, or at-least with all the form information in a sensible format. The template is not necessary.

Aloha,

Just wanted to know if I should be expecting an answer. I am still having to do this with TWO email, as I said in the post above. And have not found another post explaining how to combine these into ONE email. Again, I am on CFv3.2.

Thanks for any help

Hi Riceman,

Well it's still here in an open tab so you may get a reply. The problem I have is that there is always a backlog and never enough hours and so the more complicated questions especially the ones that have already been answered several times tend to get left until later. It hasn't helped that the new release has more than doubled the number of posts; and I have some paying client work to fit in somewhere as well.

To get a better search try the ChronoSearch link from the Tutorials menu above - it goes to a custom Google search that is the one I use to try to find things here.

From the post I linked to - you need to add the PHP to the Email template. The OnSubmit Before Email box is evaluated too early (sorry I got this wrong in my previous post here).

Bob

Thank Greyhead,

and my apologies, I didn't understand that I could style and included the form values with html in the Email (without the template). So everything is working now.

Here is a short sample for anyone else:

<strong>CF_ID -</strong> <?php
$MyForm =& CFChronoForm::getInstance('PropertySub');
$cf_id = $MyForm->tablerow['jos_chronoforms_PropertySub']->cf_id;
echo $cf_id;
?><br /><br />
<strong>Full Name -</strong> {full_name}<br />

Works Perfectly Now!