Email generation

[Vinit556]

Hello,

I have a requirement of generating unique email addresses. Here are the conditions:

1) For all the users first name and last is coming from HR data. Hence email should be:

   <firstname_lastname>@domain.com

    If user/email already exist, it should do auto increment.

2) For some of the users last name is coming as "." Hence email should be:

  <firstname>@domain.com

  If user/email already exist, it should do auto increment.

I have tried advance query, but it is not working

Any idea on it?

[rushikeshvartak]

Can you share query you tried

[Vinit556]

case when (users.lastname='.') then concat(users.firstname+1,'@dummy.com') else concat(users.firstname,'_',users.lastname+1,'@dummy.com') end

[rushikeshvartak]

case when (users.lastname='.') then concat(users.firstname,'1@dummy.com') else concat(users.firstname,'_',users.lastname,'1@dummy.com') end

if doesn’t work share logs

[Vinit556]

Hello Rushikesh,

Increment is not working. first time email is created be last name as "." or not "." but thereafter email field is blank.

Here are the logs, where i tried first name as "test" and last name as "adam":

 

 

[rushikeshvartak]

You need to manually write increment logic . Email generation does not support ###INCREMENTAL### 

[Vinit556]

Thanks Rushikesh for the reply. 

I have tried everything but nothing seems to be working. 

Any help will be appreciated. 

[rushikeshvartak]

Refer : https://forums.saviynt.com/t5/general-discussions/auto-increment-in-email-generation-rule-in-advance... 

[Vinit556]

Hello Rushikesh,

Now, I am using following query in Email generation rule (advance) to handle email creation manually

CASE WHEN (users.lastname like '%.%') THEN concat(users.firstname,'@domain.com') ELSE concat(users.firstname,'_',users.lastname,'@domain.com') END ###

CASE WHEN (users.lastname like '%.%') THEN concat(users.firstname,'1','@domain.com') ELSE concat(users.firstname,'_',users.lastname,'1','@domain.com') END ###

CASE WHEN (users.lastname like '%.%') THEN concat(users.firstname,'2','@domain.com') ELSE concat(users.firstname,'_',users.lastname,'2','@domain.com') END ###

CASE WHEN (users.lastname like '%.%') THEN concat(users.firstname,'3','@domain.com') ELSE concat(users.firstname,'_',users.lastname,'3','@domain.com') END

It works for users having different first and last name but if same first and last name is used it gives following error:

[Vinit556]

By changing END ### to END #  solved the prob

[rushikeshvartak]

Yes separator for multiple  conditions is # not ### for email generation