Its a charm, thanks alot On Saturday, October 20, 2018 at 11:32:23 AM UTC+2, sandeep patel wrote: > > There are many ways to solve this problem. > you can achieve by computed fields. > > #modal > db.define_table('logging', > Field('startingDistanceValue','integer', requires= > IS_NOT_EMPTY(),default=0), > Field('endingDistanceValue','integer', requires= > IS_NOT_EMPTY(),default=0), > Field('distanceTravelled',compute=lambda r: r[ > 'startingDistanVealue'] * r['endingDistanceValue']))) > > Every time summited form distanceTravelled field calculated automatically. > > Best > SP > > On Sat, Oct 20, 2018 at 2:46 PM mostwanted <godir...@gmail.com > <javascript:>> wrote: > >> I was hoping to get assistance here, i have a database table called* >> (logging)* that has 3 fields, *(startingDistanceValue, >> endingDistanceValue and distanceTravelled)*, distanceTravelled is the >> difference between endingDistanceValue and startingDistanceValue, when I >> start my trip i enter startingDistanceValue & subit my form, when i arrive >> i update & edit my form by entering endingDistanceValue, what i want is >> that by entering endingDistanceValue then the distanceTravelled is >> calculated automatically and acquires its value automatically then i submit >> my form for saving. How can i achieve this in web2py? >> >> *Model:* >> db.define_table('logging', >> Field('startingDistanceValue','integer', requires= >> IS_NOT_EMPTY()), >> Field('endingDistanceValue','integer', requires= >> IS_NOT_EMPTY()), >> Field('distanceTravelled')) >> >> Regards: >> >> Mostwanted >> >> -- >> 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+un...@googlegroups.com <javascript:>. >> 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.