Hi! I have an idea in my head for a weekly planner that will involve complex usage of databases and functions but I am still not great at these and was looking for some assistance. Here is the vision

I have a database called "ToDo" that stores a task, the type (checkbox or bullet), and the date. Then on my home page I have a planner that I want to be able to click the "New Week" button at any point during the week and it will generate a set of blocks that looks similar to this screenshot below for the current week. Each day of the week will automatically be populated by information from the database.

For example, the "Week Of" will take the current date of me clicking the button, and set it from current weeks Monday - Sunday. Then the first slot for Monday will pull from the database and find Monday April 8th, and it has "6:30 PM Eat/Jessica" as the task with the type as bullet, so it will generate a bullet point as "6:30 PM Eat/Jessica". Then it will see nothing else under Monday and move to Tuesday, where it will first populate the header with the "9" before the "TUE." because for this week Tuesday will be the 9th, and then see "11:00 AM Workout Class" as Bullet, so it will make another bullet point, and also a "Update Resume" as type Checkmark, so it will create a checkbox version of it. Then Goals/Reminders and Notes will be empty and I will be able to write random notes in there on a weekly basis. Ideally I would want the checkmark in the weekly box to correspond to the "Done" checkbox in the table so that if I ever wanted to look at my large database as a whole I can filter by finished and unfinished tasks. And type="Bullet" would automatically filled because its less a task and more of an event. I would also ideally want to be able to sort it so the bullet points are always above the checkboxes so that it looks cleaner.

https://preview.redd.it/vtlq3iknb1tc1.png?width=2542&format=png&auto=webp&s=99353e944fae83568667f59831911f21e83429a3

https://preview.redd.it/721ylexhc1tc1.png?width=2138&format=png&auto=webp&s=0b7857081141cfaf2fdf9a23169b3186efa8d9d5

I use to have a system where the button would simply generate a blank weekly template and I would fill it in. This seemed much less efficient because I was unable to plan for anything further than a week in advance. I am hoping with the usage of a database I can just add everything to the database over time and the weekly todo will be filled in easily. Any tips and advice on how to achieve this is appreciated, or if this is not possible then ideas or templates similar to what I am trying to achieve would be wonderful. Thank you!!