Table Fields

The fields section within table management allows you to add, edit and remove fields for a table.

Clicking on button from the respective Table, you will be landed to Table Fields.

These are the topics on this page:

Managing Table Fields

There are several functional buttons that let you manipulate the data being shown and stored by the system tables fields:

- The 'Add Field' Button in the top right of the screen lets you create a new table field. For an in depth guide, see Adding / Editing Field

- The 'Edit' Button lets you edit the details of the corresponding table field. For an in depth guide, please visit Adding / Editing Field

- The 'Delete' button lets you delete the corresponding table field. For an in depth guide, please visit Deleting Field

Back to Top

Adding /Editing Field

You will see the following form when adding or editing a field.

Display Name: Label users see for the field on the form and views.

Field Name: Name of the field on the database. This can't be changed once created. If you press the ‘TAB’ from the keyboard when the cursor is in ‘Display Name’ field, it will auto generate the ‘Field Name’ using the display name you have entered.

Field Type: Data type of information stored for this column. See the Field Type section below for more details.

Required: If field will be mandatory i.e. users will be required to complete this field before saving. You can select the field as either Compulsory or Optional.
- Yes: Represents the field as a compulsory field.
- No: Represents the field as an optional field. By default, this value has been selected.

Generated Type: Allows you to make the field readonly (so users are not able to enter information into the field) or generate the value for the field using a formula - this formula must be entered into the Default/Expression field.

Default/Expression: Allows you to set a default value for this field for new records, or an expression if the Generated Type is stored or virtual. The expression must conform to SQL coding standards.

Help Information: This will add a help icon next to the field label on the form with the text entered here shown as help tip.

Back to Top

Field Types

The table below describes the differences between the field types. For field types allow you to set additional input options, as noted on the table below:

Field Type	Extended Type	Description

Field Type	Extended Type	Description
Number	Decimal Places	Allows for entry of only numeral values into this field. You can specify the number of decimal places that numbers will be stored with.
Text	Singleline	Single line alphanumeric field.
	MultiLine	Multi line alpha numeric field. Show as a text area for multi line input.
	Email	Displayed as a HTML 5 email field
	Phone	Displayed as a HTML 5 phone field
	Url	Single line alphanumeric field
	LibraryFunction	Not currently implemented. Should not be used
Boolean	-	Stored as a boolean field. Will display on the form as a yes/no radios, and within view with Yes/No values
Date	DateOnly	Shown on the form as a date only entry. Stored as a date field on the database
	DateTime	Shown on the form as a date/time entry field. Stored as a date/time field on the database
	TimeOnly	Shown on the form as a time only entry. Stored as a date/time field on the database
Currency	-	Stored on the database as a decimal field with a default of two decimal places
Dropdown	-	Stored as a whole number on the database. Allows you to add and order the options to show for this field
ForeignKey	Foreign Key	Allows you to select the table from which to get the information to show in this field. Stored as a number on the database, which references the related table value.