How to Display an alert in Record producer if form variable value not matched in table

[vsharma]

Hi All:

I have a Record producer (table - u_visitor with fields - Name/ mobile no/ checkin time/ checkout time/ state) where I need to check mobile number and if it matches in table then user state change to "checked out" else alert user to check mobile number and abort.

I tried but not able to get else condition work to alert user & abort process. Please suggest.

—— Record Producer Script section -------

var mno = producer.u_mobile_number;

var rec = new GlideRecord('u_visitor');

rec.addQuery('u_mobile_number', mno);

rec.query();

if (rec.next()) {

rec.u_state = 'checkedout';

rec.u_checkout_time = current.u_checkout_time;

rec.update();

current.setAbortAction(true);

} 

Note: All RP form fields mapped to table fields.

Thanks

[Deepak Ingale1]

You need to perform this validation via 

1) onChange catalog client scirpt AND

2) onSubmit catalog client script

https://docs.servicenow.com/bundle/london-application-development/page/script/ajax/topic/p_AJAX.html

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/script/server_scripting/reference... 

https://developer.servicenow.com/app.do#!/lp/new_to_servicenow/app_store_learnv2_scripting_istanbul_...

https://www.servicenowelite.com/blog/2014/2/19/client-scripts-examples

Note: Please mark reply as corrret /helpful if it answers your question

[shloke04]

Hi,

I would suggest you to write an On Change Client Script on your Mobile variable which in turn will call  a Script Include(Client Callable as True) to perform the check for the Mobile Number present or not in your Custom table created and then based on the value returned you can allow or abort the Form Submission.

Below is a Reference of the Script Include :

var ans = 'false';

var mno = this.getParameter('sysparm_number');

var rec = new GlideRecord('u_visitor');

rec.addQuery('u_mobile_number', mno);

rec.query();

 if(rec.next()) {

rec.u_state = 'checkedout';

rec.u_checkout_time = current.u_checkout_time;

rec.update();

ans = 'true';

} 

else{

ans = 'false';

}

return ans;

Now use the Glide Ajax function and check for this return value (ans) i.e if it is false do return false in client script to abort form submission else allow it. For Glide Ajax Refer the below links:

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/script/server_scripting/reference/r_GlideAjax.html

I haven't tried the above script in my instance, but it's an overview on how to proceed on the same. Modify it accordingly as needed.

Hope this help. Please mark the answer as helpful/correct based on impact.

Regards,

Shloke

[vsharma]

Hi, 

I have tried as advised but did not work. A new entry created. Please check below code if I missed something.

------ Script Include (Client callable - true)------

var checkMobileno = Class.create();
checkMobileno.prototype = Object.extendsObject(AbstractAjaxProcessor, {

checkMobileno: function() {
var ans = 'false';
var mno = this.getParameter('sysparm_number');
var rec = new GlideRecord('u_visitor');
rec.addQuery('u_mobile_number', mno);
rec.query();
if(rec.next()) {
rec.u_state = 'checkedout';
rec.u_checkout_time = current.u_checkout_time;
rec.update();
ans = 'true';
}
else{
ans = 'false';
}
return ans;
},
type: 'checkMobileno'
});

-----Catalog Client Script (On Change - u_mobile_number) -----

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}

//Type appropriate comment here, and begin script below

var ga = new GlideAjax('checkMobileno');
ga.addParam('sysparm_name', 'checkMobileno');
ga.addParam('sysparm_number',g_form.getValue('u_mobile_number'));

ga.getXML(checkMobileDetails); 
}
function checkMobileDetails(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");

var answers = answer;
if(answers == false)
{
alert("Please check your mobile number");
return false;
}
}

Thanks

[Alikutty A]

Hello,

Please try changing the following part of your client script and see if it works. The false should be quotes

var answers = answer;
 if(answers == 'false')
 {
  g_form.clearValue('u_mobile_number');
  alert("Please check your mobile number");
  return false;
 }