@Select (Formula Language)

Returns the value that appears in the number position. If the number is greater than the number of values, @Select returns the last value in the list. If the value in the number position is a list, returns the entire list contained within the value.

Syntax

@Select( number ; values )

Parameters

number

Number. The position of the value you want to retrieve.

values

Any number of values, separated by semicolons. A value may be a number, text, time-date, or a number list, text list, or time-date list.

Examples

  1. This example returns 3.
    @Select(3;1;2;3)
  2. This example returns 3.
    @Select(5;1;2;3)
  3. This example returns Apr;May;Jun.
    @Select(2;"Jan":"Feb":"Mar";"Apr":"May":"Jun";
    "Jul":"August":"Sep";"Oct":"Nov":"Dec")
  4. This example returns San Diego;Sydney;New York;Amsterdam if the field named TrainingCenters contains these city names.
    @Select(3;SalesOffices;ServiceOffices;TrainingCenters)