System username generation

[Community_User]

Originally posted on December 21 2020 at 06:21 UTC

Hi,

We have a use case to generate system username in below format:

Rule 1: Firstname <space> lastname

Rule 2: Firstname <space> lastname <auto increment number>

adding autoincrement in the rule with initial value as 0 or 1 is resulting in error 'Auto increment should be a number'.

I have attached the screenshot of rule. Any help would be highly appreciated.

Thank you,

Mridul Utkarsh

[Community_User · Accepted solution]

Originally posted on December 23 2020 at 04:14 UTC

Hi,

As of now we dont support space using the basic rule.

Thanks

Ajay

[Community_User]

Originally posted on January 14 2021 at 19:34 UTC

Not fully fleshed out, but we use an advanced query similar to for account name generation (we were using system user name to drive account names, but that caused some issues when data didn't come through consistently).

"case when systemusername IS NULL then concat(concat(users.firstname,'.'),users.lastname) end###case when systemusername IS NULL then concat(concat(concat(users.firstname,' '),users.lastname),1) end###case when systemusername IS NULL then concat(concat(concat(users.firstname,' '),users.lastname),2) end###case when systemusername IS NULL then concat(concat(concat(users.firstname,' '),users.lastname),3) end###"

This would attempt to create a system user name and increment up to 4 times with the space in between the single quotes if there is an existing match