question Clearing a variable once it's dependent variable changes not working in Developer forum

Clearing a variable once it's dependent variable changes not working

amolpawar — Fri, 02 Feb 2024 04:56:16 GMT

Hi Experts,

I have a requirement for a record producer as mentioned below:

I have created two variables in a record producer. The first variable is a Reference type and the second variable is also a reference type variable. For the second variable, I'm using a custom table and a reference qualifier to populate values from the first variable's reference table.

When the first variable value is changed, the second variable value should also be changed. But the second variable's value is not changing.

I have created an onChange client script but it's not working.

Let me know if I'm missing anything.

Thanks in advance,

Amol

Re: Clearing a variable once it's dependent variable changes not working

Harish KM — Fri, 02 Feb 2024 05:10:25 GMT

Hi @amolpawar

since it is reference field clearValue will not work, you need to use setValue

use g_form.setValue('fieldname',''); // clear the value

additional note you can place this line inside if at line 2

if (isLoading || newValue === '') {

g_form.setValue('fieldname',''); // clear the value when first variable is empty

}

Re: Clearing a variable once it's dependent variable changes not working

Pratiksha2 — Fri, 02 Feb 2024 05:40:13 GMT

Hello @amolpawar ,
Please try below code:

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

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks,

Pratiksha

Re: Clearing a variable once it's dependent variable changes not working

AniketC85155510 — Fri, 02 Feb 2024 06:09:16 GMT

Hello @amolpawar ,

When working with reference-type variables, it's recommended to use the setValue function with an empty value for effective clearing, rather than relying on the clearValue function.

You can refer the below code:

function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } if (newValue) { g_form.setValue('infosys_entity', ''); // Clear the value of 'infosys_entity' } }

Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.

Regards,

Aniket

Re: Clearing a variable once it's dependent variable changes not working

vermaamit16 — Fri, 02 Feb 2024 06:32:04 GMT

Hi @amolpawar

You can use Auto-Populate feature to achieve this without writing a single line of code. Refer below post and make the modifications accordingly.

https://www.servicenow.com/community/developer-articles/auto-populate-a-variable-based-on-a-reference-type-variable-utah/ta-p/2475511

Thanks & Regards

Amit Verma

Re: Clearing a variable once it's dependent variable changes not working

amolpawar — Fri, 02 Feb 2024 07:46:03 GMT

Thank you all of you for your quick reply,

I have marked helpful for the answer.

Thank you so much!