Help

Table of budget category totals

1575 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Bruce_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

I am sure this is simple, but I’m struggling to adapt to the Airtable way of thinking!

I have a table of budget entries for my month, for example:

1 May $100 Clothes
2 May $50 Food
5 May $20 Clothes

“Food” and “Clothes” are single selects.

How do I make a second table that auto-totals each of these? e.g.

Clothes $120
Food $50

7 Replies 7

Hi Bruce

I would change the Single Select field into a “Link to another record” and create a new table. You now have a category table linked to you budget entries. You can then use rollup field in the Category table to add up stuff from the Budget table by Linked category.

You could also / instead simply group the records in a grid view and total fields.

Hope this helps,

Julian

Thanks so much - I assume it’s not possible to have a single select field that also links to another record? The single select is a big plus for us, as it makes budget entries way quicker, and stops people entering slightly different things .e.g “Clothes” for one item and “Clothing for another”

Hi

No - it’s not - but the Link field works similarly - you just select the ‘category’ from the set of linked records. It’s not quite as pretty as a single select - but you’re then using the ‘relational’ elements of the database to do their thing.

Bruce_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks - unfortunately I need to keep adding transactions on an ongoing basis, and the single select is needed for this

Ah, I figured out what you mean - I can still allocate with autocomplete or choosing from a list - works great thanks!!!

mike_m1
5 - Automation Enthusiast
5 - Automation Enthusiast

can you elaborate on this

Ivan_Carlson
7 - App Architect
7 - App Architect

This budget base may help. Accounts - Airtable Universe