Hi, I'm trying to create a field map in our internal database employee import that will skip updating the first and last name fields if the user contains a user_name in ServiceNow. The reason for this is not all users will have a user_name or email address, but the ones who do, will have the first & last names updated from Azure if it changes.
Here is the source script I have for the last_name field on the sys_user table that is still updating the field regardless of user_name:
answer = (function transformEntry(source) {
var name1 = source.u_last_name;
if (target.user_name.nil)
return name1; // return the value to be put into the target field
else
ignore == true;
})(source);
Based on suggestions in another previous post, I tried the below script but the field populates with 'Undefined' value for all of the last names.
answer = (function transformEntry(source) {
var name1 = source.u_last_name;
if (target.user_name==''){
return name1; // return the value to be put into the target field
}
else{
//do nothing
}
})(source);
