Automated email template based on survey answers

Question

Hi there,

I would like to create a survey in sugarcrm.
Survey will have 10 questions, each question will have different options.

The responses from each user should save in to the sugarcrm database.
Once user replies to the survey (when a record is updated) sugarcrm should automatically create an email template based on response from the user answers and send it to user.

Sample survey:
Question 1: Which color do you like?
a)red
b)green
c)yellow

Question 2: Which fruit do you like?
a) apple
b) orange
c) grapes

Then if user selects different options email template should have different answers.

Email template should update automatically based on the answer and have below text and reply back to the user:
if 1.a is selected then display text1
if 1.b is selected then display text2
if 1.c is selected then display text3
if 2.a is selected then display text4
if 2.b is slected then display text5
if 2.c is selected then display text6

Could anyone advise how can this be achieved?

Thanks!

Manjeet Kaur · Accepted Answer

Hi Manjeet Kaur,

You can create your custom template in sugar.

Firstly prepare an array with your data based on condition like:

function sendemail($data, $user_email, $wp_email) {
$counter = 0;
$end = 2;
$data = array();
while ($counter <= $end) {
$data[] = "counter is " . $counter . " and end is " . $end . "\n";
$counter++;
}
$this->sendMail($data);

}

And then in sendMail function, you can generate your own template by using the HTML tags and populate it with your conditional data like this:

function sendMail($template) {
$emailObj = new Email();
$defaults = $emailObj->getSystemDefaultEmail();
$mail = new SugarPHPMailer();
$mail->setMailerForSystem();
$mail->IsHTML(true);
$mail->From = $defaults['email'];
$mail->FromName = $defaults['name'];

$mail->Subject = "Generate Template by code";

$message = "Hi";
foreach($template as $key =>$value){
$message.= "<p> $value </p>";
}
$mail->Body = $message;

$mail->AddAddress("xyz@gmail.com");

if (!$mail->Send()) {
$GLOBALS['log']->fatal("My custom email template failed");
} else {
$GLOBALS['log']->fatal('email sent');
}
}

$value

"; } $mail->Body = $message; $mail->AddAddress(" xyz@gmail.com "); if (!$mail->Send()) { $GLOBALS['log']->fatal("My custom email template failed"); } else { $GLOBALS['log']->fatal('email sent'); } }