How to set the email with next number if already exists in the system
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2023 12:24 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2023 06:19 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader