Forms
The first thing you will see after logging into nuBuilder Forte is a nuBuilder Launch Form.
This is a special type of Form, which in this case, contains Button Objects that will take you to other Forms.
Setting a Form's 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
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
- Before Browse
- Before Edit
- Before Save
- After Save
- Before Delete
- After Delete
Javascript
Javascript to be run on all Forms except Subform Forms.