'If condition' in email generation rules

[Sri]

Hi Community,

Can I use 'If condition' while generating an email. For example in the below screen

Can I write...

If users.country EQ 'AU',

concatenate users.firstname and '@abc.com.au'

elseif users.country EQ 'NZ',

concatenate users.firstname and '@abc.com.nz'

endif.

If this won't work what's the other alternative to implement this scenario.

[rushikeshvartak]

Use case when then

https://www.w3schools.com/sql/sql_case.asp

[Sri]

Thanks Rushi.

Can I write those sql statements in that advanced query field?

[rushikeshvartak]

Yes

[rushikeshvartak · Accepted solution]

https://forums.saviynt.com/t5/general-discussions/email-generation-rule-error/m-p/2999#M1137

[Sri]

Thanks Rushikesh.