[web2py] Re: update_or_insert - Calculation when updating

2015-11-22 Thread RedBeard
Thank you very much for the clear answer Anthony - I am just working my way though it! On Tuesday, 17 November 2015 16:45:42 UTC, Anthony wrote: > > def index(): >> form = SQLFORM(db.tr_items) >> if form.process().accepted: >> item_in_out = form.vars.item >> amount_in_out

[web2py] Re: update_or_insert - Calculation when updating

2015-11-17 Thread RedBeard
.product==item_in_out).select(db.products_summary.cumulative_amount)[0][ "cumulative_amount"]+form.vars.amount) On Tuesday, 17 November 2015 10:12:06 UTC, RedBeard wrote: > > Hey dps, > > Thanks for your reply. It is definitely getting closer, you're right, the >

[web2py] Re: update_or_insert - Calculation when updating

2015-11-17 Thread RedBeard
e seems to reference the very first product, take that amount and then add the amount the user entered in tr_item and add them - I am trying to have the amount for the same product (or create a new product with amount 0) and then add the tr_item amount to it. Thanks again!! On Tuesday, 1

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread RedBeard
hey, I've been watching Massimo's videos at: https://vimeo.com/album/3016728 I skipped a few to the deployment video, no: 30 - but before he gets to that he does a review of the previous videos: at 2mn30 he talks about the LOAD function with AJAX. You might want to check the previous videos ab