I have been searching and reading and experimenting for 3 days now. This is driving me crazy and I know I am missing something fundamental as I am a noob.
I want to have the user input several integers, add them up and put them in a total field on the form before the submit to the database. In the real app this is important for sanity checks. I plan to make the total non-writeable by the user as well. The test code I have tried is below, ripped from an old thread here, and returns NaN for the total - not a number. I am pretty sure val() is converting it to a string but can't find out how to stop it, or an alternative way to get the total into total I really want to use this in a custom form using the widgets but figured if I couldn't even make it work with this simple test, then I have no hope of a more complex approach. Help please. Model db.define_table('additup', Field('number1','integer', default = 0), Field('number2','integer',default = 0), Field('number3','integer', default = 0), Field('total','integer', default = 0)) Controller def index(): form = SQLFORM(db.additup) return locals() View {{extend 'layout.html'}} {{=form}} <script> jQuery("input[name='number1'],input[name='number2'],input[name='number2']").change(function() { jQuery("input[name='total',]").val(parseInt(jQuery("input[name='number1']"))+parseInt(jQuery("input[name='number2']"))+parseInt(jQuery("input[name='number3']"))); }); </script> -- 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.