Skip to main content

Formulas

Calculate values, transform data, validate input, and pull information from connected records in AnyDB.

Create a Formula​

  1. Select the cell where you want the calculated value.
  2. Open the cell properties panel.
  3. Enter the formula in the Formula field.
  4. Press Enter to evaluate it.

Show Total Order Amounts for Customer

Introduction​

The main idea is simple: a formula reads values from the current record or related records, applies an expression or function, and writes the result into a cell.

Formulas are spreadsheet-like​

AnyDB formulas are similar to Excel and spreadsheet formulas. Many common spreadsheet patterns and functions work the same way, especially arithmetic, cell references, conditions, text functions, date functions, and aggregations.

Cells can be referenced by label or position​

{{Price}} * {{Quantity}}
A1 + B1

Where are formulas used?​

AnyDB formulas are used to dynamically set

  • Cell values
  • Cell properties (like background color, currency, font etc)
  • Cell validation
  • Record names

Some Examples​

Calculate Values​

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

Use Connected Records​

SUM(C@CURRREC!{{Amount}})
DYNREF({{Customer}}, {{Email}})

Make Decisions​

{{Stock}} <= {{Reorder Level}} ? "Reorder" : "OK"

Validate Data in Records and Forms​

ISEMAIL({{Email}})

Validation Functions​

Validation functions check whether a value matches a specific format, such as an email address, phone number, URL, IP address, date, postal code, or credit card number.

See the Function Index for the full list of validation functions.

Learn More​

Data

Formula References

Look up cell references, named fields, metadata, child records, parent records, and linked records.

Syntax

Operators

Review arithmetic, comparisons, logic, conditions, ranges, and property access.

Structured Data

Arrays & Objects

Work with lists, object properties, and arrays of objects in formulas.

Functions

Function Index

Browse text, math, date, lookup, array, validation, report, and advanced functions.