# Personal budget app with table chart

**URL:** <https://community.glideapps.com/t/personal-budget-app-with-table-chart/659>\
**Category:** Project Showcase\
**Created:** [September 27, 2019, 4:46pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659 "2019-09-27T16:46:13Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [September 27, 2019, 4:46pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/1 "2019-09-27T16:46:13Z")

</div>

This app is an extension of the template app “Personal budget”

Update of charts in glide is slow - taking maybe 5-20 minutes. The chart shown on front page of app is therefore not very relevant while the user inputs data.

But there is other ways of giving an overview of you spending - I have in the app named a tab ‘status’.  
The idea is to use a table layout. The update is done within a very few seconds - and in that way it seems feasible to put in along side the expenses.

Notice also the tab ‘Details’ which here includes the spending level of the particular category.

4 different sheets has been created

- CategoriesExp: Expanded the original categories sheet with extra columns. They are highlighted. Calculation of how much is spent in relation to the budget. A few column is used for calculating which text to show in the table
- Status: A number of different calculations used to present a ‘spending’ progress bar, the spending table and spending status. There is one input column - named ‘Careful level’ - which indicated when you should start to slow down spending. Defaulted to 90 - but try to change to another value.
- Images: Holding the ‘images’ - actual the text - to insert into the spendingtable
- SpendingIcons: Used to hold different spending icons - everything ok, take care, overspent

[https://k9stm.glideapp.io](https://k9stm.glideapp.io)

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 27, 2019, 5:56pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/2 "2019-09-27T17:56:13Z")

</div>

Very creative way for creating visuals without charts. Nice job @Krivo.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [September 28, 2019, 6:21am UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/3 "2019-09-28T06:21:55Z")

</div>

Hello Krivo!

I copied your app this morning, really amazing!

Best regards,  
Ralf

---

<div class="post-metadata">

**Author:** ![gangyao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gangyao/32/51_2.png) [@gangyao](https://community.glideapps.com/u/gangyao)\
**Post date:** [September 29, 2019, 6:05pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/4 "2019-09-29T18:05:06Z")

</div>

👍Nice app, @Krivo

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [September 30, 2019, 7:51am UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/5 "2019-09-30T07:51:20Z")

</div>

Love it @Krivo! 👍🏽

---

<div class="post-metadata">

**Author:** ![Ryan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryan/32/15941_2.png) [@Ryan](https://community.glideapps.com/u/Ryan)\
**Post date:** [November 14, 2019, 12:23am UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/6 "2019-11-14T00:23:48Z")

</div>

Do we still need to use the “Recurring=Items:Recurring?:Multiple” etc. headers or we can now use Glide relation etc. features?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 14, 2019, 12:31am UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/7 "2019-11-14T00:31:10Z")

</div>

Glide Relation columns do fully replace the header syntax in the sheet. You can still use the old way if you want, but Glide relations may be a bit faster.

---

<div class="post-metadata">

**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\
**Post date:** [November 20, 2019, 5:54pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/8 "2019-11-20T17:54:01Z")

</div>

Yeah! That’s a really cool app! Thanks for pointing me to it. I like your additions to it. The Details tab seems especially suited to what I’m trying to do. I will see if I can go from what you have to edit mine.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [November 20, 2019, 6:47pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/9 "2019-11-20T18:47:10Z")

</div>

@onepixelman Jep. Get inspired by the different cool stuff people do is really nice about this forum.  
Good luck with your app👍

---

<div class="post-metadata">

**Author:** ![dmilleravid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmilleravid/32/2230_2.png) [@dmilleravid](https://community.glideapps.com/u/dmilleravid)\
**Post date:** [December 17, 2019, 4:35pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/10 "2019-12-17T16:35:46Z")

</div>

Krivo -

I’ve taken a look at this … nicely done. I have a question for you, though: this app works well if there is a single-user. Thinking it through, if I were to modify it to permit multiple users each with their own budgets and spending, I’m not sure I would be able to filter the chart to only display the spending for the logged-in user.

Wouldn’t I need a separate chart for each user? How would you imagine that working? I’ve used filtering on charts in Google Sheets before but Glide seems to filter on the server and not in the Sheet, so I doubt that adding filtering to the chart inside the Sheet would work.

What do you think? How would you add charts when the app supports multiple users?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 17, 2019, 5:45pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/11 "2019-12-17T17:45:13Z")

</div>

@dmilleravid it might be harder creating a chart image in Google sheets for multiple users. Have you looked at the new chart component in Glide? That would allow you full control using per user data and relations.

---

<div class="post-metadata">

**Author:** ![dmilleravid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmilleravid/32/2230_2.png) [@dmilleravid](https://community.glideapps.com/u/dmilleravid)\
**Post date:** [December 17, 2019, 5:51pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/12 "2019-12-17T17:51:58Z")

</div>

I’ll play with that. Thanks.

---

<div class="post-metadata">

**Author:** ![D\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_r/32/25945_2.png) [@D\_R](https://community.glideapps.com/u/D_R)\
**Post date:** [May 25, 2021, 8:32pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/13 "2021-05-25T20:32:17Z")

</div>

@dmilleravid Hi there, were you able to come with anything regarding multiple users?

---

<div class="post-metadata">

**Author:** ![dmilleravid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmilleravid/32/2230_2.png) [@dmilleravid](https://community.glideapps.com/u/dmilleravid)\
**Post date:** [May 25, 2021, 8:45pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/14 "2021-05-25T20:45:29Z")

</div>

No. I haven’t looked at this in a long time. Sorry

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [May 25, 2021, 9:00pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/15 "2021-05-25T21:00:34Z")

</div>

Have you tried filtering based on the User ID matching the User’s, User ID?

---

<div class="post-metadata">

**Author:** ![D\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/d_r/32/25945_2.png) [@D\_R](https://community.glideapps.com/u/D_R)\
**Post date:** [May 26, 2021, 12:22am UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/16 "2021-05-26T00:22:18Z")

</div>

@Joe_Gabriele no I haven’t, but I will. Thanks.

---

<div class="post-metadata">

**Author:** ![Sara\_Turner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sara_turner/32/70841_2.png) [@Sara\_Turner](https://community.glideapps.com/u/Sara_Turner)\
**Post date:** [February 12, 2024, 10:59pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/17 "2024-02-12T22:59:15Z")

</div>

Hi @Krivo this is a great app! I copied this morning. Is there a way to look at weekly budgeting & expenses?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 12, 2024, 11:40pm UTC](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659/18 "2024-02-12T23:40:55Z")

</div>

You can probably create a math column with the formula:

YEAR(D)\*10^2+WEEKNUM(D)

With D being the current day (if you want to get the numerical representation of this week), or the date of the transaction (if you want to get the numerical representation of the transaction).

Then use relations + rollups to get the numbers you want.

This is a pretty old Classic app, it is almost 5 years old, so I would suggest building the same concept in the new Apps though.
