Skip to main content
Solved

Is it possible to conditionally embed database SID or name in email subject?

  • February 1, 2023
  • 2 replies
  • 119 views

Forum|alt.badge.img+5
  • Sidekick (Customer)

In Apps9, (and going forward with our upgrades) would be good to conditionally alert users when emails from IFS advise if they are from our TEST database. Coming from PROD should be the norm and therefore nothing needed to alert the user. 

 

Just adding DB_SID would not work, as users would ignore it - as it would be present for both PROD and TST.

 

Ideally something like: 

if #DB_SID# like ‘%TST’ then ‘ This message generated from TEST’ Else NULL 

and add this to Subject line.

 

Thanks

 

Best answer by Charith Epitawatta

Hi @Tim,

There is no way to set this up dynamically within IFS as the email body is either just plain text or HTML, which cannot handle this kind of logic.

However, in your Mail Sender, if you set the content type as text/html(or you can simply create a new mail sender for that), you can simply add a warning in HTML in your email body too. 

Eg: 

Mail Sender
Event Action

If you configure the event action as above, the resulting mail body would have the following warning in bold red:

Email body

You would have to add this warning to the email body of all event actions. 

Hope this helps!

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+5
  • Sidekick (Customer)
  • February 1, 2023

By the way - my first use of this is in the out-of-the-box holiday request Event HOLIDAY_REQUEST_STATE_CHANGE.


Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

Hi @Tim,

There is no way to set this up dynamically within IFS as the email body is either just plain text or HTML, which cannot handle this kind of logic.

However, in your Mail Sender, if you set the content type as text/html(or you can simply create a new mail sender for that), you can simply add a warning in HTML in your email body too. 

Eg: 

Mail Sender
Event Action

If you configure the event action as above, the resulting mail body would have the following warning in bold red:

Email body

You would have to add this warning to the email body of all event actions. 

Hope this helps!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings