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.
Question 1: Which color do you like?
Question 2: Which fruit do you like?
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?