Forms

The first thing you will see after logging into nuBuilder Forte is a nuBuilder Launch Form (also referred to as a Home Page).

This is a special type of Form, which in this case, contains Button Objects that will take you to other Forms.

You can create a new Form by..

1. Clicking the Form Button on the Setup Tab of the Home Page.
2. Clicking the Add Button at the top of its Browse Form.
3. Filling out your new Form's properties (see below) - make your first Form a Browse and Edit.
4. Clicking the Save Button at the top of its Edit Form.
5. You will need to add a Button to the Home Page so users can open it.
6. And you'll want to add some Objects to your new Edit Form, for displaying and editing fields.

Form Properties

Form Type

Choose 1 of the following 5 types.

• Browse A grid like table, with seachable fields and sortable columns. Designed to easily select a record from a database table or query.
• Edit A Form displaying editable fields (nuBuilder Objects). Generally from a choice made on its previous Browse Form.
• Browse and Edit A Form with properties to define both Browse and Edit.
• Launch Not associated with a database table. Used to launch other Forms or hold editable values for Launching a Report or Procedure.
• Subform An editable Form that is repeated inside a Subform Object, generally linking its records to that of the main Edit Form.

Code

A Unique Code of alphanumeric characters.

Description

Its Description.

Table Name

Database table containing records to display. Not required for Launch Forms.

Primary Key

Primary Key belonging to Selected Table. Not required for Launch Forms.

Tabs

All but Browse Forms require at least one tab.

Tabs are arranged horizontally along the top of the editable area of an Edit Form.

And allows what seems like different layers on the same Form.

Title

Tab Title

Order

Displayed order of Tab.

SQL

SQL used to display records a Browse Form or the order of a Subform.

Columns

• Title - Column Title

Display

Table field name.

Align

Left or Right or Center

Format

Used for formatting dates and numbers. - Formatted results are not searchable.

Width

Width of column.

Order

Order of column.

Row Height

Height in pixels

Rows Per Page

Height in pixels

Redirect To

Open with different Edit Form if required.

PHP Code

PHP code can be added on these events..

• Before Browse
• Before Edit
• Before Save
• After Save
• Before Delete
• After Delete

Javascript

Javascript to be run on all Forms except Subform Forms.