15.5. Putting a Complex Script Together

Building a complicated script takes time and planning. Because scripting gives you so much flexibility, you can write a script that applies your business rules to your database in any number of ways. Your job is to find a good way.

In this section, you'll make a script that generates an invoice for a job. You want to gather all the unbilled expenses and timeslips for the job, and then add appropriate line items for them to the invoice. To make a script like this, you need to cover all your bases: