Anchor | ||||
---|---|---|---|---|
|
...
- 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 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 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. |
...