Database Reference
In-Depth Information
Remember, you want to make sure you have unbilled items for this job before you
create an invoice. By grabbing this value now, and passing it to the main script later
on, the main script will have the information it needs to decide whether to create an
invoice.
Your script should now look like the one in
Figure 17-24
.
Figure 17-24. The Find Unbilled Activity script is half done. You've got helpful comments, plus the
steps to find unbilled line items that should be billed to the job for which you're creating an in-
voice. Refine your script further by removing the “TODO:” from your first comment so you can see
that it's now an explanation of what should be happening, instead of a reminder of what you still
need to do.
Copying and Editing Existing Script Steps
Since the timeslips half of the script is almost a duplication of what you did in the last tutori-
al, you could repeat all those steps above and you'd be done. But it's a lot faster to duplicate
those steps and then make a few changes so that your duplicated steps operate on the
Timeslips table, not on the Expenses table. Here's how:
1.
Click the
Go to Layout
line in the script. With the Shift key held down, click the
Set Variable
step and then click Duplicate
.
FileMaker creates an exact copy of all the selected steps. They all wind up below the
first set.
2.
Move the “TODO: Find and count all unbilled timeslip records for the current
job” comment above the duplicated steps
.
This helps you keep track of where you are in the process.
3.
Select the
Go to Layout
script step and then change it so it goes to Timeslips in-
stead of Expenses
.
