Letting users receive email confirmation from profile form sign-ups

Published
2011-02-13 20:18
Written by
xcf33 - member of the CiviCRM community - view blog guidelines

When I first started to use CiviCRM, because of all the functionalities and features. Often overlooked is the fact that there's no confirmation email option for users who completes a profile form.

 

A confirmation email in this case help reinforce the relationship between the organization and its users. As I understand this feature has been sought before and perhaps it is time to bring into CiviCore?

 

A new forum topic for this can be found below:

http://forum.civicrm.org/index.php/topic,18409.msg76483.html
 

Taking a first crack at making this available for the current CiviCRM versions, I have created a module that can be found below:

https://github.com/emotive/CiviCRM-profile-notification

 

The drupal module utilizes current CiviCRM message templates and merge a confirmation message for any profile form for individuals, please let me know if this is useful to you.

 

Any comments and feedback are much appreciated!

 

 

Cheers!

Chang

Filed under

Comments

... as a needed feature. I think it would be a worthwhile addition to core for a future version (4.1?). Perhaps you can post an issue and work on a core version once we migrate current svn/trunk to the 3.4 and 4.0 branches. Thanks for pushing this forward!

Good stuff - thanks for sharing!

I just noticed this in your code

$template_body = db_result(db_query("SELECT msg_html FROM civicrm_msg_template WHERE id = %d", $template_id));

 

If you add curly brackets around the table name drupal will take any table prefixing set in your settings.php into account - handy for anyone downloading it who has table prefixing in place

 

"SELECT msg_html FROM {civicrm_msg_template} WHERE id = %d" 

 

Good point,

 

I can also probably use the civi functions to fetch the table names first since I'm trying to avoid using drupal DB query methods all together for Civi related modules. (If Civi and Drupal are installed on different DBs)

 

 

Thank you, I'll make the appropriate adjustment

Once v3 api is out another option would be to use the api - Xavier is looking into a 'best-guess-get' api which will potentially do a 'get' against any civi table - using a standard piece of code if no api get call exists -  but he's still working through that