Chapter 9. Script

In this chapter, we will cover the following recipes:

• Creating flags in the script

• Replacing IsNull

• Storing and dropping using a subroutine

• Keeping a trace on things

• Using the AND mode in listboxes

• Using Exists and Keep to limit the data load

• Setting the default display format

• Setting the default sort order

• Matching financial periods to dates

• Handling partial reload in the script

• Using Peek and Previous to calculate against loaded records

• Creating a simple Gantt for a dashboard using Interval Match

• Reading users from Active Directory

• Getting a sub-URL using the Table wizard

• Using parameters in Dollar Sign Expansion

• Removing fields with a wildcard

• Handling multiple subfolders in a script