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

Examples

Manual Activity Assignment

Activity Assignment formulas must return a Person Array. You can use the CREATE function to manually assemble a list of specific individuals who should be assigned to an activity.

• Formula: CREATE('person:Adele Vance', 'person:Megan Bowen', @Trigger.out.Manager)
• Logic:
  • 'person:Adele Vance' and 'person:Megan Bowen': These are person literals representing specific employees.
  • @Trigger.out.Manager: This is a data field captured from the trigger form where a submitter might have selected their manager.
  • Result: The CREATE function joins these three distinct identities into a single Person Array. This allows the activity to be assigned to all three people simultaneously.

Data Aggregation for Validation

You can use CREATE to group separate pieces of data (that are not already in an array) into a single collection so they can be processed by array functions like COUNTIF or SUM.

• Scenario: You have a form with three separate logical (True/False) checkboxes for different safety checks. You want to ensure that at least two of these checks are marked as TRUE before the form is valid.
• Formula: COUNTIF(CREATE(@Trigger.out.Check1, @Trigger.out.Check2, @Trigger.out.Check3), TRUE) >= 2
• Logic:
  • CREATE(...): This takes three independent logical outputs and places them into one temporary array.
  • COUNTIF(..., TRUE): This function then looks at the newly created array and counts how many of those items are TRUE.
  • Comparison: The formula returns TRUE only if the resulting count is 2 or higher, fulfilling the validation requirement.