Email notifications based on the user's language

[UPASANA2]

How do I create email notifications based on the user's language?

[rathbone]

        This post is a little old but I had the same question and could not find any good solution online so this is what I did. Hopefully this helps someone else or sparks more thoughts from others on how to do something better.   This works well as long as all the recipients are receiving it in the same language.   If you have multiple users being sent the email but they have different languages something else needs to be done.   In this example it is for an approval email so there is only one recipient.

        I couldn't find an out of the box script that lets me pass in the column name and language and return the needed column label.   If there is one, let me know because I am curious if there is one.   Since I couldn't find one I created a "Script Include called GetDictionaryLabelsByLanguage.   After creating the script include create a Notification Email Script (see also the attached file).   if you have a custom table you will have to add the translated versions of the column labels in the sys_documentation table.

Hopefully it helps someone.   Then if anyone has a way to take it a step further and figure out away to loop through the email notification and group recipients based on language so that I only have to support one version of an email notification that would be great