ISTEXT

Use the ISTEXT function check if a value is a Text.

Use

ISTEXT( value )
Returns TRUE if the value is text.

Parameter	Required	Description
value	Yes	any text value to test

Returns

Logical

Examples

Output Validation (Enforcing Text-Only Input)

You can use ISTEXT in an Output Validation Formula to ensure that a user has provided a text string rather than a numeric or logical value. In these formulas, you use the keyword this to refer to the data currently being entered.

• Scenario: You have a field for "Client Name" and want to ensure the entry is processed as text to allow for future text manipulations like PROPER or UPPER.
• Formula: ISTEXT(this)
• Logic:
  • If a user enters "Acme Corp", the function returns TRUE, and the input is marked as valid.
  • If the system somehow receives a purely numeric value in a way that bypasses standard entry, the function would return FALSE, marking the field as invalid.

Conditional Logic (Visibility Based on Data Type)

In the Form Builder, you can use ISTEXT within Conditional Logic to show or hide specific form elements. The element is displayed only if the formula evaluates to TRUE.

• Scenario: A reviewer should only see a "Detailed Description" content block if a "Project Code" captured in the trigger step is a text string (for example, containing letters) rather than just a number.
• Formula: ISTEXT(@Trigger.out.ProjectCode)
• Logic:
  • @Trigger.out.ProjectCode: This pulls the output from the trigger step.
  • Result: If the code is "ABC-123", the formula returns TRUE, and the content block is shown on the reviewer's form. If the code is purely numeric and stored as a Number data type, the block remains hidden.

---

Pro Tip: Because of the use of various data types (Text, Number, Date, etc.) for "robustness and reliability," ISTEXT helps you confirm that the data flowing through your approval is in the correct format for subsequent text-handling functions like CONCAT, LEFT, or REPLACE.