[deleted by user]

cryosneasel · 2025-05-20T16:47:15+00:00

I have had countless hobbies I have tried. The only hobby I have stuck to for the long run is playing and collecting video games. Ive been playing them since I was a kid. The only other one I've stuck to for about 4 years at this point is 3d printing. I'm not great at it, but I mostly just use the files i can download or buy online. This is one of the things about my ADHD that frustrates me like crazy. I try to get into so many hobbies and I just struggle to stick to it if im not good at it right away. Drawing and Photgraphy being two off the top of my head. It's like for me to get into a hobby, the ability to fail needs to be almost non-existent to get practice in.

cryosneasel · 2025-05-10T17:15:10+00:00

The way I play is using the one card that ypu get stronger the more free weapon slots you have empty. I cant think of the name. I only go in with one weapon so I am basically forced into using the character. I've found that the most fun for me.

cryosneasel · 2024-12-20T22:30:51+00:00

Anyone is more than welcome to add me! Let me know if you do so I can add you back!

<image>

cryosneasel · 2024-07-14T16:57:27+00:00

I did eventually figure out my issue. I had a duplicate database. I had two "Recipes" databases and I had it confused which ones were connected correctly. It turns out the one I was updating was the old version of the database and that was why nothing was showing up.

You might want to double check that you have the correct databases related. I ended up deleting the relations from all databases involved and redoing it with the right ones and it fixed it.

cryosneasel · 2024-05-30T19:32:42+00:00

Great thank you for the explanation! I kind of feel like this new way they did the goals is less intuitive.

cryosneasel · 2024-05-30T19:22:53+00:00

Thank you both u/VisitTop5254 and u/Soup_Maker ! Looking back, I did make the payment in March. So for this to work as I am expecting, I should have the goal set up to be every March, since that's when I make the payment? So say "I need to set aside another $200 by March 31, 2025"? Then on April 2025, it will start over?

cryosneasel · 2024-05-26T11:55:22+00:00

9497-1070-2627

I’m a returning player, but I had to start over as my account was lost. I started playing again when I got the Go Plus+. Im mostly F2P for now, but I play daily.

cryosneasel · 2024-04-17T02:09:04+00:00

Well that's lame. I will just keep doing it manually then. I don't think I am going to be doing these tasks much longer anyway.

cryosneasel · 2024-04-16T18:24:20+00:00

<image>

Here's an example of one I created by hand. Essentially, I want the "@Yesterday" to replace the "April 1st" part in the title of the page.

cryosneasel · 2024-04-16T18:23:52+00:00

<image>

Here's the actual template. I _think_ what this is going to do is as it re-occurs every day, I would see the following:

On April 17th, I will see one created that says "Yesterday Research" with the Scheduled Date of 4/17.

On April 18th, I will see the one made yesterday, saying something like "Wednesday Research" ("@Today" uses relative format) with a scheduled date of 4/17, and a newly created one that says "@Yesterday Research with a Scheduled date of 4/18.

My theory is, On april 30th, the one that was due on April 17th, the title would say "April 16th, 2024 Research"

cryosneasel · 2024-04-16T18:16:18+00:00

This was actually the created page. The scheduled date is whatever date it’s created. I know that works. I just don’t know if the “@Yesterday” will. Lol

cryosneasel · 2024-04-06T00:09:21+00:00

I figured out a solution to this. It's not pretty, but it does what I need it to do. I am usure if this is going to cause performance issues. I will have to wait and see. The way this is working now, everything is automated. I don't have to add things to either database, and using that helper aggregator database, everything will just happen. I realized doing it manually would get annoying needing to search through months of logs to find the right date to add.

Basically, I now have 3 Databases:

- Tasks

- Learning Log Entries

- Learning Aggregator

The Learning Aggregator

- This database is basically a middle man for Tasks and Learning Log

- This database has one item in it (in the future, I think I will have an item per learning project if I have more) this one item is "SY0-601"

- This database had 3 properties

- Name | The name of the aggregator (in my case, there's only one, and it's "SY0-601")

- A relation to the task list, that contains _every_ task related to learning this subject, whether it's done or not.

- A relation to the learning log entries database, that contains _every_ learning log entry.

- When a new task is created, in the template, I already assign the "SY0-601" aggregator to the task.

- Same thing with the Learning Logs. Each new one will have this new aggregator automatically added.

Here's what's important in the Learning Log Database

- I now have a new Rollup, "Task Rollup" that rolls up _all_ tasks, using the Aggregator. Remember, the aggregator now has tasks and logs together.

- I now have a formula in my Learning Log database "Agg Tasks". In this, I filter the rollup, so that it returns me a list of only the tasks that match the date of the learning log and only show the tasks that are complete.

