Try... Field('quantities', 'list:integer', required=True)) On Sunday, 26 March 2023 at 15:04:29 UTC+1 mostwanted wrote:
> I want to be able to calculate subtotal by multiplying quantity and price > but I cant because > *var quantity = parseInt("{{=details.quantities[index]}}");* in the > code below carries the value of 1 and it does not change. Please assist me > identify what could be wrong here and how can i rectify it? > > *Model:* > db.define_table('client_order'), > Field('quoted_item','list:string', required=True), > Field('quantities','list:string', required=True)) > > *View:* > {{for index, (item, qty) in enumerate(zip(details.quoted_item, > details.quantities)):}} > <tr> > <td>{{=item}}</td> > <td><input type="text" onchange="calculateSubtotal(this, > {{=index}})" /></td> > <td>{{=qty}}</td> > <td><span id="subtotal{{=index}}"></span></td> > </tr> > {{pass}} > > <script> > function calculateSubtotal(input, index) { > var price = parseFloat(input.value); > * var quantity = parseInt("{{=details.quantities[index]}}");* > var subtotal = parseFloat(price * quantity); > document.getElementById("subtotal" + index).innerHTML = > subtotal.toFixed(2); > updateGrandTotal(); > console.log(parseFloat("{{=details.quantities[index]}}")); > } > </script> > > Regards > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3861cc89-7af0-4ce2-bbb5-48eb240caff6n%40googlegroups.com.