Forms: Difference between revisions
No edit summary |
|||
Line 19: | Line 19: | ||
=Form Properties= | |||
==Form Type== | |||
Choose 1 of the following 5 types. | Choose 1 of the following 5 types. | ||
*<span style="padding:4px 6px 4px 2px;background:#cbc287">Browse</span> A grid like table, with seachable fields and sortable columns. Designed to easily select a record from a database table or query. | *<span style="padding:4px 6px 4px 2px;background:#cbc287">Browse</span> A grid like table, with seachable fields and sortable columns. Designed to easily select a record from a database table or query. | ||
Line 29: | Line 29: | ||
*<span style="padding:4px 6px 4px 2px;background:#fa9b96">Subform</span> An editable Form that is repeated inside a Subform Object, generally linking its records to that of the main Edit Form. | *<span style="padding:4px 6px 4px 2px;background:#fa9b96">Subform</span> 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. | A Unique Code of alphanumeric characters. | ||
==Description== | |||
Form Description. | Form Description. | ||
==Table Name== | |||
The database table containing records and fields to display. | The database table containing records and fields to display. | ||
This is not required for Launch Forms. | This is not required for Launch Forms. | ||
==Primary Key== | |||
The Primary Key belonging to Selected Table. | The Primary Key belonging to Selected Table. | ||
This is not required for Launch Forms. | This is not required for Launch Forms. | ||
==Tabs (Subform)=== | |||
All but Browse Forms require at least one Tab. | All but Browse Forms require at least one Tab. | ||
Line 54: | Line 54: | ||
*'''Order''' - Displayed order of Tab. | *'''Order''' - Displayed order of Tab. | ||
==SQL== | |||
If you want any help building SQL, the SQL Button will direct you to nuBuilder's [[SQL Builder]]. | If you want any help building SQL, the SQL Button will direct you to nuBuilder's [[SQL Builder]]. | ||
Line 63: | Line 63: | ||
used by Subform Objects to order records inside the Subform. | used by Subform Objects to order records inside the Subform. | ||
==Columns (Subform)== | |||
===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 | Height in pixels | ||
==Rows Per Page== | |||
Height in pixels | Height in pixels | ||
==Redirect To== | |||
Open with different Edit Form if required. | Open with different Edit Form if required. | ||
==PHP Code== | |||
PHP code can be added on these events.. | PHP code can be added on these events.. | ||
*Before Browse | *Before Browse | ||
Line 87: | Line 93: | ||
*After Delete | *After Delete | ||
==Javascript== | |||
A Textarea containing Javascript code. | A Textarea containing Javascript code. |
Revision as of 00:49, 8 July 2017
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.
To build a Form the easy way, use the Form Builder.
OR..
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 its 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.
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 opened by selecting a record on a previous Browse Form.
- Browse and Edit A Form with both Browse and Edit functions.
- 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
Form Description.
Table Name
The database table containing records and fields to display.
This is not required for Launch Forms.
Primary Key
The Primary Key belonging to Selected Table.
This is not required for Launch Forms.
Tabs (Subform)=
All but 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.
- Title - Tab Title
- Order - Displayed order of Tab.
SQL
If you want any help building SQL, the SQL Button will direct you to nuBuilder's SQL Builder.
This SQL used to display records on a Browse Form
OR
used by Subform Objects to order records inside the Subform.
Columns (Subform)
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
A Textarea containing Javascript code.
To edit this, double click on the field and you will open Ace Editor in a full screen.
This Javascript will run on all Forms except Subform Forms.