Versions Compared

Key

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

Anchor
Top
Top



Section
bordertrue


Column
width70%

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.


Column
width30%

These are the topics on this page:

Table of Contents


...

- 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


Back to Top

...

Anchor
AddEditField
AddEditField
Adding /Editing Field

...

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

...

  • 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

...

Anchor
FieldTypes
FieldTypes
Field Types

...

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.


Number Field

You can set the decimal places using the number field. 

Image Added


Text Field

You can select the text type and specify number of character on the text box

Image Added


Boolean

Using this option will show a yes / no radio button

Image Added


Date

You can select either Date Only, Date and Time and Time only option for the date field

Image Added


Currency

Currency field will display a number with two decimal places

Image Added


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



Back to Top

...

Table Fields

Displays the listing of all the table fields created by you along with the System generated fields with the following details:

...

  • Actions: You can take the following actions on the created table fields:

Refer 'Managing Table Fields' section above for more details.

...

  • Back: You will be taken to the last page visited by clicking on ‘’ button


Back to Top

...

Searching a Field

Search feature will allow you to quickly find the needed table field.

You need to enter the search keywords in the below Search Input box and instantly the Fields list will be filtered as per the keywords and shows you the required table field(s).


Back to Top

...

Anchor
DeleteField
DeleteField
Deleting a Field

...

Warning

Deleted Table Field(s) cannot be retrieved again. Be sure before deleting.


Back to Top

...