Calculate and Formula language

Tejaskumar_Darji — Tue, 22 Sep 2020 10:10:00 GMT

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
------------------------------

RE: Calculate and Formula language

PatrickAucoin — Tue, 22 Sep 2020 21:03:00 GMT

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
------------------------------

topic Calculate and Formula language in Product Forum

Calculate and Formula language

RE: Calculate and Formula language