how to hide zero from numeric type field?

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

t4nu
Ebase User
Posts: 305
Joined: Thu Jul 02, 2015 8:32 am
Location: Indonesia

how to hide zero from numeric type field?

#1

Postby t4nu » Thu Jun 16, 2016 7:37 am

Hi,
I think it's simple but I couldn't found a way how to do it.
How to hide the 0.00 be displayed from the table column or field?
Thanks in advance for the help.
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#2

Postby Jon » Thu Jun 16, 2016 7:41 am

Make sure the field/column is defined as an Integer type. Unwanted decimal points normally appear when integers are converted to character fields.
0 x

t4nu
Ebase User
Posts: 305
Joined: Thu Jul 02, 2015 8:32 am
Location: Indonesia

#3

Postby t4nu » Thu Jun 16, 2016 7:49 am

Waah, but the value is required to show in 2 digit after the decimal.
I just want to hide the 0.00, but it's ok with 10.00.
Jon wrote:Make sure the field/column is defined as an Integer type. Unwanted decimal points normally appear when integers are converted to character fields.
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#4

Postby Jon » Thu Jun 16, 2016 9:28 am

Sorry, don't think you can do that easily except by setting the value to null.
0 x

t4nu
Ebase User
Posts: 305
Joined: Thu Jul 02, 2015 8:32 am
Location: Indonesia

#5

Postby t4nu » Thu Jun 16, 2016 9:26 pm

In the table field or in the ebase?
Jon wrote:Sorry, don't think you can do that easily except by setting the value to null.
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#6

Postby Jon » Fri Jun 17, 2016 8:20 am

The form field or table column that you are displaying.
0 x


Who is online

Users browsing this forum: No registered users and 1 guest