How to null out a field based on the change of another field?

(0) Share

Report

Posted on by USA80

I have Field A that when this field changes, I want Field B to null out the value that is there already. However, if this is an existing record, I don't want Field B to be nulled out when it loads, it needs to retain what is there.

How can I do this?

*This post is locked for comments

I have the same question (0)

All responses (39)

Answers (1)

Suggested answer

Community Member on at

Like (1)

Report

Hi USA80 ,

1.You can add the java script event handler on Field A .(Open form--> double click on the field A --> Navigate to Event Tab. --> Add the web resource in Form Libraries and Add the function in Event Handlers.

2.In the function add below code.

if (Xrm.Page.ui.getFormType() != 2)//Not update

{

Xrm.Page.getAttribute("new_fieldb").setValue(""); //Set field B to null

}

-----------------------------------------------------

Please mark this answer as verified if it answers your question.

use free tool dynamicshero.com/scheduler to schedule Workflow and Actions.

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I have the below:

function BlankProgramTypeOnChange()

{

if (Xrm.Page.ui.getFormType() != 2)//Not update

{

Xrm.Page.getAttribute("nhs_programtype").setValue(""); //Set field B to null

}

}

and it is still nulling out the field on load when it shouldn't be.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi,

When are you facing this issue? Is the form read only form? Also, where are you invoking the function(onload/onsave/onchange)?

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I am facing this issue on load even though my function is set to the event of OnChange.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Hi,

Try with this -

function BlankProgramTypeOnChange() { if (Xrm.Page.ui.getFormType() === 1) { Xrm.Page.getAttribute("nhs_programtype").setValue(null); } }

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I tried that and so on load the field isn't nulling out which is good, but now it isn't nulling out when I do change the recordtype field.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Then the filed itself might not being saved.Once the record is saved , are you able to see the field value after you create?(without refreshing the form) .

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

yes

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Then some on load script is /business rule may be making it null. Please check if any and disable .

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

They are not, as this is brand new script that I just added. Before this the field never went null.

Was this reply helpful? Yes No

Community site session details

How to null out a field based on the change of another field?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

How to null out a field based on the change of another field?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates