Chapter 8: Basic Formula Functions
The formula property can be as simple or as complex as you want it to be, giving you the possibility to create outputs from any other piece of information from another property. The reason we are talking about this property in two chapters is due to the amount of flexibility it can give with the various functions, calculations, and combinations that can be created. Any of those formulas can be used for viewing, filtering, sorting, or for other property uses, such as database views.
In this chapter, we're going to cover the following topics:
- Formula fundamentals
- How formula constants work
- How formula operators work
- How formula functions work
You will learn how to use all the options that are in the formula property individually, with the required information regarding each option. This will enable you to create formulas in any database and generate basic outputs that can be used to change database information and...