Skip to main content

Formula

Formula Fields in Buildaible empower you to perform calculations, automate logic, and generate dynamic outputs based on other fields in your application. With the flexibility to create complex formulas, you can streamline your processes and ensure data consistency.

How to Create a Formula Field

Way 1: Adding Fields via Table Settings

  1. Access the Table Settings:
    On the table, click the down arrow next to the table name, then select “Table Settings” from the dropdown menu.

  2. Navigate to the Fields Tab:

    1. In the Table Settings screen, click the “Fields” tab.

    2. Click the “+ New Field(s)” button in the top right.

  3. Select Formula as the field type, provide a Field Name, and configure the settings.

Way 2: Adding Fields via Manage Fields

  1. Open Field Management:

    1. On the table, click the “Manage Fields” button.

  2. Add a New Field:

    1. In the Manage Fields modal, click the “+ New Field” button.

  3. Choose Formula as the field type, provide a Field Name, and customize the settings.

Formula Field Settings

Field Properties

  • Field Name: Provide a unique and descriptive name for your Formula Field.

  • Show in Table Home: Toggle whether this field is displayed in the main table view.

  • Open Formula Modal: Click this button to define your formula. This will open a dedicated modal for crafting and testing your formula.

Using the Formula Modal

The Formula Modal is where you create, test, and refine your formula. It features:

  1. Formula Editor: A text area to write your formula.

  2. Field Search: A list of fields from your table to reference in your formula.

  3. Function Search: A searchable list of available formula functions to use in your calculations.

For details on supported formula functions and syntax, refer to our Formula Functions and Syntax Help Article.

Examples of Formula Use Cases

  • Calculate Total Costs: Multiply a unit price field by a quantity field to get a total.

  • Dynamic Status Updates: Automatically update a field based on conditions, such as marking an order as “Complete” if all items are shipped.

  • Generate Reports: Use formulas to summarize or derive insights from data.

Best Practices

  • Test Your Formulas: Use the Formula Modal to test calculations before saving.

  • Reference Existing Fields: Leverage the Field Search panel to include relevant fields.

  • Simplify Where Possible: Start with simpler formulas and expand as needed.

Additional Information

  • A formula must be defined and saved to finalize the field creation.

  • Formulas cannot directly modify other fields; they derive values based on input data.

With Formula Fields, Buildaible provides a powerful way to automate, calculate, and streamline your workflows. Explore the possibilities and unlock the full potential of your data!

Back to top