Page 1 of 1
number field not taking value
Posted: Wed May 23, 2018 7:13 am
by ajay
Hi,
i have create form in which there is a mobile number field ,
when i am entering anything it is taking a default value, not saving the number that i have entered.
and it is Bold and Italic..?
Re: number field not taking value
Posted: Wed May 23, 2018 7:40 am
by ajay
screenshot
Re: number field not taking value
Posted: Wed May 23, 2018 8:14 am
by admin
ajay,
My guess is that you have the Input Type, set to nuNumber.
https://wiki.nubuilder.cloud/ ... s#nuNumber
Steven
Re: number field not taking value
Posted: Thu May 24, 2018 7:47 am
by toms
Also check the field's datatype in the database.
bold font means: the field's validation is set to "No Blanks"
Italic & bold: the validation is set to "No Duplicates"
Re: number field not taking value
Posted: Thu May 24, 2018 9:58 am
by ajay
toms wrote:Also check the field's datatype in the database.
bold font means: the field's validation is set to "No Blanks"
Italic & bold: the validation is set to "No Duplicates"
I have changed the Mobile field to nuNumber and format to $1000. though even there is same result, i am not getting the number that i have entered in the form.
Re: number field not taking value
Posted: Thu May 24, 2018 11:01 am
by toms
Have you tried the Input Type Number ?
Re: number field not taking value
Posted: Thu May 24, 2018 12:24 pm
by ajay
toms wrote:Have you tried the Input Type Number ?
i found that its saving number (9 character) to database,
problem occurring when entering >9 character number.
???
Re: number field not taking value
Posted: Thu May 24, 2018 12:32 pm
by toms
Use another data type, like BIGINT
http://www.mysqltutorial.org/mysql-int/
number_type.png
Re: number field not taking value
Posted: Thu May 24, 2018 12:47 pm
by ajay
Its working now,
thanks tom
Re: number field not taking value
Posted: Fri May 25, 2018 10:23 am
by admin
.