How to compare value in string field with choices in other field?

rkreddy
Giga Expert

Hi Everyone,

I just want to know whether the following thing is possible or not. 

I have a choices like apple,mango,orange,banana in "fruit type" choice field and I have a string field "fruit name". When user enters value in string field, it needs to compare with choices if the value already exists in choices then a info message or alert should be populated like Fruit already exists. For example if user enters apple in string field, as Apple already there in choices the alert should be populated. If user enters pineapple, then as pineapple is not there in choices, it should be added as a choice to that choice field.

Thank you.

Rakesh

1 ACCEPTED SOLUTION

Dhananjay Pawar
Kilo Sage

Hi,

In this case you can write onChange client script on string field.

 

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga = new GlideAjax('checkChoiceValues');
ga.addParam('sysparm_name','getDetails');
ga.addParam('sysparm_choiceVal',newValue); //newValue will requester for
ga.getXML(callback);
function callback(response)
{
var answer = response.responseXML.documentElement.getAttribute("answer");
if(answer==true||answer=='true'){
alert("choice already present");
}


}
}

 

Create script include

Script include name - checkChoiceValues

client callable - true

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

getDetails :function(){

var choiceVal=this.getParameter('sysparm_choiceVal');
var gr=new GlideRecord('sys_choice');
gr.addQuery('value',choiceVal);
gr.query();
if(gr.next())
{
return true;

}
else{
return false;
}

},

type: 'checkChoiceValues'
});

 

Thanks,

Dhananjay.

View solution in original post

33 REPLIES 33

Excellent the script is working for comparing choices. But it is not adding the choice if String value is not in the choice list, it is adding empty value.

Can you share the choice table form?

Make sure all field names are correct.

As I have checked in my PDI and it is working fine.

gr1.label=cat_user; 
gr1.value=cat_user;

I think the problem is with these lines, do I need to replace anything instead of cat_user?

Did you tried updated line to convert in lower case?

gr1.value=cat_user.toLowerCase();

See it is working for me and creating choices.

find_real_file.png