Wix Automations: Customizing Your Data with a Formula Field

5 min read
In this article
  • The formula field tabs
  • The Properties tab
  • The Functions tab
  • The Values tab
  • Building an expression with the formula field
  • FAQs
Before you begin:
This article is intended for advanced users. Creating advanced expressions using the formula field requires familiarity with schema properties and data types/formats. 
In Wix Automations, a formula field is a powerful tool for building complex expressions and manipulating data. It enables you to create custom workflows using a combination of functions and schema properties.
To convert an automation field into a formula field, click Customize above the field. This opens a comprehensive list of data types, functions, values, and schema properties, providing everything you need to build your expression.
A screenshot of the formula field list with an expression being created.

The formula field tabs

When you convert a field into a formula field, a list with multiple tabs appears to help you build expressions and logic for your automation flows. Navigate between these tabs by clicking their names at the top, and select an element to add it to your expression.

The Properties tab

The Properties tab lists all the data available from the triggers and actions in your automation flow. For example, if the trigger is Wix Forms, this tab displays form-related data, such as form fields. Learn more about using the property picker.

The Functions tab

The Functions tab offers a categorized library of customizable functions to help you build complex logic. Functions are grouped into categories like Math, Text, Date & Time, Array, and Logic. Hover over a function to view details, including its description, examples, and return data type.
An example of hovering over a function type to see more info.
Important tips:
  • Ensure you're using the correct input data type and consider the output of the function. For example, if you choose a Text data type like 'Contact Email' in a Sum function, you will encounter an error (see the image below). The Sum function requires a numeric input, not text.
  • If you need to replace the data type (e.g., replace a 'Sum' function with a 'Contact' function which expects text) click Clear at the top right of the formula field to reset the expected output type. Otherwise, you will receive an error, as the field already expects a number output.
A screenshot of a function error with an incorrect data type.

The Values tab

The Values tab provides context-specific values for your flow, including those from triggers and general values like the current date, which can be selected using the date picker. These values can be used as inputs when building your expressions.

Building an expression with the formula field

Customize your automation flow by converting a field into a formula field. This allows you to build complex expressions using the different tabs.

To build an expression with the formula field:

  1. Create or edit an automation.
  2. Click the step you want to adjust (e.g., condition).
  3. Click Customize next to a field to convert it into a formula field.
  4. Build your expression using the Properties, Function, and Values tabs.
  5. Click Apply.
Click the example below to view step-by-step instructions of how to set up an expression with the formula field.

FAQs

Click a question below to learn more about using the formula field in Wix Automations.