Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Top
Top

...

- 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 TypeExtended TypeDescription
NumberDecimal PlacesAllows for entry of only numeral values into this field. You can specify the number of decimal places that numbers will be stored with.
TextSinglelineSingle line alphanumeric field. 
MultiLineMulti line alpha numeric field. Show as a text area for multi line input.
EmailDisplayed as a HTML 5 email field
PhoneDisplayed as a HTML 5 phone field
UrlSingle line alphanumeric field
LibraryFunctionNot 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
DateDateOnlyShown on the form as a date only entry. Stored as a date field on the database
DateTimeShown on the form as a date/time entry field. Stored as a date/time field on the database
TimeOnlyShown 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
ForeignKeyForeign KeyAllows 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.

...