- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2021 04:43 AM
Hi,
When a new user is created automatic user name should populate in the user name field using the first two letters of the first name and last name and some random number between 0 to 1.
Thanks in Advance.
Regards,
Chaitanya
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2021 05:11 AM
Hello Chaitanya,
Write a Business rule on sys_user table with the condition below
and here is the code
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var fname=current.first_name;
var lname=current.last_name;
var x = Math.floor((Math.random() * 2) + 1); //Generates random number from 1-2
var username=fname+'.'+lname+x;
current.user_name=username;
current.update();
gs.log(username);
})(current, previous);
I hope this helps!
Mark answer Correct and helpful if this solves your issue.
Thanks,
Hemant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2021 10:28 PM
Hi,
I have created one before(insert) Business Rule and tried following code on my PDI.
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var firstName = current.u_first_name;
var firstTwoLetter = firstName.slice(0,2); // first two letter of first name
var lastName = current.u_last_name;
var number = Math.random(); // generate number between 0 to 1
var userName = firstTwoLetter + lastName + number;
current.setValue('u_user_name',userName);
gs.addInfoMessage(userName);
})(current, previous);