Calculations and variable text introduction

In Flowfinity, you can use formulas to carry out simple or complex calculations and logic. Some examples include adding up labor and parts costs in a work order, calculating a total score for an inspection or audit, or combining several text fields into a single message.

Formulas are written declaratively in the application editor, and can either be calculated all the time, or once as a default value for a field. Most field types can use formulas, and there are functions available to work with and convert different types of field values: date, numeric, and text.

Formulas can be calculated while the user is online or offline without a network connection.​

Here are some key things to know:

• You can use your data fields in a formula by typing Control + Spacebar and selecting them from a list, or typing in the "Name" of the field.
  
  
  Example: Multiply product amount and percent discount to get the discount in dollars
• Logic and conditions can be used in formula calculations.
  
  
  Example: If the product amount is less than $10, the discount is zero, otherwise it is 10%
• More than 100 pre-defined functions are available to use in formulas, such as sum, max or min, date/time operations, locations, and more.
  
  
  Example: Calculate one month after the sales date, as the last date that the item can be refunded
  
  Example: If the sale amount is less than $10.00, no discount is applied. If it's $10.00 or greater, a 10% discount is applied. The last date for a refund is calculated as a month later than the sale date and time.

These are some simple examples of how you can use Flowfinity formulas. For a complete guide, please refer to the "Formula Field Syntax" documentation located in the Configure tab, Documentation section.