| Anchor | ||||
|---|---|---|---|---|
|
| Section | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
|
...
- The 'Add Field' Button in the top right of the screen lets you create a new table field. For an in depth guide, please visit 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 a Field
...
| 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. | |
| 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. |
...
You can select either Date Only, Date and Time and Time only option for the date field
...
Currency
Currency field will display a number with two decimal places
...
Dropdown
Using this field will let you add items that can be choose from the dropdown. You can add an item by clicking on the Add Item Button
Input the value for the dropdown and then click on OK button to add the value.
Delete Dropdown value
You can remove the value from the drop down by clicking on the delete button.
Click on OK button to confirm removing the value from the dropdown
Reorder value
You can re arrange the sequence of the values by clicking on the order of the value and then dragging it on the top or below other values.
Change value
You can also change the name of the value by clicking on the value from the Item Tab
...
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
...
Table Fields
Displays the listing of all the table fields created by you along with the System generated fields with the following details:
...
You can delete the existing table field by clicking on the ‘Delete’ button present across the field. Clicking on the ‘Delete’ button 
button, you will be prompt for the Field delete confirmation. Once you select ‘Continue’ option, the selected Table Field will be deleted from the system.
...
| Warning |
|---|
Deleted Table Field(s) cannot be retrieved again. Be sure before deleting. |
...