Solved

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

  • 1 February 2023
  • 2 replies
  • 74 views
T
Rank
Badge +3
  • Tim
  • Sidekick (Customer)
  • 9 replies

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

 

icon

Best answer by Charith Epitawatta 1 February 2023, 19:21

View original

2 replies

T
Rank
Badge +3

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

Charith Epitawatta
Rank
Userlevel 7
Badge +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!

Charith - https://charith.xyz

Reply


Terms & ConditionsCookie settings