Can we manage costs against an approved budget with multiple budget lines?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Photo of Barb McGee

Barb McGee

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
That definitely sound like something that can be set up with QuickBase.  You just need to think though the relationships you need in terms of "One to Many" and maybe draw them out on paper to get started.

For example
One does one budget line have multiple actual costs?

You used the word "Approved Budget"
Does One Approved Budget have many "Budget Lines"?

That is the starting point ... to think through the structure of your app.  ... which are the One's and which are the Many's for your tables.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Most people budget by the month or year, so one of the main tables you will want is a months table and a years table.  Then you will have budget lines, and actual expense lines tables, which are both children of the months / years.

Then with the summaries, you can compare where you are on your budgets.