ptg
C H A P T E R T W E L V E Creating and Handling Forms
242
good example. Suppose in your area, the ID numbers are ve characters,
all above 30000 and below 90000. To ensure that the user enters the
proper range of numbers within the proper range, you have to choose
several settings in the Text Field Properties dialog:
•
In the Options tab, enter 5 in the “Limit of [n] characters” eld.
•
In the Format tab, select Number from the “Select format category”
pop-up menu, and set the Decimal Places to 0.
•
In the Validate tab, click “Field value is in range” and enter 30000 and
90000 in the From and To elds, respectively.
When you test the form, you’ll receive dierent JavaScript warnings,
depending on which error is encountered.
Calculations. Many forms include calculations. Fortunately, most
simple calculations can be done using the Text Field Properties dialog. In
my example invoice, there are several elds required for calculating the
costs for each item:
Quantity of an item (Q1) x unit price (P1) = total for
that item (T1)
To congure the elds to do the calculation of the total price, I need to
do the following:
Q1: Choose the Number format from the “Select format category”
pop-up menu in the Format eld.
P1: In the Format eld, choose the Number format from the “Select
format category” pop-up menu, and leave the Decimal Places set at 2.
T1: Repeat the same Format options as for the P1 eld. In the Calculate
tab, follow these steps:
1. Click “Value is the [n] of the following elds,” and select “product (x)”
from the pop-up menu.
2. Click Pick to open a list of the elds in the form. Select the elds you
want to calculate, in this case, Q1 and P1, and click OK to close the
dialog. The selected elds are shown in the dialog (Figure 89b).
Do Your Homework
Before you start a sequence
of calculation scripts in a
form, do your homework.
The simplest way to keep
track of what you want to
do is to print a copy of your
form, and then write your
scripts and calculations right
on the form. That way, when
you are in the midst of the
calculations, you’ll be able to
keep yourself oriented.
From the Library of Daniel Dadian
To Next Page
Loading...