[Vtigercrm-developers] homepage widget layout error

[Alan Lord]

On 08/05/15 13:15, lucia digirolamo wrote:
> $field->columntype = 'DECIMAL(7,2)';
> $field->uitype = 7;
> $field->typeofdata = 'I~O~7,2';

Two things I notice immediately:

typeofdata should be N~O~7,2 (I is for Integer)
If you need negative numbers it should be NN~O7,2

columntype should be 'DECIMAL(9,2)'

MySQL want to see the *total* number of digits and then the precision.
vtiger wants to see each side of the decimal point.