Set reference field value on catalog record producer via client script

[JJG]

Hello,

I have a reference field to the user table called subject_person. I would like its value to be set based on the first_name & last_name variable values when the form is submitted (see pic below). My script does not seem to be working when I check the record I created the subject_person field is blank. Any help is appreciated.

Client script: 

function onSubmit() {
var fullName = g_form.getValue('first_name')+" "+g_form.getValue('last_name');
g_form.setDisplay('subject_person',fullName);

}

[JJG]

If there is no match the record should not be submitted, 9 times out of 10 the user profile will be created before this point but it would be nice to be able to catch it just in case

[Mark Roethof]

Oke, so what about already a message when the Record Producer is opened? That might be nicer user experience, instead of aborting the Record on submission?

Kind regards,
Mark
2020 ServiceNow Developer MVP

---

LinkedIn

[JJG]

That sounds like a good idea

[Mark Roethof]

That does take a bit more effort 🙂 Though, add a onLoad Catalog Client Script and expand the Script Include a bit. Though still the record can be submitted, you might also want to do something on that.

I Made a real quick test.

Extra function for your already set up Script Include:

verify_user: function() {
	var answer = false;
	
	var grCandidate = new GlideRecord('x_your_candidate_table');

	if(grCandidate.get(this.getParameter('sysparm_candidate'))) {
		var grUser = new GlideRecord('sys_user');
		grUser.addQuery('first_name', grCandidate.getValue('first_name'));
		grUser.addQuery('last_name', grCandidate.getValue('last_name'));
		grUser.setLimit(1);
		grUser._query();

		if(grUser.hasNext()) {
			answer = true;
		}
	}		
	return answer;
},

onLoad Catalog Client Script:

function onLoad() {

	var candidateSysId = top.location.href.split('&sysID=')[1];
	
	var gaUser = new GlideAjax('getCandidatePropertiesAjax');
	gaUser.addParam('sysparm_name', 'verify_user');
	gaUser.addParam('sysparm_candidate', candidateSysId);
	gaUser.getXMLAnswer(_handleResponse);

	function _handleResponse(response) {
		if(response == 'false') {
			g_form.addErrorMessage('Error!');
		}
	}

}

Kind regards,
Mark
2020 ServiceNow Developer MVP

---

LinkedIn