Help

categories and sub-categories for expenses table

Topic Labels: Base design Data
1044 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Fabiana2023
4 - Data Explorer
4 - Data Explorer

Hello, I need to create an "budget base", I've these table

income
expenses

In the expenses table I have different categories for each expense, but for some of these I would need also sub-categories like exemples:

  • salaries
    • Person 1
    • Person 2
    • Person 3

What would be the best structure to obtein this?

I hope it's clear, thank you for your help!

2 Replies 2
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @Fabiana2023 here's a tutorial by @BenGreen that lays out how to setup some basic budgeting and expense reporting: 

https://www.youtube.com/watch?v=Y7m6yj1Y0ZA

In this video we will discuss how you be keeping track of your business expenses in Airtable in 2021. This will include automated reporting for a profit and loss statement and will be the perfect template for you to track your business expenses for your large or small business. Business expenses ...
Fabiana2023
4 - Data Explorer
4 - Data Explorer

thank you, ok but there he use a single category, its a nice structure but does not use sub categories, at the moment my solution that seems working is having some other field with single select option that I will show in the form only when some specific category will be selected.