CREATE

Use the CREATE function to create a new array from values that can be literals, fields and a formula that returns values.

Use

CREATE( item1, [item2], ... )
Creates an array using the values provided.

Parameter	Required	Description
item1	Yes	the first value of the array
item2, ...	No	additional values of the array

Returns

Array matching the type of item1

Use with literals

CREATE("a", "b", "c")

returns c

CREATE(1, 2, 3)

returns 3

Use with fields

CREATE(@Review.out.Approved, TRUE, FALSE)

if field @Review.out.Approved is FALSE, returns {FALSE, TRUE, FALSE}