How can I display the first name, last name, and email address in the Name column for the user table. Currently the the requested for variable is referencing the users table and displays the name field which only has the user's first and last name. The issue we are having is that we have some users with the same name and the end user submitting an incident or request cannot distinguish which person to choose. I do not have a good grasp at scripting so any help would be great.
Here is what we have for the script for the name column:
if (current.first_name.nil() && current.last_name.nil() && !current.name.nil()) {
var names = current.name.toString().split(" ");
if (names.length > 1) {
current.first_name = names[0];
names.shift();
current.last_name = names.join(" ");
} else
current.last_name = names[0];
}
if(current.first_name.nil()) {
current.last_name;
} else {
current.first_name + ' ' + current.last_name;
}
