AnsweredAssumed Answered

Automated email template based on survey answers

Question asked by Manjeet Kaur on Nov 17, 2019
Latest reply on Dec 1, 2019 by Maryam Aslam

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?


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?