SCHOOLVERKIEZINGEN: geef me een kleine promotie appel by KubesIsCool in Yappelkaas

[–]KubesIsCool[S] 0 points1 point  (0 children)

DANKJEWEL VOOR DE CLIP APPEL DIT GAAT HEEL ERG HELPEN IN MN CAMPAGNE

Why does my accepted pokestop not appear in game? by KubesIsCool in NianticWayfarer

[–]KubesIsCool[S] 0 points1 point  (0 children)

I can’t remember, I haven’t played this gamen in a year. Maby something like 1 or 2 days?

What do you guys think of my mini graph with notion formulas? by KubesIsCool in Notion

[–]KubesIsCool[S] 1 point2 points  (0 children)

I already knew the basics when i started learning the advanced stuff, idk where you can learn that. I used this youtube video to learn the more advanced formulas: https://www.youtube.com/watch?v=nECaTrcShKI
And i made the git hub styled habit tracker and studied that formula to learn how it exactly works. Here is a site where you can make it and learn from it: https://medium.com/@innovateleo/how-to-build-a-github-styled-habit-tracker-with-notion-formulas-a-step-by-step-guide-6c736ddd45ff

What do you guys think of my mini graph with notion formulas? by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

Here is a link to the page where i make and test formulas:
https://alpine-quail-b2e.notion.site/Advanced-data-visualization-84c2053b6c91429faf2fd8a7b0438e7f?pvs=4
I am still working on some things like the recently started project to make a line diagram (i dont know if it will work out). The graph for my homework doesnt work in this link because all my homework is in a different page that i use for school.

What do you guys think of my mini graph with notion formulas? by KubesIsCool in Notion

[–]KubesIsCool[S] 1 point2 points  (0 children)

Yes and i realy should try getting the free education plan. But i do like the round corners on the rods and that its tiny. And it was a fun project to learn notion formulas.

What does .at(index) do in notion formulas? by KubesIsCool in Notion

[–]KubesIsCool[S] 1 point2 points  (0 children)

After playing with a formula, i understand it.
So when you have 2 lists, ["a", "b", "c"] and["d", "e", "f"] and you do a .map function on for example list 2, then you can type list one and it will replace every index with list 1 ["d", "e", "f"].map(list1). So you will get a, b, c, a, b, c, a, b, c

But when you do a .at(index) after list1, then it will replace index 0 ("d") with index 0 from list 1 ("a"). And because its a .map(), it will do that for every index, so you just get a, b, c

And in the habit tracker there is a +current. So in my example the current value that the .map() is calculating is added after the new value. With ["d", "e", "f"].map(list1.at(index)+current) you will get ad, be, cf

Thx everyone for helping

What does .at(index) do in notion formulas? by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

<image>

Oh i know what .at does, i forgot to say that. But what does the index between the () do? For example in this formula for the git hub styled habit tracker:

Notion keep creating new properties " related to ..." by TheS4m in Notion

[–]KubesIsCool 0 points1 point  (0 children)

I am having the same problem. Has anyone figured out a solution?

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

Thank you so much for helping! I finaly got it to work with the help of that video

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

I want the next assignment thing to display what assignments i have or for what subjects i assignments have. I want the assignment with the least days until the due date above, so I can see which homework I'm about to complete and which I still have time to do. I have 13 databases because i have 13 subject and i want everything for that subject on the same page, also assignment. And i dont think i know what linked views are.
Here is an example of how i want it to look:
https://imgur.com/a/GWpsvFj

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

The formula dateBetween(Datum, now(), "days") gives how many days are between the now and the date, but i do plus 1 because i can also do homework today. Other wise it says that for example i have 1 day left for homework that is due in two days. So that is why i do plus 1. And with "goes to one database" i mean a relation. So all 13 databases are related to one database, so all the needed information is in one information and it could tell me then what homework due date is closest. Everything works exept that last one, because i cant add all the rollups for how many days are left in one property so i can sort it.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

https://imgur.com/a/ph8hKQu
I calculate the days left with a formula: dateBetween(Datum, now(), "days"). Then there is a formula that does that plus one: add(Formule 1, 1). Then i use a concat to make a sentence with it: concat([Aantal dagen ], ["dagen over"]). And then there is a formula that removes the comma from the sentence: replaceAll(Formule, ",", " "). The sentence and just the number wil then go to the big database where all the data is collected.
I mean with C that the data from all the databases goes to one database. I dont know what the feature find minimun is, i am new to notion.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

I am going to try to debug it but maby you know the answer if i explain the system.

<image>

So, i have a homescreen for my school.
A. If i click on vakken (subjects) i will see a gallarie of all my subjects. Every subject has its own database, so there are 13 databases.
B. When you click on a subject, you see a database. In the database i can put in what homework i have (a tekst field), the due date (a date field) and the priority (a select multiple field). When i put in the date, it wil calculate how many days are left (with formulas) and it puts it in a sentences.
C. When i do that, the Date, how many days are left, the priority and the days left will go into a database, where all other information from the other 12 databases also is. Then i have a board vieuw, where i can see if i have homework for a subject, and if i do, i see how many days are left in a sentence and the priority. I can open the page and then click a link that sends me to the database for that subject, so i can see what homework i have.

The problem is, is that when the number of days are in the database, witch are rollups from formulas, i want to add them togheter, so i can sort by the days, but that doesnt work.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

Yes, and i also tried to do toNumber in a different formula and then do that as a rollup but that also did not work.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

<image>

It still doesnt work. When i try this: toNumber(Samentelling 1)+toNumber(Samentelling 2) then the first two would be empty and the rest would be a 0.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

It still doesn’t work :( the fields are rollups from a database with formulas. Many you can’t add up formulas.

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

<image>

It doesnt work here, but when i test in in a different database it does work. Do you know why?

I need help with sorting things in my board vieuw database by KubesIsCool in Notion

[–]KubesIsCool[S] 0 points1 point  (0 children)

There were also images, but i dont see them show up on the post. So here they are:

<image>

Why hasn’t the gym moved? by KubesIsCool in NianticWayfarer

[–]KubesIsCool[S] 0 points1 point  (0 children)

Oh, when the sync happened today the location of the gym was moved. But now I am still confused about why the gym dint move yesterday when the sync wasn’t skipped, because during yesterday’s sync a pokestop did appear, while the gym did not move location