It looks like there is support for groupby in SQLFORM.grid which is what you'd need to build the proper SQL statement.
I haven't tried this with web2py. If I were, I'd try adding a groupby clause and a list of fields that include your sum field. Something like this (not tested) payments_sum_field = db.payments.amount.sum() SQLFORM.grid(db.payments, fields=[db.payments.field_1, db.payments.field_2, payments_sum_field], groupby=[db.payments.field_1, db.payments.field_2]) FWIW - I just submitted a PR for py4web to do exactly what you're talking about. Looking at the code in web2py for groupby I see that I can improve what I'd submitted so far. -Jim On Thursday, April 7, 2022 at 3:29:37 AM UTC-5 mostwanted wrote: > Hi guys, I was wondering if i could create a sums column on an > SQLFORM.grid so that every search that's made produces a sums value, > something like this: > > > > > > > *def payments(): grid = SQLFORM.grid(db.payments, args=[db.payments]) > if grid.process().accepted: query=("#Search queries of the > SQLFORMgrid") amount = > db(query).select((db.payments.amount).sum().with_alias('total')) return > locals()* > > Whats possible and whats not? > > 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/2e85caf0-dfd7-4e2a-ba66-aa65ad65d1ben%40googlegroups.com.