This section covers formulas that work with a number of data types

You can refer to the syntax and sample uses of these commands by clicking the links below:


null

Gives a null/nil value. Note: passing this into an input field will not update the field value as null. Use clear formula to update a field value to null. Remember to toggle the field to formula mode.


clear

Clears the value of the field in the target app to null/nil. Remember to toggle the field to formula mode.

Use clear formula instead of null when looking to clear field in target app


skip

Passes nothing to the destination app for this field. If the field has an existing value, it will be left untouched.

Example

This example attempts to use the trigger event's ParentID to update another Action in Hive. It checks if the trigger event's ParentID is present. If yes, it will output that ParentID. Otherwise, the new Action is left untouched.


lookup_table

This formula allows you to create a static lookup table and define the keys and values. It is case sensitive and data type sensitive.

Example

Example

Result

{"key1" => "value1", "key2" => "value2", "key3" => "value3"}["key2"]

"value2"

{"High" => "urgent", "Medium" => "mid", "Low" => "normal"}["Low"]

"normal"

{"High" => "urgent", "Medium" => "mid", "Low" => "normal"}["low"]

nil

{"High" => "urgent", "Medium" => "mid", "Low" => "normal"}["normal"]

nil

{1 => "1", 2 => "2", 3 => "3"}[2]

"2"

{1 => "1", 2 => "2", 3 => "3"}[2.0]

nil

{1 => "1", 2 => "2", 3 => "3"}["2"]

nil

Did this answer your question?