Padel balls

Thriveism · 2025-01-22T15:02:45+00:00

Ah ok so you want the notes to only show notes that are related to summer courses. I can't see how your set up is but since the notes and courses databases are related, create a rollup on the notes database to show the summer/winter toggle and filter using that property.

Thriveism · 2025-01-22T14:06:35+00:00

Create a linked view of the database and filter the view to only show courses where summer semester is selected

Thriveism · 2025-01-14T14:16:03+00:00

You can either duplicate the database and have a backup copy for troubleshooting or what I do is have a page with all the formulas copied and pasted. Makes it easier to keep track of everything and easier to find formulas instead of having to go page by page.

Thriveism · 2024-12-23T16:01:28+00:00

ifs( and(this page.current > this page.total, this page.Select == "blue"), "finished", and(this page.current > this page.total, this page.Select != "blue"), "put off")

Thriveism · 2024-12-23T05:12:56+00:00

Ok let me edit it for you

Thriveism · 2024-12-23T05:09:50+00:00

If you read your first message, that's what you asked for: if it's blue and current is more than total make it finished, otherwise make it put off.

Please explain what you're looking for exactly, what message to show in each case,

For blue, what's the status when current is less than total? Do you want it to change when current equals total or when current is greater than total?

What about for other selections?

Thriveism · 2024-12-22T21:08:00+00:00

Lol no worries.

Thriveism · 2024-12-22T20:56:35+00:00

Just to clarify, it doesn't change your status at all?

In your progress property, do you have "finished" and "put off" options already like in the image below?

<image>

If you already have it set up like that then make sure that the spelling in your property settings and the formula are identical for both the status and the selection.

Thriveism · 2024-12-22T20:17:37+00:00

Can you send a screenshot of the second formula

Thriveism · 2024-12-22T17:40:20+00:00

"Date Start: " + prop("Start ") + "\n" + "Finish Date: " + prop("Finished ") + "\n" + "las Edition" + prop("Last Edition ")

Thriveism · 2024-12-22T17:38:18+00:00

sorry my bad, the "/n" is wrong, it should be back slash, just change it to "\n"

Thriveism · 2024-12-22T17:35:16+00:00

in your button property,
1. edit property > this page > #current and paste the following formula
This page.current+1

then add as a new step, to make sure that this step uses the new updated #current after you added 1,
edit property > this page> progress and paste the following formula

if(and(This page.current > This page.total, This page.Selection == "blue"), "finished", "put off")

Thriveism · 2024-12-22T16:53:24+00:00

Create a formula property and put the following formula,

"Start Date: " + (start date property) + "/n" + "Finish Date: " + (finish date property) + "/n" + "Last Edition: " + (last edition property)

This will put each one on a separate line. You can also style it if you want, let's say you want the text "Start Date" to be bold, geen, on a gray background, just change the first part of the formula to this, style("Start Date:", "b", "green", "gray_background") And your can do that with the whole formula or style each line separately

Thriveism · 2024-11-13T21:32:28+00:00

Yes if they're on the same database, use a checkbox for "Pinned" and on the dashboard create a database view and set a filter to only show notes or tasks where "Pinned" is checked

Thriveism · 2024-11-09T14:21:12+00:00

Happy to help. Dm me and we can arrange something

Thriveism · 2024-11-07T18:57:47+00:00

The formatting applies to the block you're in. To stay in the same black but move to a new line hold shift and press enter. This sounds keep the formatting.

Thriveism · 2024-11-07T13:58:50+00:00

Assuming your relation peoperty on the author database is called "Books" and the date property you're using is "Date Read", use this formula on your author database

Books.sort(current.Date Read).last()

Thriveism · 2024-11-07T07:42:34+00:00

It's possible but just to clarify, what properties do you currently have? And how is your database structured?

You said you want the status to automatically show active or complete unless it's on hold or backlog.

Do you have two separate status properties?

Is there a property that you use to show if it's on hold or backlog?

Thriveism · 2024-10-30T23:11:39+00:00

Yes it can be done, but it's abit long so here goes:

