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.