Formulas

Users can use formulas to transform data using Workato. Formulas allow users to easily work with and format data. Formulas in Workato are included in allowlists of Ruby methods. Not all Ruby methods are supported, but you can always reach out to us to add additional formulas to the allowlist. Syntax and functionality for these formulas are generally unchanged.

Workato allows you to work with the following standard data types:

• String
• Integer or number
• Date or datetime
• Array/hash (list)
• To work with complex data types, see here

For further assistance with creating and refining formulas, consider using Workato's Copilot. Copilot offers tailored suggestions and guidance for formula creation, helping you effectively transform and format your data. Learn more about Copilot in formula mode.