Automations: Troubleshooting Formula Field

You will see this error message when one or more arguments are missing from the function. To fix this, check the function structure and add any missing arguments. Once all arguments have been added correctly, the error symbol will disappear. 

Syntax refers to the structure and rules of the expression, like properly placed punctuation and symbols.

You will see this error message when the function structure is broken. To fix this, make sure all semi-colons and brackets are where they need to be. Once the expression's structure is fixed, the error symbol will disappear. 

Each field selected has an expected output type (e.g. number, text). Using the wrong type can result in errors.

You will see this error message when the field type is not the output type that is expected in the expression. To fix this, make sure to adjust the expressions to match the expected field types. Once the expressions are fixed, the error symbol will disappear. 

You will see this error message when one of the provided arguments is not from the type that the function expects to get. To fix this, replace the argument or try to cast it with casting functions to the expected type. Once all arguments match the expected function types, the error symbol will disappear. 

Note: To 'cast' means to convert data into a different type. For example, you can use a casting function to turn text into a number.

Dates must be formatted as 'Year-month-date' (e.g., 2023-10-25).

You will see this error message when you manually added a date that does not match the required date format. To fix this, use the date picker to select a date which will automatically add the date in the correct format. Once the date has been adjusted to meet the required format, the error symbol will disappear. 

You will see this error message when you select a property that is no longer available in the automation data. To fix this, replace the unavailable property with a valid one from the current automation data. Once new properties have been selected, the error symbol will disappear. 

For example, if you selected a property from a trigger but later replaced the trigger, the original properties may no longer exist. 

You will see this error message when adding more than one expression separated only by spaces. To fix this, adjust the expression so that there is only one value as an input. Once the expression has been fixed, the error symbol will disappear.