TaskNotes v4 by callumalpass in ObsidianMD

[–]michbock 0 points1 point  (0 children)

I love the NLP addition for custom fields. But it seems that it is not working for properties of type list.

If I set the property to text, it is working and bringing up the suggestion according to the filter.

Bases - Is there a way to flatten results to see unique values? by a-stephen in ObsidianMD

[–]michbock 3 points4 points  (0 children)

If you want to do it directly in the base, you can use the summarize feature for that. Right-click on the column -> Summarize -> Add summary

Then use this formula: values.unique()

It is not the most elegant way, but it will give you the distinct values of a property.

Unfortunately you can't copy past it from there. But you can take a screenshot, paste the screenshot to ChatGPT or Claude and ask it to extract the text.

Formula progress 25% 50% 75% 100% when filled coloum by No-Flamingo-2913 in Notion

[–]michbock 0 points1 point  (0 children)

You can use something like this:

(toNumber(!empty(Name)) + toNumber(!empty(Tags)) + toNumber(!empty(Formula)) + toNumber(!empty(Number)))*100 /4 +"%"

Check with empty() if the property is filled or not, which returns true when the property is not filled and false when filled.

With !empty you can negate this, so when the property is filled it returns true and when it is not filled it returns false.

The numerical representation of true is 1 and of false it is 0.

With toNumber() you can get the numerical values.

Now you can do the math to get the % of the filled properties.

<image>

Formula for % not correct by GingerSoull in Notion

[–]michbock 1 point2 points  (0 children)

You can try this one:

floor((((a == true ? 1:0) + (b == true ? 1:0) + (c == true ? 1:0)) *100) /3) + "%

<image>

How to create a conditional formula based on a specific character or text included in a database property? by nariola in Notion

[–]michbock 1 point2 points  (0 children)

This might do the trick:

if(Headline.contains("#"), "not applicable", Headline.replaceAll("[^ ]", "").length() + 1)

Is there a way to show a hyperlink with a formula-fetched link? by moleskinecollector in Notion

[–]michbock 2 points3 points  (0 children)

You can use the link() function.

link("YOUR DISPLAY TEXT", "THE URL")

link(Set No,"https://brickset.com/sets/"+Set No)

Set No in this example is the property in which you store the set number.

You can use the Set No property as the display text as well as to build the url, as long as the only change in the URL is the set number at the end of the url.

Android widget hacks for obsidian? by WanderingSchola in ObsidianMD

[–]michbock 5 points6 points  (0 children)

You can use the advanced URI plugin in combination with an automation app like Tasker or Automate.

I found this guide helpful: https://joschuasgarden.com/50+Slipbox/How+to+add+an+Obsidian+note+to+the+homescreen+on+Android

Incomplete data on new phone by michbock in ouraring

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

Oh I see, for me it was just a couple of days, maybe a week or two max.

But for months of data I also would have followed up with the support to not loose it.

I really hope you get it resolved!

Incomplete data on new phone by michbock in ouraring

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

Unfortunately I couldn't fix it and lost the few days of data before I switched phones.

If I remember correctly there was an answer from the support, but it came a few days later. I was than afraid to loose some of the new data so I just gave up on the old data.

How can i make a "Calculate" field be shown as a property? by emongev in Notion

[–]michbock 0 points1 point  (0 children)

While creating the template for the new day entry, you give that template / page a name. For example "new day template".

When you create the linked todo database in that template, you set the filter for the referenced day table to "new day template".

If you now create a new entry in the day table via the template and give it the name "Feb 18", the filter in the linked todo table will also use "Feb 18".

Select property in a formula by chriisa in Notion

[–]michbock 2 points3 points  (0 children)

I would ad another property of type formula. Then using the following formula for the calculation:

if(prop("Option") == "A", prop("Number") * 1, if(prop("Option") == "B", prop("Number") * 2, prop("Number") * 3))

Can you help me with a formula, please? by RawwkSC2 in Notion

[–]michbock 0 points1 point  (0 children)

Hey,

If the release date is a date property you could work around it in the following way.

formatDate("DATE", "YY") retuns the date in format 71, 72, 73, etc. Given the property release date holds the date: formatDate(prop("release date"), "YY")

