Formula is not updating

[Ashif Malayil]

I do have 2 fields Order value and Amount received. If Order Value is 5000 and Amount Received 5000, then i need to update 'type' as Full Settlement. This type is Enum field. But this formula is not effecting. How can i achieve this?

ifThenElse(
orderValue == amountReceived,
entity\setAttribute('type', 'Full Settlement'),
entity\setAttribute('type', 'advance')
);

[eymen-elkum]

ifThenElse(
orderValue == amountReceived,
type = 'Full Settlement',
type = 'advance'
);

Make sure 'Full Settlement' is defined as option for the enum field, because will not save if not listed on options already,

[Ashif Malayil]

Yes, Full Settlement and Advance is there as a option in Enum.

[rabii]

try this

if (orderValue == amountReceived) {
    entity\setAttribute('type', 'Full Settlement')
} else {
    entity\setAttribute('type', 'advance')
}​ 

Maybe you have the value full settlement and it is translation is shown as Full Settlement

[espcrm]

Test it with the Sandbox.
Try it with another field, for example the description field.

description = "Full Settlement"