Databases Reference
In-Depth Information
Figure 6-9.
Running the form on the
TICKETS
table
Notice that the form region is labeled as you specified in step 7, the form contains fields for the four columns you
selected in step 11, and the Create a Ticket button is labeled as you specified in step 12. Also notice that the four fields
are each created as the default element type specified in the UI defaults for the
TICKETS
table that you created in
Chapter 4. The help text you specified for each column is there, and it pops up in a new window when you click the
item label. The Cancel button brings you to the home page—page 1, as you specified in step 13. APEX did a lot of work
for you!
Modifying a Form on a Table
The APEX wizards do handle most of the work of creating a form for you. However, it's rare that you won't have to
make some minor changes to what the wizard creates. Now that you have the Create aTickets form on page 2, you can
make a few changes to polish it up a bit.
Changing the Label Templates
You'll change the label templates for P2_SUBJECT and P2_CREATED_BY (the items that correspond to the
SUBJECT
and
CREATED_BY
table columns) to Required with Help. Use of the Required with Help label template indicates to the
end user that this is a required field on the form. However, it doesn't make the field itself mandatory. You do that later.
You'll also reduce the width of P2_CREATED_BY so it doesn't take up as much space. Begin as follows:
1.
Edit
Page 2
of the application.
2.
Edit the item
P2_SUBJECT
by double-clicking its name.
3.
In the
User Interface
region shown in Figure
6-10
, set
Template
to
Required with Help
,
and click
Apply Changes
.
