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
Best answer by ScottWorld
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
+35Strangely 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
+28As 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 :(.
+11I 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:
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!
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.
+11Yeh - 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.
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.
+28Hey!
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.