v2021 generate 4 digit sequential number as accountname

[Community_User]

Originally posted on November 3 2021 at 07:02 UTC

Hello all,

we have requirement to generate 4 digit sequential number as account name like For e.g. 3055,3056,3057. Please suggest any approach or if any account name rule.

[Community_User · Accepted solution]

Originally posted on November 3 2021 at 21:14 UTC

Hi Nitin,

You can explore the Advanced Config in the account name rule which lets you write custom queries.

There isn't any OOB feature that can help with your requirement.

Regards,

Avinash Chhetri

[Community_User]

Originally posted on November 9 2021 at 10:26 UTC

Hi Avinash,

do you have any sample on how to generate it using advanced config, as advanced config does not support auto increment.

and please let us know if we can call custom DB function from Advanced config which will give us unique number.

[Community_User]

Originally posted on November 9 2021 at 11:56 UTC

Below is the query we are trying to use to generate next numerical accountname, but seems not working seems

select concat(MAXID + 1) as ID from (select MAX(ID) as MAXID from (select MAX(acc.name) as ID from accounts acc where acc.endpointkey = 3 ) acct union all (SELECT MAX(raa.ATTRIBUTE_VALUE) as ID FROM request_access_attrs raa where raa.ATTRIBUTE_NAME='DynaAccountName'))maxt order by MAXID desc limit 1