Field Types

Field type

Like data type, specifies kind of data to be stored in the column.

In our system we got a list of generic field type as well as custom field type and how to create them.

1.1 Generic Field Types.

S/N.	Field Type	Discription
a.	Number	Store numbers (Integer, decimal and float)
b.	Time	Stores data type time in 24 and 12 clock systems
c.	Date	Store data type date - Selection from the calender
d.	Email	Store data type email in format as shown in example : sample@email.domain
e.	Phone Number	Store phone number plain and with extension ie. +x xxx - xxx -xxx
f.	Image	Store image type png, jpg,
g.	File	Store data type pdf, image,
h.	Text - Singleline	Store data type text with limited characters
i.	Text - Multiline	Store data type text with

1.2 Custom field types

S/N.	Field Type	Discription
a.	Select	Store data options that are selected form the system i.e. Yes/No
b.	Office	Store data office
c.	Product	Store data product retrieved form the system
d.	Standard	Store data standard retrieved form the ystem
e.	Parameter	Store data parameter retrieved form the system
f.	Addresss	Store data address retrieved form the system
g.
h.

Creating custom fiedls type.

1. Creating Options for data type select.