System Username Generation Rule With Condition

[harish14]

Hello Team,

We have a requirement where we need to generate system username by using below 2 cases:

Case -1 : For contractors the logic should be user's title + customproperty2

Example - user's title + customproperty2  (MD1234)

Case -2 : For Employees the logic should be 'ABCD' + users.username

Example - ABCD + users.username (ABCD1234)

When I try to use below logic it's throwing an error

logic - select case when (users.employeeType)='Contractor' then (concat(users.title),(users.customproperty2))else (concat('ABCD',users.username))end###

[jayasudha]

Hi Harish,

Could you please test the below query. Please make sure you are entering all the required fields.

if ((users.employeeType)='Contractor',(concat(users.title,users.customproperty2)), (concat('ABCD',users.username)))

If it is not working, Could you please share the logs with us.

Thanks and regards,

Jayasudha R