ChronoEngine Forums
Welcome, Guest
Please Login or Register.    Lost Password?
ChronoEngine Forums ChronoForms Forums How To
Re:Insert cf_id into the response email (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Insert cf_id into the response email
#1400
GreyHead (Admin)
Admin
Posts: 2145
graph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 44  
Hi ws,

Try putting this code in the 'On Submit code - before sending email' field (remember to replace 'jos_chronoforms_nn' with the name of your particular form table):
Code:
<? $cf_id = 0; $tablename = "jos_chronoforms_nn"; $query = "SHOW TABLE STATUS LIKE '$tablename'"; $result = mysql_query($query) or die ( "Query failed: " . mysql_error() . " " . $query ); $row = mysql_fetch_assoc($result); $cf_id = $row['Auto_increment']; ?>
The you can use
Code:
<?php echo $cf_id ?>
in your email template. Note that this bypasses the Joomla database handler and requires that you find the mysql tablename e.g. jos_chronoforms_nn' instead of the Joomla version '#__chronoforms_nn'. Bob<br><br>Post edited by: GreyHead, at: 2007/07/26 10:04
 
Report to moderator   Logged Logged  
 
Bob Janes
info at greyhead.net
ChronoForms Support If you like ChronoForms please vote or post a review at Joomla.org
  The administrator has disabled public write access.
#1408
websavages1 (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 0  
Oops can't delete a reply. I didn't read the reply on the second page. I'll give it a go today (overnight your time)

Cheers ws<br><br>Post edited by: websavages1, at: 2007/07/26 02:46
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1411
websavages1 (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 0  
No joy, the email source contains the php code un parsed.

Cheers ws
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1413
GreyHead (Admin)
Admin
Posts: 2145
graph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 44  
Hi ws,

I'm not sure if you're replying to my post or Max's. I'm hoping that it's Max's as mine *should* give you what you want.

Bob
 
Report to moderator   Logged Logged  
 
Bob Janes
info at greyhead.net
ChronoForms Support If you like ChronoForms please vote or post a review at Joomla.org
  The administrator has disabled public write access.
#1439
websavages1 (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 0  
I tried both methods and agree that yours should give me what I need, however the email being received by the email client has the &lt;?php echo $cf_id; ?&gt; code (unparsed) in it.

Code:
&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot;&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;&lt;/title&gt; &lt;base href=&quot;http://www.xxxxxxxxxxxxx.au/&quot; /&gt; &lt;style type=&quot;text/css&quot;&gt; &lt;/style&gt; &lt;/head&gt; &lt;body&gt; sfff has submitted the following High service request.&lt;br /&gt; sfff would like to instigate &quot;fff&quot; with the following scope:&lt;br /&gt; sddfs &lt;br /&gt; &lt;br /&gt; and the reason for this is:&lt;br /&gt; fsdfsdsdfsd &lt;br /&gt; &lt;br /&gt; This request was submitted on the 27th of July 2007 and has been assigned as Service Request Number (SRN): &lt;?php echo $cf_id; ?&gt; &lt;/body&gt; &lt;/html&gt;
With the following as my email template
Code:
{requestorName} has submitted the following {priority} service request.&lt;br /&gt; {requestorName} would like to instigate &quot;{projectName}&quot; with the following scope:&lt;br /&gt; {scope} &lt;br /&gt; &lt;br /&gt; and the reason for this is:&lt;br /&gt; {benefit} &lt;br /&gt; &lt;br /&gt; This request was submitted on the {date} and has been assigned as Service Request Number (SRN): &lt;?php echo $cf_id; ?&gt;
Post edited by: websavages1, at: 2007/07/27 01:43 Post edited by: websavages1, at: 2007/07/27 01:44<br><br>Post edited by: websavages1, at: 2007/07/27 01:44
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1440
admin (Admin)
Admin
Posts: 1474
graphgraph
User Offline Click here to see the profile of this user
Re:Insert cf_id into the response email 9 Months, 3 Weeks ago Karma: 22  
Hi websavages1,

Thats fine yes because the email template will be parsed as a string only, so basically I see no way to obtain the cf_id value in the email with the current release of CF, we plan a very soon release and I will really try to include this feature in it, how much time you can wait ?

Cheers

Max
 
Report to moderator   Logged Logged  
 
ChronoForms Developer Thanks for using ChronoForms.
If you have any problems with ChronoForms please tell us.
If you need Registration or profile forms and more then you can try ChronoForms V2.3.8 or up with the new plugins
If you like ChronoForms please vote or post a review at Joomla.org
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 


equalheight If you have any questions you can post to our forums and we will be glad to help ASAP

Members Login






Lost Password?
No account yet? Register

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by ChronoEngine.com

ChronoForms License

equalheightTo be able to continue working at this component we decided to get a small profit out of it but at the same time don't force everybody to pay in order to use this great component.

 

 From version 1.5 and up a link at the bottom of everyform created will be placed, saying "joomla professional work", the link will be to us here htttp://www.chronoengine.com, its illegal to remove this link from the source code unless you have a license,

so the license is very simply for the same ChronoForms component without a link, thats all!

This License is for 5 different websites ONLY. 

 

 However, in order to allow everybody to still use the component and even get out of this, the link is inside a div with class : chronoform , use this to hide the link by using different colors or whatever if you really can't pay, but of course the link is still exists at your page source.

 

The license is ONLY 25$ can be bought here :

 

Thank you!

 

ChronoEngine.com Team 

2007 © ChronoEngine.com

Joomla Modules
Joomla Templates and Joomla Tutorials