Help

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

Solved
Jump to Solution
230 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.

- ScottWorld, Expert Airtable Consultant

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.

- ScottWorld, Expert Airtable Consultant

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