Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Totals in Lists in Interfaces like in grids in bases

Solved
Jump to Solution
423 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Brasted
7 - App Architect
7 - App Architect

Is there a way to put totals or aggregations at the bottom of (or any where for that matter) a list in Interfaces? I am not using the blank option - I'm using the Airtablke supplied ones because you cannot embed ones created from blanks into a website. They are always at the bottom of columns in the base grids. It is vey inconvenient to have to add things up with a calculator  every time Look something up. Is there an Automation that would do this?

Thank, Scott

2 Solutions

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Strangely enough, that option is only available with the grid view. You can toggle between list & grid view on the interfaces if you enable both of them in the visualization panel, but unfortunately, that’s the best option at the moment.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

I completely agree! If you're working with relational data, you can set up a List Interface that calculates totals dynamically. I’ve implemented something similar for an invoice review process.

In my setup, each invoice has a linked list of line items (pulled from the Line Items table). On the Record Detail page, I added Number elements to sum up key values, making it easier to review totals before generating an invoice. Here’s a screenshot from a recent demo so you can see what I mean: 

ATSolutionist_3-1738217780658.png

One feature I’d love to see in Interfaces is the ability to group outstanding invoices by Company within a List view. Right now, there's no built-in way to do this, but it would be incredibly useful for quickly reviewing balances at a glance. If anyone has found a creative workaround, I’d love to hear about it! 

Katelyn
info@consultasolutionist.com

See Solution in Thread

7 Replies 7
ScottWorld
18 - Pluto
18 - Pluto

Strangely enough, that option is only available with the grid view. You can toggle between list & grid view on the interfaces if you enable both of them in the visualization panel, but unfortunately, that’s the best option at the moment.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Mike_AutomaticN
10 - Mercury
10 - Mercury

As mentioned by @ScottWorld, this is not possible. I’ll be checking whether a feature request has been submitted for it, and if it is not the case I’ll do so myself. 

Absolutely needed :(. 

Mike, Consultant @ Automatic Nation

ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

I completely agree! If you're working with relational data, you can set up a List Interface that calculates totals dynamically. I’ve implemented something similar for an invoice review process.

In my setup, each invoice has a linked list of line items (pulled from the Line Items table). On the Record Detail page, I added Number elements to sum up key values, making it easier to review totals before generating an invoice. Here’s a screenshot from a recent demo so you can see what I mean: 

ATSolutionist_3-1738217780658.png

One feature I’d love to see in Interfaces is the ability to group outstanding invoices by Company within a List view. Right now, there's no built-in way to do this, but it would be incredibly useful for quickly reviewing balances at a glance. If anyone has found a creative workaround, I’d love to hear about it! 

Katelyn
info@consultasolutionist.com
Scott_Brasted
7 - App Architect
7 - App Architect

Thanks you so much to both you. I have switched to a grid for now and trying to implement the second idea. I should have thought of the grid idea. But grids are only available tome after I create a list. Then if I edit the Interface, I can switch between lit and grid and calendar , etc. But it not available at creation. Thank you.

ATSolutionist
6 - Interface Innovator
6 - Interface Innovator

Yeh - its the same for the most of the otherview options (kanban/gallery) 

Only way I've been able to implement a grid at creation is with a 'blank page'. It is missing some key new features (like multiple views in one element) but I've still found some uses for this option. 

Katelyn
info@consultasolutionist.com
Scott_Brasted
7 - App Architect
7 - App Architect

I like the blank page option, but I embed my interfaces in a website for a large group of users who are read-only. Airtable will not allow a blank created page to be embedded. Ugh. So I only use blank when it is an admin only page that is excluded from read-only views. Thanks for the help. Wish that Airtable would listen to t=all the suggestions made here. It would make Airtable an unbeatable app.

Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey!

I submitted the feature request here. Kudos from anybody with the same need would be nice to get this on Airtable's product roadmap ðŸ’ª.

Mike, Consultant @ Automatic Nation