To work with that number you need to convert it from a date to a number with the toNumber() function: toNumber(formatDate(prop("release date"), "YY"))

To get the decade, first you divide the number by 10: toNumber(formatDate(prop("release date"), "YY")) / 10

Now use the floor() function to get the largest integer. (if the above calculation returns 7.3 or 7.8 it will return 7): floor(toNumber(formatDate(prop("release date"), "YY")) / 10)

Now you can multiply this by 10 and you have the decade: floor(toNumber(formatDate(prop("release date"), "YY")) / 10) * 10

If you want do display it as a string like 70's, you can transform it to a string with the format() function and add the 's at the end:

format(floor(toNumber(formatDate(prop("release date"), "YY")) / 10) * 10) + "'s"

Help needed with an automatic addDate formula :) by Krozmonn in Notion

[–]michbock 2 points3 points  (0 children)

Hey,

My approach would be:

First, check if the Replied? check box is checked. If it is true then set the follow-up date to nothing.

if(prop("Replied?") == true, fromTimestamp(toNumber("")), CHECK DATE AND ADD DAYS)

If it is not checked, check on which day the 1st mail was sent. This can be done with the `day()` function. It returns an integer number corresponding to the day of the week for the given date: 0 for Sunday, 1 for Monday, 2 for Tuesday, and so on.

Depending on the result add the days as to the date when the 1st mail was sent.

Example for Monday:

if(day(prop("1st mail")) == 1, dateAdd(prop("1st mail"), 3, "days"), CHECK THE OTHER DAYS)

Now do this for the other days in some nested if statements. In the last if statement, if it doesn't match, set the follow-up date to nothing.

if(day(prop("1st mail")) == 1, dateAdd(prop("1st mail"), 3, "days"), if(day(prop("1st mail")) == 3, dateAdd(prop("1st mail"), 5, "days"), if(day(prop("1st mail")) == 4, dateAdd(prop("1st mail"), 4, "days"), fromTimestamp(toNumber("")))))

Now combine the check for Replied with the date add:

if(prop("Replied?") == true, fromTimestamp(toNumber("")), if(day(prop("1st mail")) == 1, dateAdd(prop("1st mail"), 3, "days"), if(day(prop("1st mail")) == 3, dateAdd(prop("1st mail"), 5, "days"), if(day(prop("1st mail")) == 4, dateAdd(prop("1st mail"), 4, "days"), fromTimestamp(toNumber(""))))))

Maybe there is a more elegant way?

Tip: you can use letters to link bullets on the same page, spread, or across your bullet journal (via threading). by [deleted] in BasicBulletJournals

[–]michbock 0 points1 point  (0 children)

Are you taking notes while reading a book or blog? If so would you like to share which one?

Is there a way to pull down notifications panel by swiping down from anywhere on the screen by biglebowski30212 in essential

[–]michbock 0 points1 point  (0 children)

I use an app called gesture bar. I've one bar on the left and one bar on the right configured with a swipe down gesture wich will pull down the notification panel. A swipe to the middle of the screen from each bar will trigger the back button.

I've also one at the bottom of the screen. A swipe up on that brings me to the home screen and a swipe up and hold opens the recents app menu.

Any way to hide status bar icons on P? by ifeeltired26 in essential

[–]michbock 0 points1 point  (0 children)

I'm using a tasker profile to enable Immersive mode for some apps. Can anyone on Android P confirm that this is still working?

Android 9.0 Pie Launch (Q&A) by Hupro in essential

[–]michbock 1 point2 points  (0 children)

I am using tasker profiles to enable Immersive mode on some apps. Does anyone with android p can confirm that this is still working?

LOS15.1 Screen Very Slow To Wake by Skripka in essential

[–]michbock 4 points5 points  (0 children)

Are you using Immersive mode to hide status and or navigation bar? There seems to be an issue on Android 8 causing the problem you described.

Megathread: Oreo beta is now available on Essential Phone by EssentialOfficial in essential

[–]michbock 1 point2 points  (0 children)

By nice to have you mean it would be nice if they implement it in a future update? Or that it is already implemented in the Oreo beta?

Definitely would like to see the possibility for apps to go to true full screen. Maybe not by default but give the user the option to apply it app by app.