how to change fields value based on other fields

(0) Share

Report

Posted on by Community Member

hello, i have a question.

i have 3 fields that has the same data type = two options.

A = yes / no

B = yes / no

C = yes / no

if i change one of them into "yes" option, the other fields will be automatically "no"

it must be only 1 yes within this 3 fields.

how to change it?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Try to do with Business Rules.

IF
Field A equals "Yes"
THEN
Set FiedlB to "No"
Set FieldC to "No"
ELSE IF
FiedlB equals "Yes"
THEN
Set Field A to "No"
Set FieldC to "No"
ELSE IF
FieldC equals "Yes"
THEN
Set Field A to "No"
Set FiedlB to "No"

Was this reply helpful? Yes No
Verified answer

LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

You could use JS code to do this.

1.Add this function on the "onchange" event of fieldA.

function checkValueA(executionContext){

    var formContext=executionContext.getFormContext();

    var valueA=formContext.getAttribute("fieldA").getValue();

    var fieldB=formContext.getAttribute("fieldB");

    var fieldC=formContext.getAttribute("fieldC");

    if(valueA==true){

        fieldB.setValue(false);

        fieldC.setValue(false);

    }

}

2.Add this function on the "onchange" event of fieldB.

function checkValueB(executionContext){

    var formContext=executionContext.getFormContext();

    var valueB=formContext.getAttribute("fieldB").getValue();

    var fieldA=formContext.getAttribute("fieldA");

    var fieldC=formContext.getAttribute("fieldC");

    if(valueB==true){

        fieldA.setValue(false);

        fieldC.setValue(false);

    }

}

3.Add this function on the "onchange" event of fieldC.

function checkValueC(executionContext){

    var formContext=executionContext.getFormContext();

    var valueC=formContext.getAttribute("fieldC").getValue();

    var fieldB=formContext.getAttribute("fieldB");

    var fieldA=formContext.getAttribute("fieldA");

    if(valueC==true){

        fieldB.setValue(false);

        fieldA.setValue(false);

    }

}

Hope it helps.

Best Regards,

Leo

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

I found in my fast answer there is a discrepancy with one business rules , in that case you need to select All NO value and then you have to choose one YES. Its working but you need to click on twice if there is already a YES value.

To avoid this you need to create similar logic three different business rules like below -

First Business Rules -

=================================

IF

Field A equals "Yes"

THEN

Set FiedlB to "No"

Set FieldC to "No"

Second Business Rule

====================

IF

FieldB equals "Yes"

THEN

Set FiedlA to "No"

Set FieldC to "No"

Third Business Rule

===================

IF

FieldC equals "Yes"

THEN

Set FiedlA to "No"

Set FieldB to "No"

Doing above is working as expected as per your requirement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i've tried this and it's work :D

Thankyou! :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i've tried this one too, and it's work. thankyou so much! :)

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

Have you tried to do my second options creating three business rules (no code approach )?

If you have not tried then I would suggest try once my second answer, I did my local environment its working . Please don't forget to verify my second answer as this is better approach instead of JavaScript rules , please note verifying answer will helps other people to choose right and best answer from community forum.

Was this reply helpful? Yes No