12.1. Compound Calculation Expressions12.1.1. The language of logic12.1.2. Functions and schema references12.1.3. Structured syntax and nesting12.1.4. Putting it all together12.2. Order of Operations12.3. Boolean Operations12.3.1. Zero, empty, and everything else12.3.2. Implicit Boolean coding12.3.3. Explicit Boolean coding12.4. Variables—Calculation, Script, and Global12.4.1. Declaring calculation variables—the Let( ) function12.4.2. Understanding variables' scope12.4.3. Benefiting from variables in a calculation12.5. Text Processing and Parsing Functions12.5.1. Substitute, Replace, and Trim12.5.2. Left, Right, and Middle12.5.3. Position and PatternCount12.5.4. The xWords suite12.5.5. Parsing in practice12.6. Text Formatting Operations12.6.1. Applying text formatting12.6.2. Removing text formatting12.6.3. Applying selective formatting12.6.4. Creating a Format button12.7. Dates, Times, and Timestamps12.7.1. How FileMaker manages dates12.7.2. Plotting time12.7.3. The number of seconds in 2007 years12.7.4. Juggling days, months, and years12.8. Summary Data12.8.1. Using aggregate functions12.8.2. The ballad of Max and Min12.8.3. Referencing summary fields12.9. Lists and Arrays12.9.1. Retrieving values as a list12.9.2. Managing lists—the xValues functions12.9.3. Extracting one value from a list12.9.4. Adding or inserting a list value12.9.5. Removing a value from a list12.10. Layers of Abstraction12.10.1. Building blocks with GetField( )12.10.2. The value of Evaluate( )12.11. Unstored Calculations12.11.1. Why and when calculations are unstored12.11.2. Understanding the benefits and trade-offs of unstored calculations12.11.3. Discovering the hidden secrets of unstored calcs12.12. Calculation Fields versus Auto-Enter Calculations12.13. The user over-ride capability12.13.1. Auto-enter calculations and storage12.13.2. The Do Not Replace option12.14. Global Calculations12.14.1. The moon follows you everywhere12.14.2. Managing global dependencies12.14.3. The freedom and efficiency of global calculations12.15. Environment and Metadata12.15.1. The Get( ) functions12.15.2. Design functions12.16. Calculations Using Custom Functions12.17. Your Code's Documentation12.17.1. Code formatting12.17.2. Code commenting
