Chapter 9: Advanced Formula Combinations
This chapter covers the advanced areas of formula creation and combination. This chapter guides you through the almost unlimited number of combinations between formula options, properties, and database input and output values to help you create solutions to your problems.
In this chapter, we're going to cover the following:
- Combined formulas
- Input and output variations
- How to create a progress bar
You will learn how to combine multiple options in formulas, using nested if
statements and functions to create large queries or large possibilities with outputs. You will learn how to alter the properties in a database to help you calculate the information you want, and to change how a workflow operates by manipulating the input to a formula property. Then you will learn how to go about creating a formula from a problem, building it up from nothing.