Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

European number format input from text ,

208 0
Showing results for 
Search instead for 
Did you mean: 

Hi there,

The missing european number format (#.###,##) instead of #,###.##) was a real pain for me as well.
I have customers entering number values in different ways via form, so i cannot use number input fields. However since i do have to make calculations and output values on those fields for reporting, I struggled a lot.

I use a text field and thanks to the “number and currency pretty routines” i was able to build something that would allow me to transform a text field into a numeric field to do calculations and then to make it pretty for reporting.

However this only works for values below 1.000.000.

Maybe this will be of use to some of you out there and maybe someone wants to build on that to make it work for numbers over 1.000.000.

Here is the base:

All the best

0 Replies 0