How to set the email with next number if already exists in the system

Kumar147
Tera Contributor

Hello All,

I need help in setting email if already exists in the system.

for example: if email 'test.test@gmail.com'  exists in the system it should set 'test.test1@gmail.com'  in the email field in the portal. likewise if 'test.test1@gmail.com'  exists it should set 'test.test2@gmail.com' in the field.

 

Please help me out of this thing.

 

Thanks in advance

10 REPLIES 10

@Kumar147 

you can do that based on validation

if the value exists then set the value again after adding 1 or if it's 1 then add 2

you need to check the suffix and based on that increment the value

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader