Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, 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: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 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: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: number field not taking value

Unread post by admin »

.
Post Reply