Hello Tom, The validator don't determine the number of places you want base on your decimal field definition, you have to specified it in the validator : IS_DECIMAL_IN_RANGE(0.0000, 99999999.9999, dot=',')
Notice you have only 2 places in your decimal definition field model!! Richard On Sat, Nov 29, 2014 at 11:58 AM, Tom Øyvind Hogstad < tom.oyvind.hogs...@gmail.com> wrote: > I have the following field declaration > > Field('test_BOF', 'decimal(10,2)', > label='BOF (mg/l)', > requires=IS_EMPTY_OR(IS_DECIMAL_IN_RANGE(dot=',')) > > In a SQLFORM this vil output as a number with a for numbered fraction e.g. > 12,3000 > > <input class="decimal" id="plant_service_test_BOF" name="test_BOF" type= > "text" value="12,3000"> > > How can i format this value? > > Web2Py: 2.9.11 > DB: PostgreSQL 9.3 > > Tom Ø. > > > (BTW maybe w2p should detect the requested number of decimals from the field > type in this case?) > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.