Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Problem with numeric field pattern

Avatar

Level 5

Hello!

This problem is driving me crazy!...

I've placed a float numeric field and used the following pattern:

     num{zzz,zzz,zzz,zz9.99}

This field should display and accept floating point numbers with 2 decimal places and in European format.

The default locale for this form is Portuguese (Brazil).

So... if I type something like 99999 the field displays correctly 99.999,00.

Now, if I type 99999.00, again the field displays correctly 99.999,00.

However, if I type 99999,00 (with a comma instead of a period, which is what I need)  the field displays 0,00.

Please, thank you for any ideas! 

Marcos

1 Accepted Solution

Avatar

Correct answer by
Level 10

The result you're getting is correct, because you pattern only allows a period to separate the decimal places.

Try the following edit pattern:

num{zzzzzzzzzzz9,99}|num{zzzzzzzzzzz9.99}

and this display pattern:

num{zzz.zzz.zzz.zz9,99}

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

The result you're getting is correct, because you pattern only allows a period to separate the decimal places.

Try the following edit pattern:

num{zzzzzzzzzzz9,99}|num{zzzzzzzzzzz9.99}

and this display pattern:

num{zzz.zzz.zzz.zz9,99}