Table Views Totals Row

Nigel_King
Participant II

For Table Views it would be good to have an option of displaying a Totals Rows at the top or bottom of the View.

For each column in the View (or Table) we could define if it to be included in the Totals Row as a Sum, Count,Average, Min, Max etc or not appear at all.

Status Open
12 10 2,006
10 Comments
RD_INFO
Explorer

Should also be available at group level, if required.

Koichi_Tsuji
Participant V

It could be done with actions only, without new appsheet features

Nigel_King
Participant II

I’m not sure how you’ve done this?
As Richard has said, a total row would also be needed when there are grouping of records in a table.

Koichi_Tsuji
Participant V

This is not a magic, but just a trick.
Will open up a new thread with tips and tricks category to explain.

Koichi_Tsuji
Participant V

I just posted new thread for the benefit of this community.

Nigel_King
Participant II

Thanks for that, it’s a very interesting approach. Thank you. I will see if I can fit it in with my data.

I do have several columns, grouped by a variable number of groups.

I still think it’s reasonable to make feature request total rows though. For grouped tables Appsheet is already performing a calculation on one of the columns in the group.

RD_INFO
Explorer

I’m a newby, and started to use Appsheet last week!

Thanks for the example, it will be usefull for another situation I have to resolve.

Still, if I compare with other tools that I know, the trick is a bit complicated (this is a workaround) for basic totals to be created. Also, I’m not sure if adding a row will be allowed on a SQL table having referential keys/or mandatory fields. Virtual column might have to be used in such a case.

I will continue my evaluation for Appsheet.

Thanks!

Koichi_Tsuji
Participant V

This is a trick for intermediate or advanced users I would say.

Any solutions whatever it is should require some sort of “skills” to do some advanced stuffs. I attended numbers of “tools” before, but Appsheet is only one solutions to solve problems we have in a flex manner.

There are bunch of no-code solutions, or even coding solutions in the market. There are pros/cons for each solution. It is purely depending on how everyone decide what is the best tool with them. I never disturb decision anyone (else) does, but in my humble opinion, Appsheet is so exceptional, and there is no other competitive tool in the market.

Just for me.

Status changed to: Open
Pratyusha
Community Manager
Community Manager
 
GlennP
Explorer

It would also be very useful in the values in the 'Totals' row updated dynamically when a user applied a filter within the table view.