To get data from table and populate message in catalog item

[2022_ServiceNow]

Hi all,

I have a requirement in the catalog item.

There is a table where the data is stored. And in the catalog item, there are two fields.
Eg.: When "Joshua Tree" is selected in name, the capacity of that name is 32 according to the table data. So, in the capacity field, if the user enters the number more than 32, then it should show some alert and clear the value.
Same for "Emerald Bay". If "Emerald Bay" is selected in name, the capacity of that name is 28 according to the table data. So, in the capacity field, if the user enters the number more than 28, then it should show some alert and clear the value.

CATALOG CLIENT SCRIPT

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var ga = new GlideAjax("autoPopulateDetails"); //script include name
    ga.addParam("sysparm_name", "getCapacity"); //function name
    ga.addParam("sysparm_sysid", newValue); //paramter pass to server
    ga.getXMLAnswer(setdetails); //callback funtion
	var table_ref = g_form.getReference('u_room_name', getCapacity); //catalog room name backend value
	
	function getCapacity(table_ref) {
		var name_capacity = table_ref.u_capacity; //u_capacity is custom table Capacity Field back end value
		
		if(newValue >= name_capacity) {
			alert("maximum capacity exceeded");
			g_form.clearValue('please_confirm_the_number_of_people_that_are_going_to_attend_your_meeting_on_site');
	}
}   
}

SCRIPT INCLUDE

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

    getCapacity: function() {
        var val;
        var sysid = this.getParameter("sysparm_sysid");
        var grUsr = new GlideRecord("u_conference_room");//table name
        grUsr.addQuery("sys_id", sysid);//filters with sysid
        grUsr.query();
        if (grUsr.next()) {
            val = grUsr.u_capacity; //field name to get
            return val;
        }
    },
    type: 'autoPopulateCapacity'
});

How can I achieve this? Thanks in advance!

@Ankur Bawiskar @Community Alums @Karan Chhabra6 @Pradeep Sharma @Allen Andreas @Chuck Tomasi @Jaspal Singh @Musab Rasheed @Pavankumar_1 @Manmohan K 

[Mallidi Suma · Accepted solution]

Hi @2022_ServiceNow ,

Please try the below code.

Create an OnChange catalog client script in your catalog item on a variable capacity.

Code:-

var table_ref = g_form.getReference('name',getCapacity); //name is catalog name variable backend value

function getCapacity(table_ref)

{

var name_capacity = table_ref.u_capacity; //u_capacity is custom table Capacity Field back end value

if(newValue >= name_capacity)

{

alert("maximum capacity exceeded");

g_form.clearValue('capacity');

}

Screenshot:- 

Please note that the catalog item name variable references your custom table name field.

Please mark my answer as helpful and accept it as a solution if it helps!!

[Ankur Bawiskar]

@2022_ServiceNow 

u_room_name variable must be of reference type and pointing to that custom table

then it will work fine

Did you debug by adding alert?

[2022_ServiceNow]

@Ankur Bawiskar 

Thank you Sir, it is working fine