Difference between revisions of "Forms"
|Line 92:||Line 92:|
by Subform Objects to order records inside the Subform.
Revision as of 09:59, 15 August 2020
The first thing you will see after logging into nuBuilder Forte is a nuBuilder Launch Form containing Button Objects that will take you to other Forms.
This is also referred to as a Home Page.
There are 5 types of Forms.
- Browse - A selectable list of records from a database table used by Lookup Objects.
- Edit - An area displaying editable fields from a record in a database table.
- Browse and Edit - A Form to select and then edit a record in a database table.
- Subform - An Edit Form that is repeated inside a Subform Object.
- Launch - A Form not associated with a database table.
A Browse is used by a Lookup Object to select a record from another table.
You can create a new Form the long way by...
- Clicking the Form Button on the Setup Tab of the Home Page.
- Clicking the Add Button at the top of a Browse Form.
- Filling out your new Form's properties (see below). We suggest you make your first Form a Browse and Edit.
- Clicking the Save Button at the top of its Edit Form.
- You will need to add a Button to the Home Page so users can open it.
- And then you'll want to add some Objects to your new Edit Form, for displaying and editing fields.
- 1 Form Properties
- 1.1 Form Type
- 1.2 Code
- 1.3 Description
- 1.4 Table Name
- 1.5 Primary Key
- 1.6 Tabs (Subform)
- 1.7 SQL
- 1.8 Columns (Subform)
- 1.9 Row Height
- 1.10 Rows Per Page
- 1.11 Redirect To
- 1.12 PHP Code
Choose 1 of the following.
- Browse - Used by a Lookup Object.
- Edit - Used to display editable fields from a record in a database table.
- Browse and Edit - Used to find a record and then display it.
- Subform - Used inside a Subform Object.
- Launch Used...
- As a Home Page
- A Form to display other nuBuilder Objects
- For adding criteria to a Report.
A unique code of alphanumeric characters.
The database table containing records and fields to display.
This is not required for Launch Forms.
The Primary Key belonging to the selected Table.
This is not required for Launch Forms.
All Form types, apart from Browse Forms, require at least one Tab.
Tabs are arranged horizontally above the editable area of an Edit Form.
Tabs allow users to navigate (what seems like) different layers on the same Form.
Displayed order of the Tabs. - Every time the Form is saved these records this will be reordered and renumbered in multiples of 10.
If you want any help building SQL, the SQL Button will direct you to nuBuilder's SQL Builder.
This SQL is used to display records on a Browse Form from either... An SQL Statement eg...
SELECT * FROM customer
Or an SQL statement that can reference a complicated temporary table created with PHP...
SELECT * FROM #TABLE_ID#
Used by Subform Objects to order records inside the Subform.
Table Field Name
Left, Right or Center
Used for formatting dates and numbers - The Formatted part of results are not searchable. (Don't search for a $ if it's not in the actual record.)
Width of column
Order of column. - Every time the Form is saved these records this will be reordered and renumbered in multiples of 10.
Height in pixels
Rows Per Page
If '0' then all rows will be displayed, if a number fewer than the rows in the database, it will show the remaining rows on a separate page
Redirects the choice made this a Browse Form to another Edit Form.
PHP code can be added at the following places on a Form.
- BB - Before Browse
- BE - Before Edit - not available in Subform Forms.
- BS - Before Save - not available in Subform or Launch Forms.
- AS - After Save - not available in Subform or Launch Forms.
- BD - Before Delete - not available in Subform or Launch Forms.
- AD - After Delete - not available in Subform or Launch Forms.
These sections are explained in the flowchart below.
To edit this, double click on the Textarea and you will open Ace Editor in a full screen.