How to create User id ,on submission of first name and last name ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2020 12:06 AM
Hi ,
I want to create ,User id on combination of First name and last name .
When user submit if user id already exists in sys_user table ,it will create other than that .
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2020 12:15 AM
You can create a insert business rule on the sys_user table. Any logic can be added over there.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2020 12:16 AM
is it on catalog form or on table ?
you can write here glide ajax to validate if username combination already exist on sys_user table or not and based on that set the value .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2020 10:14 AM
can you help with that how i can create or validate user id already exists or not ?
And on that basis how i can create new user id ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-12-2020 12:23 AM
You can create a after insert Business Rule or onSubmit client script. If you only want it to work for new record add condition current.isNewRecord() or g_form.isNewRecord()