Need to add validation on phone number

[MK-p]

I have a filed called phone number on catalog which display on catalog task with mandatory field.

I want to add validation like if phone number exists in cmdb_ci_comm table and assigned to anyone then alert message like number already exists. Can someone help me with the code.

[Ankur Bawiskar · Accepted solution]

@MK-p 

something like this

Client script

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

    var ga = new GlideAjax('PhoneNumberValidation');
    ga.addParam('sysparm_name', 'checkPhoneNumber');
    ga.addParam('sysparm_phoneNumber', newValue);
    ga.getXMLAnswer(function(response) {
        if (response === 'true') {
            g_form.showFieldMsg('phone_number', 'This phone number already exists and is assigned to someone.', 'error');
            g_form.clearValue('phone_number');
        }
    });
}

Script Include: Client callable

var PhoneNumberValidation = Class.create();
PhoneNumberValidation.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    checkPhoneNumber: function(phoneNumber) {
        var gr = new GlideRecord('cmdb_ci_comm');
        gr.addQuery('phone_number', this.getParameter('sysparm_phoneNumber'));
        gr.addNotNullQuery('assigned_to');
        gr.query();
        if (gr.next()) {
            return 'true';
        }
        return 'false';
    },

    type: 'PhoneNumberValidation'
});

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Juhi Poddar · Accepted solution]

Hello @MK-p 

You can meet this requirement by writing an onChange client script on Catalog with field phone number.

onChange catalog Client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return; // Skip validation during form load or when the field is cleared.
    }

    // Perform a GlideAjax call to validate the phone number
    var ga = new GlideAjax('CheckPhoneNumber'); // Replace with your Script Include name.
    ga.addParam('sysparm_name', 'validatePhoneNumber');
    ga.addParam('sysparm_phone', newValue);
    ga.getXMLAnswer(function(response) {
        if (response === 'exists') {
            alert('This phone number already exists and is assigned to someone.');
            g_form.addErrorMessage('This phone number is already in use.');
            g_form.setValue('phone_number', ''); // Clear the field if validation fails.
        }
    });
}

Here 'CheckPhoneNumber' is the script include name.

'validatePhoneNumber' is the function name in script include.

Script include function:

validatePhoneNumber: function() {
        var phoneNumber = this.getParameter('sysparm_phone');
        var gr = new GlideRecord('cmdb_ci_comm'); // Communication table.
        gr.addQuery('phone_number', phoneNumber); // Replace 'phone_number' with the actual field name.
        gr.addQuery('assigned_to', '!=', ''); // Check if assigned_to is not empty.
        gr.query();

        if (gr.next()) {
            return 'exists';
        }
        return 'not_exists';
    },

Note: script include should be client callable.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[MK-p]

Thanks @Ankur Bawiskar @Juhi Poddar @Runjay Patel for the help.