Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

number field not taking value

Questions related to using nuBuilder Forte.
Post Reply
ajay
Posts: 38
Joined: Wed May 16, 2018 1:01 pm

number field not taking value

Unread post 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..?
You do not have the required permissions to view the files attached to this post.
ajay
Posts: 38
Joined: Wed May 16, 2018 1:01 pm

Re: number field not taking value

Unread post by ajay »

screenshot
You do not have the required permissions to view the files attached to this post.
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: number field not taking value

Unread post by admin »

ajay,

My guess is that you have the Input Type, set to nuNumber.

https://wiki.nubuilder.cloud/ ... s#nuNumber

Steven
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: number field not taking value

Unread post 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"
ajay
Posts: 38
Joined: Wed May 16, 2018 1:01 pm

Re: number field not taking value

Unread post 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.
You do not have the required permissions to view the files attached to this post.
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: number field not taking value

Unread post by toms »

Have you tried the Input Type Number ?
You do not have the required permissions to view the files attached to this post.
ajay
Posts: 38
Joined: Wed May 16, 2018 1:01 pm

Re: number field not taking value

Unread post 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.
???
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: number field not taking value

Unread post by toms »

Use another data type, like BIGINT

http://www.mysqltutorial.org/mysql-int/
number_type.png
You do not have the required permissions to view the files attached to this post.
ajay
Posts: 38
Joined: Wed May 16, 2018 1:01 pm

Re: number field not taking value

Unread post by ajay »

toms wrote:Use another data type, like BIGINT

http://www.mysqltutorial.org/mysql-int/
number_type.png
Its working now,
thanks tom
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: number field not taking value

Unread post by admin »

.
Post Reply