Calculate and Formula language

[Tejaskumar_Darji]

Hi,

I want to check whether 2 fields have same value or not. How can I achieve this.

So far I tried like - FT_FIELD1=FT_FIELD2, #FT_FIELD1=#FT_FIELD2​, @FT_FIELD1=@FT_FIELD2​, EQ(FT_FIELD2).

But none of them showed any validation error if the values are not same. Can you help.

Thanks.

------------------------------
Tejaskumar Darji
------------------------------

[PatrickAucoin]

Have you assigned the calculable flag in the field options?

In your example, you are trying to validate the value of field 1 based on the value of field 2? Then, try putting FT_FIELD2 in the formula for FT_FIELD1. Or self-reference: SELF = FT_FIELD2.

For an auto-calculated field, EQ(FT_FIELD1, FT_FIELD2) should return a true/false.

For text, some string functions to consider: STRCMP(FT_FIELD1, FT_FIELD2) for case sensitive, or STRICMP(FT_FIELD1, FT_FIELD2) for case insensitive.

------------------------------
Patrick Aucoin
Senior Product Consultant
Blue Prism
------------------------------