Update Value of Calculated Text Field based on Condition
Issue #694
resolved
Scenario: Update a Calculated Text Field based on the value from another field:
Details: 1. Field A (Custom Number Field) and Field B (Calculated Text Field)
- If (value in Field A >= 0) AND (value in Field A < 10)
Set Field B value = “Less than 10” Else if (value in Field A >= 10) OR (value in Field A < 20) Set Field B value = “Less than 20” Else Set Field B value = “More than 20” End if
Is this possible? If yes, can you provide an example?
Comments (3)
-
repo owner -
reporter Thanks for the quick solution. It helps solve current and future implementation. Also a small feedback, please add parsing examples for the custom fields in documentation :)
-
reporter - changed status to resolved
This solved the issue .
- Log in to comment
You can implement field B as a "Calculated Text Field" with the following configuration:
{nnnnn} >= 0 AND {nnnnn} < 10 ? "Less than 10" : ({nnnnn} >= 10 AND {nnnnn} < 20 ? "Less than 10" : "More than 20")
replacing nnnnn with field code for field A.