@IsExpandable (Formula Language)

In column formulas, returns a specified string if a row in a view can be expanded.

Syntax

@IsExpandable @IsExpandable( trueString ) @IsExpandable( trueString ; falseString )

Parameters

trueString

Text. A string to return if the view row is expandable.

falseString

Text. A string to return if the view row is not expandable.

Return value

specifiedString

Text

No parameters:

  • Returns + (plus) if the entry is expandable
  • Returns - (minus) if the entry is not expandable

Single trueString argument:

  • Returns the trueString instead of + if the entry is expandable
  • Returns nothing if it is not expandable

Both trueString and falseString:

  • Return trueString instead of +
  • Return falseString instead of -

Usage

This function is obsolete and is only provided for compatibility with existing applications. Instead, enable the view column property "Show twistie when row is expandable."

Use @IsExpandable in column value formulas to indicate whether the current level of documents can be expanded. This function does not work in any other formula.

In the single parameter and two parameter forms, you should limit the string to a single character, especially if the lines already have a lot of text in them.

Examples

  1. This example returns + if the document or category is expandable, or - if it is not expandable. 
    @IsExpandable
  2. This example returns & if the document or category is expandable. 
    @IsExpandable("&")
  3. This example returns Y if the document or category is expandable, or N if it is not expandable.
    @IsExpandable("Y";"N")