Budget App

Hi There
I’m Building a budget tracker app and I’m running to trouble creating and storing budget info.
I created a starting spending categories and subcategories for the App in a table and the user would have the ability to create more categories as needed.
When creating a budget user would assign each category it’s spending budget. To do that we will have to create a form with each category as a column and then store each budget data in a row for later viewing.
Because of the categories for budget (columns) growing as well as the monthly record of the budget (rows), whenever we add category the app keeps breaking down till I regenerate the table columns again.
Any suggestion on how to structure this table?

0 1 87
  • UX
1 REPLY 1

You need 2 tables for that

Bad idea. Columns should be a fixed or rather not variable ammount.

Seems like you are using your database outside AppSheet since you can’t create Columns from AppSheet

Top Labels in this Space