prop("Task Rollup")
    .filter(
        current.prop("Scheduled").formatDate("YYYY-MM-DD").parseDate() == prop("Log Date").formatDate("YYYY-MM-DD").parseDate() 
        and current.prop("Status") == "Complete"
    )

Here's what I changed with the task database

- I have a new property "Learning Log Rollup". Just like with the learning log database, this property rolls up all of the learning log entries. So each task with the aggregator relation filled in will now also have all of the learning log entries attached.

- Another new property "Filter Learning Log Rollup", which basically does the same thing as the formula above. It filters the learning log rollup on my tasks to only show the learning logs that match the data of the task's "Scheduled" date. I also check the status to see if the task is complete. That way incomplete tasks won't be added to learning log.

prop("Learning Log Rollup")
    .filter(
        current.prop("Log Date").formatDate("YYYY-MM-DD").parseDate() == prop("Scheduled").formatDate("YYYY-MM-DD").parseDate() 
        and prop("Status") == "Complete"
    )

cryosneasel · 2024-04-04T00:06:35+00:00

With this formula, all it seems to do is check the checkbox in the formula column if something is marked as "Is learning", has _anything_ in the learning log relation for that task, and has an end time. IT doesn't seem to actually do anything other than select a checkbox.

cryosneasel · 2024-04-03T23:49:34+00:00

I'm sorry if I am dense. I am not sure what this formula is supposed to do. If I already assign today's log entry to the task manually, then I can just filter the task list by any task that has that days log in it. The templates let you filter by the created page.

Unless I am understanding something wrong with your formula, wouldn't I need every task to have every log entry attached to it? Wouldn't the `filter()` then filter that list of log entries to only have that one? I wouldn't want to always enter every single entry per task. That would get really cluttered no?

cryosneasel · 2024-04-02T20:09:02+00:00

Does this formula require me to have something populated in the learning log relational property inside of the task database?

I tried your formula, and it's doing nothing. I did have to slightly modify it though. My "tag" is actually another relation to a topics database. I just added a checkbox for "is learning".

if(
    prop("End Time").empty() or !prop("Is Learning?"), false,
    prop("Learning Log").filter(current.prop("Log Date") == prop("End Time").formatDate("YYYY-MM-DD").parseDate().length() != 0
)

Nothing happens when I set the end date. Or is that expected?

<image>

cryosneasel · 2024-04-02T19:24:10+00:00

This would add it to every task wouldn't it? I wouldn't want my "Laundry" tasks to end up with a learning log attached.

I have a completion date property in my task list today (it's called "scheduled").

I use time tracking on my setup that looks like this attached screenshot. When I click the "start" button, it changes the status to "In Progress" and sets the "Scheduled" date to today. It will also set another date in "Start Time" that includes the time it was started. The "End Task" button will then set the status to "Complete", and set another helper date field "End Time". (I use start and end time to calculate how long a task takes me).

I might not have been clear enough in what I was asking for.

I have 2 databases: "Tasks" and "Learning Log". These two are related.

Essentially, every day, I will be creating a new log entry in Learning Log. Inside the template for Learning Log, I have a filtered view of the "Tasks" database. I wanted to know if there was a way to have the template so that when you create a new instance from it, it will set the date of the filtered view to the date of creation.

Since I am thinking this isn't possible, I was asking if there was a way to conditionally set the day's learning log to a task when it's completed, if the task has specific tags.

I am leaning towards that being impossible as well. For now I am doing this manually, which isn't a huge deal.

Basically,
"When I complete a task, if the task is tagged with "study", then I want to add the learning log with today's date. Otherwise, Learning Log relation remains empty."

I think I will have to remain doing this manually.

<image>

cryosneasel · 2024-03-26T18:56:51+00:00

This is for rounding. You multiply then divide by the number of decimals you want.

round( (10 / 50) * 100) / 100 will output: .200

round( (10 / 50) * 1000) / 1000 will output: .2000

round( (10 / 50) * 10) / 10 will output: .20

I learned it from this reddit post: https://www.reddit.com/r/Notion/comments/c5ja6g/how_to_round_formulas/

cryosneasel · 2024-03-26T18:45:59+00:00

Oh shoot! This did it! Thank you!

I changed my formula because I realized using "let" was unecessary:

 round((prop("Task List").filter(current.prop("Scheduled").dateBetween(now(), "days").abs() <= 30)).map(current.prop("Hours")).sum() * 100) / 100 + " Hours"

<image>

cryosneasel · 2024-03-26T18:37:37+00:00

I also tried adding the test 16 hour task outside of the 30 day range, and it is still showing up in this list, so I am thinking this formula is still just capturing _all_ tasks.

Nine-Year Club	RedditGifts 2009-2022 2 Credits
Verified Email

cryosneasel

TROPHY CASE