Vtigercrm data type

Welcome to Simone Giustetti's wiki pages.

Languages: English - Italiano

---

vtigercrm_field_properties

Data Type

Code	Description
C	Check box. Boolean "Yes" / "No" data type.
D	Date.
DT	Date and Time.
E	E-mail address.
I	Integer number.
N	Number.
NN	Negative number.
O	Duration in minutes.
P	Password.
T	Time.
V	Variable length text field.

Some formatting examples

Code	Description
C~O	Optional Yes / No flag.
D~O	Optional date field.
E~M	Mandatory e-mail address field.
E~O	Optional e-mail address field.
I~M	Mandatory integer number.
I~O	Optional integer number.
NN~O	Optional negative number.
N~M	Mandatory numeric value.
N~O	Optional numeric value.
O~O	Elapsed time in minutes. Optional field.
P~M	Password. This is obviously a mandatory field.
T~M	Time. Mandatory field.
T~O	Time. Optional field.
V~O	Optional text field.
V~M	Mandatory text field.

For any feedback, questions, errors and such, please e-mail me at studiosg [at] giustetti [dot] net.

---

Languages: English - Italiano