Skip to main content

Formula Functions and Syntax

Buildaible formulas are designed to be intuitive and flexible, helping you perform calculations, summarize data, and analyze information within your applications. This page provides an overview of the current formula functions and syntax you can use to get started.

Formula Syntax

Buildaible formulas use a syntax similar to Excel, making them familiar and easy to learn. Here’s a quick breakdown of the key elements:

  1. Field References:

    Use double curly braces {{ }} to reference fields in your formulas.
    Example: {{Field Name}}

  2. Operators:

    Perform basic calculations using these operators:

    1. + for addition

    2. - for subtraction

    3. * for multiplication

    4. / for division

  3. Functions:

    Buildaible formulas include a growing list of functions to manipulate and analyze data. Functions follow the format:
    FUNCTION_NAME(argument1, argument2, ...)

Available Functions

Here are the functions currently available in Buildaible, along with examples of how to use them.

SUM

Calculates the total of numeric values.

  • Syntax: SUM(value1, value2, ...)

  • Example: Adds the values from {{Product Sales}} and {{Service Sales}}.

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

MIN

Finds the smallest value among the provided numbers.

  • Syntax: MIN(value1, value2, ...)

  • Example: Returns the smallest temperature value.

    MIN({{Temperature1}}, {{Temperature2}}, {{Temperature3}})

MAX

Finds the largest value among the provided numbers.

  • Syntax: MAX(value1, value2, ...)

  • Example: Returns the highest score.

    MAX({{Score1}}, {{Score2}}, {{Score3}})

ABS

Returns the absolute value of a number (removes any negative sign).

  • Syntax: ABS(value)

  • Example: Converts a negative profit/loss value into a positive one.

    ABS({{Profit Loss}})

STDEV

Calculates the standard deviation of the provided numbers, measuring how spread out the values are.

  • Syntax: STDEV(value1, value2, ...)

  • Example: Returns the standard deviation of the given data points.

    STDEV({{Data Point1}}, {{Data Point2}}, {{Data Point3}})

COUNT

Counts the number of numeric values provided.

  • Syntax: COUNT(value1, value2, ...)

  • Example: Returns the number of fields with non-null values.

    COUNT({{Field1}}, {{Field2}}, {{Field3}})

Combining Functions

You can combine functions to create more advanced formulas. For example, you might want to calculate the total sales for two fields and then find the maximum value across all records:

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

Next Steps

  • Explore how to create and apply formulas in your Buildaible app.

  • Experiment with these functions to simplify your workflows and calculations.

  • Stay tuned for updates as we expand the list of available functions and capabilities!

With Buildaible’s formula functions and syntax, you can manipulate your data with ease and unlock powerful insights.

Back to top