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-12-2023 12:29 AM
Hi,
Please clarify/elaborate your question.
Also, it would help if you provide screen shots and/or code snippets, showing what you have done so far, and explaining where you are stuck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2023 02:14 AM
It should not change based on last name change. it should set the numeric value like 1 before @IF the email already exists in the system.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2023 02:23 AM
By the looks of it, I would say that you should pass the value of First Name and Last Name to a script include, and evaluate if an email exists, and return back the next valid email address to be filled into the Email ID field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2023 12:29 AM
Hi @Kumar147 ,
Where do you want to set the email, in the user table record's Email field ?
Thanks
Venkatesh