Validation of Value

[AndreKöpplin]

Hello All

Decipher get two values from a Document e.g. Value 1: P234567 and Value 2: 2234567. I have to validate, if in Value 2 are the last 6-digits "234567" of Value 1 are included, if yes, the Document is OK, if not it have to be an exception.

​I setup below checks/validation in the DFD:

1. Get last 6-digits from Value 1
- Flags: Required. SoftValidation, NonExportable, AutoCalculate
- Dependent Items: Value 2
- Formula: STRRIGHT(Value1,6)

2. Check Values
- Flags: Required, SoftValidation, AutoCalculate
Dependent Items: Value 1 and Value 3
Formula: STRCONTAINS(Value from STRRIGHT(Value1,6),Value 2)

3. True/False
- Flags: SoftValidation, AutoCalculate
- Options: TRUE, FALSE
- Default Value: TRUE
- Formula: IF(EQ(Value from STRRIGHT(Value1,6)"1"),"TRUE",SELF)

The True/False field isn't change, if the Value from STRRIGHT(Value1,6)is "0" = FALSE

Any Idea or good pracise, how I can get it working?

BR
Andre​

------------------------------
Andre Köpplin
RPA Project Manager
Europe/Wroclaw
------------------------------

[BenLyons]

Hi Andre,

It's not best practice to use a field for a calculation and assignable field. When the assigned value in the document doesn't match the formula outcome, you will get a validation error.

It's best to separate these into different fields and if needed, you can mark the one you don't want in BP as non-exportable.

You have 2 options as follows:

Option A - Have assignable regions for value 1 and value 2, then an auto-calculated field for the formulas result.

The formula in the 3rd field would be IF(EQ(STRRIGHT(value1,6),value2),"TRUE","FALSE")

Option B - Add a validation formula to value 2.

The validation should simply be STRRIGHT(value1,6),.

Do either of those options work for you?

Thanks

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
Blue Prism
UK based
------------------------------