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:

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.

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

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.

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