Formula Field

The Formula Field supports both basic and complex operations. You can also perform group (Rollups) calculations on related Apps.

The Formula Field supports calculations on the following Field types:

• Text
• Number
• Date
• Tick Box
• Web URL
• Email
• Select
• Checklist
• Link to User
• Link to Role
• App Relationship
• Formula

How does the Formula Field work?

Formulas can be used to manipulate and transform your App data.

To get started, use the "@" symbol to reference Fields that can be added to the formula and press Enter to select them.

You can reference Fields within your app, as well as Rollup formulas (COUNT, SUM, MAX, MIN) from related Apps.

Apart from values from Fields, you can also use static values, such as numbers, text or dates. For text, you need to enclose the value between double quotation marks (""):

For dates, you need to enclose the value between two hash (#) symbols. The date should be in the following format - dd/mm/yyyy hh:mm

Numbers can be used with basic operators like +, -, *, / and in advanced functions:

Using Rollup Formulas

Rollup Formulas can be used to perform group operations, such as COUNT, SUM, MIN and MAX, on any Number Field in a related App.

You can also calculate the average (AVG) by dividing the SUM of a numeric Field by the COUNT of records.

To get started, just type '@' and search for the rollup type you need.

Learn how you can use Rollups in Formulas.

In-built Functions

Functions can be used to perform common and complex operations.

Some examples include:

• Adding days to a date
• Calculating the difference between two dates
• Concatinating field values together
• Replacing or removing text
• Conditional and logical expressions

To use functions within your formula, click on the fn button. You can click on any function in the list and it will be automatically appended to your formula.

Remember to change the snippet to use your desired Fields.

For more details on each supported function, you can check the dedicated sections for Text, Date, Number, List and Logic functions.

Formula result type

Formula results can be one of four different types: Text, Number, Date or Boolean. The result type is determined when you create the formula for the first time. The result type will change automatically when you make changes to the formula.

Adding a Formula Field

Learn how you can add a new Field in Fusioo. Here are some of the Formula Field’s additional options:

Here’s how the Field will appear when you are:

• Creating a new record

  Note: The value will be calculated automatically based on the set Formula.

   

• Viewing a record

  

   

• In the List View

  

   

• In the Badge View

  

   

Additional Information