Write a script that creates the data table for the bill pay page/view

[mbcann01]

Overview

I did a fair amount of work on the budget in Google Sheets. My thought was that I would just use the easiest platform to get the job done. It turns out that Google Sheets isn't "easy"; although, it still may turn out to be the easiest - we'll see. For now, however, I want to give Shiny another try.

One of the sheets that I started creating in Google Sheets was the "Bills Due" table. This table/sheet was supposed to be the view I would use for paying bills each pay period. The idea was for it to be similar to my traditional Google Sheets monthly budget, but dynamic.

In this issue, we aren't yet creating a Shiny app. Instead, I just trying to create a static version of the bills due table that I want to interact with. Doing so requires joining data from a few different data tables and then filtering them based on the date and pay period.

Links

• Wiki about this topic
• Google Sheets: Test Select Rows By Pay Period
• Google Sheets: Budget App Prototype

Tasks

• [ ] Placeholer

[mbcann01]

2023-03-24

• Working bill pay functionality.
• Right now, I'm just trying to put together the bill pay table in a non-interactive way (bills_due.R).
• Working through the wiki notes.
• Instead of trying to think through every possible scenario from the beginning, I'm trying to work through progressively more complicated scenarios. For example, annual bills and bills that I don't want to pay in the same pay period they are due.
• Left off on line 80 of bills_due.R.

Copy and paste for commits:

Working on bill pay table
Part of #3
- Create a non-interactive combined bill pay table in bills_due.R

[mbcann01]

2023-03-28

• Working bill pay functionality.
• Right now, I'm just trying to put together the bill pay table in a non-interactive way (bills_due.R).
• Working through the wiki notes.
• Instead of trying to think through every possible scenario from the beginning, I'm trying to work through progressively more complicated scenarios. For example, annual bills and bills that I don't want to pay in the same pay period they are due.
• Left off on line 96 of bills_due.R. Trying to get the month filter working.

Copy and paste for commits:

Working on bill pay table
Part of #10
- Create a non-interactive combined bill pay table in bills_due.R

[mbcann01]

2023-03-29

• Working bill pay functionality.
• Right now, I'm just trying to put together the bill pay table in a non-interactive way (bills_due.R).
• Working through the wiki notes.
• Instead of trying to think through every possible scenario from the beginning, I'm trying to work through progressively more complicated scenarios. For example, annual bills and bills that I don't want to pay in the same pay period they are due.
• Left off on line 166 of bills_due.R. I am trying to get the pay period filter working.

Copy and paste for commits:

Working on bill pay table
Part of #10
- Create a non-interactive combined bill pay table in bills_due.R