Forms

From nuBuilderForte
Revision as of 08:07, 27 June 2017 by Admin (talk | contribs) (→‎Tabs)
Jump to navigation Jump to search

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

Height in pixels