# Formulas

Flowfinity provides you with the ability to perform calculations using formulas which is a powerful tool that allows you to greatly expand the functionality of your applications. Formulas are used to calculate or set defaults for a wide variety of field and label values, as well as control parameters in views, and set conditional skip logic based on formula calculation results.

## 1. Introduction to Formulas in Flowfinity

Learn the basics of how to use formulas in Flowfinity to perform calculations that will greatly expand the functionality of your applications.

## 2. Data Types and If / Then Logic

Use supported data types and syntax correctly and apply conditional formulas with IF/THEN logic to determine whether a pollution level is acceptable in a simple environmental monitoring app.

## 3. Invisible Fields in Formulas

Invisible form fields are hidden from users to improve their experience and used to convert data from one type to another to perform formula calculations.

## 4. Aggregate Nested Fields with Functions

Use aggregate functions to perform calculations on embedded data in nested fields to unlock the power of formulas in Flowfinity.

## 5. Datetime Operations

Datetime operations are used in Flowfinity formulas to calculate time based results such as work durations or scheduling future tasks.

## 6. Conditional 'Case' Formulas

Case formulas are used to calculate results based on more than one condition, in this example we'll return different predefined instructions based on pollution level monitoring.

## 7. Generating Reports

Formula syntax can be used to format text strings in memo fields to generate dynamic reports based on the results of your records.