Update Value of Calculated Text Field based on Condition

[Krishnanand Nayak]

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)

2. 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?

[Fidel Castro Armario]

You can implement field B as a "Calculated Text Field" with the following configuration:

• Parsing mode: advanced
• Text to be parsed: {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.

[Krishnanand Nayak]

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

[Krishnanand Nayak]

This solved the issue .