Boolean & Formula with IfThenElse

[dodom2]

Hello All. Can someone assist with this formula below:

ifThenElse(
status == "Reconciled Transaction",
entity\setAttribute('reconciled', true),
entity\setAttribute('reconciled', false)
);

"reconciled" is a boolean field. this doesn't work for me. How should I set correctly to check the boolean if this condition is true or make it uncheck if the condition isn't met?

[eymen-elkum]

Hello,

Try this:

ifThenElse(
    status == "Reconciled Transaction",
    reconciled = true,
    reconciled = false
); 

[dodom2]

Thank you Eymen however I tried this already as well and it doesn't work.

[Maximus]

What if:

ifThenElse(
    status == "Reconciled Transaction",
    reconciled = 1,
    reconciled = 0
); 

[peterberlin]

Hello

https://forum.espocrm.com/forum/general/37152-boolean-field

[dodom2]

Thank you Peter however I had no luck with your post. I tried that before posting here but couldn't really make sense of the resolution.

[shalmaxb]

Try to make ifThen function:

ifThen(
status == 'Reconciled Transaction',
entity\setAttribute('reconciled', true)
);

and give the boolean a default of false (in field configuration of entity). That means, that the field is alway false by default and only true, when condition of ifThen is met.

[dodom2]

No luck

[shalmaxb]

I tested this here and it works

ifThenElse(
status == 'Reconciled Transaction',
entity\setAttribute('reconciled', true),
entity\setAttribute('reconciled', false)
);

Only to be sure: Did you recalculate formula in your entity? Sometimes rebuild helps as well as purging the browser cache.

The formula above is correct.