Skip to main content

What is a Formula?

In Buildaible, a Formula is a powerful tool that allows you to create dynamic calculations and manipulate data in your applications. Formulas can be used in fields to calculate values or perform operations on your data.

At its core, a formula is an expression that combines data, operators, and functions to produce a result. For example, you can use formulas to:

  • Perform basic calculations using numeric fields.

  • Automate simple data transformations.

Familiar and Easy to Use

We understand that learning new tools can be challenging, so we’ve designed Buildaible formulas to feel just like writing formulas in Excel. If you’ve ever worked with Excel formulas, you’ll feel right at home! You’ll notice:

  • Consistent Syntax: Buildaible formulas use similar syntax to Excel, including standard math operators.

  • Simple Operators: Use standard math operators such as +, -, *, and / for arithmetic calculations.

  • Helpful Guidance: We’ve streamlined the experience with intuitive auto-suggestions and clear error messages to guide you as you build formulas.

What’s Different from Excel?

While Buildaible formulas are based on Excel, there are slight modifications to make them even easier for building applications:

  • References: Instead of using cell references like A1, formulas reference field names directly by wrapping them in double curly braces, like {{Field Name}}.

  • Enhanced Application Context: Formulas work seamlessly within the context of your Buildaible app, leveraging relationships and other application data.

Examples

Here are a few examples of what formulas might look like in Buildaible:

Calculate Total Cost:

{{Unit Price}} * {{Quantity}}

Basic Calculations Without Functions:

({{Gross Revenue}} - {{Expenses}}) / {{Total Units}}

Calculate Total Revenue:

SUM({{Product Sales}}, {{Service Sales}})

Next Steps

We’re committed to making formulas intuitive and accessible so you can focus on building great applications without the steep learning curve.

Back to top