@IsCategory (Formula Language)

In a column formula, returns a specified string if any item in the row of a view is defined as a category.

Syntax

@IsCategory @IsCategory( trueString ) @IsCategory( trueString ; falseString )

Parameters

trueString

Text. A string to return if an item in the view row is a category.

falseString

Text. A string to return if no item in the row is a category.

Return value

specifiedString

Text.

No parameters:

  • * (asterisk) indicates that the entry is a category
  • If the entry is a document, returns nothing

Single trueString parameter:

  • Returns trueString instead of *

Both trueString and falseString parameters

  • Return trueString instead of *
  • Return falseString instead of nothing

Usage

Use @IsCategory only in column formulas.

This function only looks at the columns following it, so be sure to place it preceding the categorized column to which you are referring.

This function does not work in Web applications running version 4.5.

Examples

  1. This example returns * if the row is a category, or nothing if the row is not a category.
    @IsCategory
  2. This example returns C if the row is a category, or nothing if the row is not a category.
    @IsCategory("C")
  3. This example returns Y if the row is a category, or N if the row is not a category.
    @IsCategory("Y";"N")