question Re: when we select none form the dropdown then it should be empty in Developer forum

when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 10:19:09 GMT

Hi,

i'm using datalook concept for below field calculation,

ex: when i select dropdown has 1 in the problem Impack, and

when i select dropdown 2 in the Likelyhood i get a score has

2 in Risk Score. has show below .

when i select " none" the fields on the form remains same, how to set empt when we select none.

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Fri, 04 Feb 2022 10:29:36 GMT

Hi Surya,

There are multiple ways

1. Create None record in your Data lookup definition table

2. Create On change client script on Problem Impact/Likelyhood which should check if both None then set value of Risk score to 0 or None.

Hope this helps

Thank you
Prasad

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 10:36:38 GMT

Hi prasad,

its helpful if i get an example on it.

Regards,

surya.

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Fri, 04 Feb 2022 10:49:39 GMT

Hi Surya,

Something like this. I taken example of Impact and Urgency

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 11:24:12 GMT

hi ,

im trying but it showing error,

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 11:42:26 GMT

Hi ,

when i try this it showing like this,

wwhen i select problem impack has none and likelyhood is none it showing changing value in riskscore

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Fri, 04 Feb 2022 11:47:13 GMT

Hi,

1. Your Field Name should be Problem Impact

2. Change the code to this

You need to provide correct logical names for the fields

var likelyhood = g_form.getValue('addcorectlogicalnameoflikelyhoodhere');

if(newValue == '' && likelyhood == '')
{

g_form.clearValue('addcorrectRiskscorefieldnamehere');

}

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 12:11:16 GMT

Hi i tried but its not getting when i select both problem impact and likelyhood, the risk score not showing none or empt value,

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 12:25:05 GMT

when i try to update with "Nune" for both problem impact and likelyhood previous value not getting changed in riskscore.

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Fri, 04 Feb 2022 13:34:03 GMT

Can you please show me choice list for these 2 fields?

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 14:18:10 GMT

choice list for likelyhood:

cchoice list for :problem impack below

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Fri, 04 Feb 2022 14:47:38 GMT

Ok Can you share your current code here as text?

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 14:54:29 GMT

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

var Likelyhood=g_form.getValue('u_likelyhood');
if(newValue == 'None' && Likelyhood=='None');

{
g_form.clearValue('u_riskscore');
}

}

Re: when we select none form the dropdown then it should be empty

surya65 — Fri, 04 Feb 2022 19:23:41 GMT

Hi,

anyupdate,.?

Re: when we select none form the dropdown then it should be empty

surya65 — Mon, 07 Feb 2022 10:17:25 GMT

hi prasad any update on this .?

Re: when we select none form the dropdown then it should be empty

surya65 — Mon, 07 Feb 2022 13:47:28 GMT

Hi prasad,

any update on this.?

Re: when we select none form the dropdown then it should be empty

Prasad Pagar — Mon, 07 Feb 2022 15:21:27 GMT

Try this

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading) {
var Likelyhood=g_form.getValue('u_likelyhood');
if(newValue == '' && Likelyhood=='');
{
g_form.clearValue('u_riskscore');
}
}
else
{
var Likelyhood=g_form.getValue('u_likelyhood');
if(newValue == '' && Likelyhood=='');
{
g_form.clearValue('u_riskscore');
}
}
}

Re: when we select none form the dropdown then it should be empty

Hitoshi Ozawa — Tue, 08 Feb 2022 01:00:30 GMT

Create 2 onChange() client scripts. One for variable u_problem_impact and another for variable u_likelyhood.

u_problem_impact client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading) {
        return;
    }
    var likelyhood = g_form.getValue('u_likelyhood');
    if (newValue == '' || likelyhood == '') {
        g_form.clearValue('u_riskscore');
    }
}

u_likelyhood client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading) {
        return;
    }
    var impact = g_form.getValue('u_problem_impact');
    if (impact == '' || newValue == '') {
        g_form.clearValue('u_riskscore');
    }
}

Re: when we select none form the dropdown then it should be empty

surya65 — Tue, 08 Feb 2022 02:01:34 GMT

thank you soo much .its helped a allot.

Re: when we select none form the dropdown then it should be empty

surya65 — Tue, 08 Feb 2022 02:12:53 GMT

thank you soo much .

its helpful.