Jump to content
  • 0

Return different text in email notice in reponse to answer in form


abitaquest
 Share

Question

Hi, all.  I'm looking for help customizing the email notifications that go to the user after form submissions. I want different users to get different email contents, depending on how they answered a question in the form.

For example, if one of the fields asks the user to select a year (2022 or 2023), then the email the user receives would say something like, "Thanks for signing up for the 2022 event. Here is a list of sponsors for 2022" ... followed by the sponsors for that year. But if 2023, were selected, the user would then see a completely different set of sponsors, specific to that year. (I know how to display only the year that was chosen in the form, since that's just a straight insert.)

Thanks in advance!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi @abitaquest,

You can further customize email messages if you instead use Triggered Action on a table where you are submitting a new record.

You can run action on 'Insert data', and define different messages depending on some condition (in your case, year). It should look something like this:

 

email trigger.png

Link to comment
Share on other sites

  • 0

If you need to pull up  a list of records from another table based on the submission then you'll probably need to use a triggered action as mentioned by @KlisaN137

You can either manually type your sponsor list like what he did in the screenshot or you can put it in a table and have one column for the year and another for the sponsors like this:
image.png.43b6cf6511b5d97f849adb8e21b800bc.png
Then on the triggered action, use a table variable to get the filtered list by joining #inserted and the sponsor table using the Year field.

image.png.3fee668850d334a0d6aad24d1cafb772.png

Then you'll use that variable in the message body to return the list. But one thing is that it gets the table header. That's why I put a <table> tag for it so it will look like a proper table and you can distinguish the table header from the results.
image.png.a0dc576122f05345272703d84edfd5e8.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...