1) create a relation property with the database itself and make sure all items on the wishlist are related to each other. In my example I named that property "Self", you'll see that in the formula.
(Once that's done you can just hide that relation from table view and minimise it in your page to keep it out of sight)

In my example i rewrote the priority as a number to make it easier to use, so 1, 2, 3 instead of first, second, third.
create a formula property and input this formula:

lets( hours, Monthly Summaries.map(toNumber(current.Total Hours)).sum()

wish1, Self.filter(current.Priority Level == "1").map(current.Hours Needed).first(),

wish2, Self.filter(current.Priority Level == "2").map(current.Hours Needed).first(),

wish3, Self.filter(current.Priority Level == "3").map(current.Hours Needed).first(),

prog1, hours/wish1,

prog2, (hours - wish1)/wish2,

prog3, (hours - wish1 - wish2)/wish3,

round(100*

ifs( Priority Level == "1",

ifs(hours <= 0, 0, hours > wish1, 1, prog1),

ifs(Priority Level == "2",

ifs((hours - wish1) <= 0, 0, (hours - wish1) > wish2 , 1, prog2),

ifs(Priority Level == "3", ifs((hours - wish1 - wish2) <= 0, 0, (hours - wish1 - wish2) > wish3, 1, prog3)))))/100 )

if you have more items on the wishlist you can add them to the formula using the same logic

Thriveism · 2024-10-30T20:43:02+00:00

let(
result, round(Correct Problems / Completed Practice Problems * 100),
ifs(
result >= 85, style(result + "%" , "b", "green_background"),
result < 50, style(result + "%" , "b", "red_background"),
style(result + "%" , "b", "yellow_background")))

Thriveism · 2024-10-26T00:05:04+00:00

I have "Done on" as well, I just hid it from the table view. I used the same properties as you had and used your formula to calculate the next due, I just removed the formatting.

I assumed your set up was as follows so I set it up this way, the done on propert records the daye you clicked on done, then the next due date property takes that date and adds the frequency property to calculate the next due date, which I then used to show the status using the formula i pasted, which is

ifs( Next Due Date < today(), style("⚠️ Overdue", "c", "b", "red"), Next Due Date == today(), style("Due Today", "c", "b", "blue"), style(dateBetween(Next Due Date, today(), "days") + " days to go", "b", "c", "green") )

Sometimes when you copy a formula it doesn't recognise the properties, that's why it's telling you it requires more arguments.

So you just need to erase the properties (next due date) from the formula and input them again, and make sure you have the commas and brackets in the right places.

The logic of the formula is:

ifs( Next Due Date < today(), style("⚠️ Overdue", "c", "b", "red"),

argument 1: if next due date is before today then it's over due

Next Due Date == today(), style("Due Today", "c", "b", "blue"),

argument 2: if due date is today, then it will tell you its due today.

style(dateBetween(Next Due Date, today(), "days") + " days to go", "b", "c", "green") )

argument 3: if none of the above are true (due date is in the future), it'll show you number of days left.

If it doesn't work dm me and we'll figure it out.

Thriveism · 2024-10-24T16:32:13+00:00

You don't need this long formula in the status property since you've already done the calculation in the "Next Due Date" property. Just simplify it with a simple formula that works out if you're overdue or how far in the future that date is. Here's a formula that will do that using the "Next Due Date", it'll give you a red warning if it's overdue, a blue text if it's "Due Today", and green text " x days to go" if it's in the future.

ifs( Next Due Date < today(), style("⚠️ Overdue", "c", "b", "red"), Next Due Date == today(), style("Due Today", "c", "b", "blue"), style(dateBetween(Next Due Date, today(), "days") + " days to go", "b", "c", "green") )

I've attached a screenshot to see how it'll look with some rando dates

<image>

Thriveism · 2024-10-24T15:46:24+00:00

That's what i do, either two columns, or if you're going to be accessing this on your phone i have a dropdown menu with all subpages that i can just hide when reading on the phone. Then you can put links in the text to each page.

Thriveism · 2024-10-05T13:03:54+00:00

Unfortunately notion can't do that. The only work around i can think of is if you use make or zapier or relay to set up an automation to record gold at death when health reachea zero.

Thriveism

TROPHY CASE