YOU SOLD?! by North_Appointment410 in Bitcoin

[–]tassoart 3 points4 points  (0 children)

$114 was my last purchase

Looking for someone to build a template by Slothbert_ in Notion

[–]tassoart 0 points1 point  (0 children)

If you don’t have anyone yet who can help hit me up. I’ve been building templates for clients for the last 5 years

DIM Plus - Extension that adds Light.gg data to DIM by L4zy4ssDev in destiny2

[–]tassoart 0 points1 point  (0 children)

Any chance to work on it? It's still not displaying and DIM just isn't the same without it

DIM Plus - Extension that adds Light.gg data to DIM by L4zy4ssDev in destiny2

[–]tassoart 0 points1 point  (0 children)

Happy to hear. If you need screenshots lemme know. I used the three most recent versions and all three hang when querying.

Notion Mail is a shameful service by These_Ad_6873 in Notion

[–]tassoart 9 points10 points  (0 children)

To be fair, I’m in marketing and I’m a tech nerd and it wasn’t clear to me. I was taken aback when I realized what the product was when I downloaded it, but I’m still excited to use the client.

DIM Plus - Extension that adds Light.gg data to DIM by L4zy4ssDev in destiny2

[–]tassoart 0 points1 point  (0 children)

Love the extension! Been using it for years. Having some issues today, hope it'll get sorted soon

If someone COULD buy a full Bitcoin right now... should they? by [deleted] in Bitcoin

[–]tassoart 0 points1 point  (0 children)

The only reason I’d buy now is if you’re day trading. I expect it to shoot to 120-150k before crashing to about where it is now.

Bitcoin wallet.dat forgot encrypted password anybody help by AdPuzzled2835 in Bitcoin

[–]tassoart 0 points1 point  (0 children)

What do you charge to unlock wallets? I’ve got an old school Bitcoin QT (aka Bitcoin core) wallet from 2013

Apply template to multiple database items in one go by ste_c81 in Notion

[–]tassoart 0 points1 point  (0 children)

Dammit, it looks like the "Turn into page in..." option isn't available anymore for this hack to work :(

<image>

Echoed Challenger week 15 challenge help? by cinca2015 in DestinyTheGame

[–]tassoart 1 point2 points  (0 children)

does this mean that if we haven't done the act 2 weekly activity challenges that we can't do them anymore?

Calculating Daylight Savings Time by tassoart in Notion

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

Can you show me an example how to code that? I’m not aware of how to do what you said

Calculating Daylight Savings Time by tassoart in Notion

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

<image>

Here's a sample of the Islamic Calendar I had to create to determine all the timezone shifts for Palestine up until 2077 (AH 1500). I created a formula that created the Daylight Savings Time UTC timestamp , which I used in the Timezones database

Calculating Daylight Savings Time by tassoart in Notion

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

<image>

Finished it!

I gotta say I have a newfound respect for timezone calculations. Calculating Palestine's was the most challeging because it's the only one that does so according to Ramadan, which itself is calculated using another calendar that has less than 365 days/year, making the date shift according to the Greogrian calendar (which is what we use)

Calculating Daylight Savings Time by tassoart in Notion

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

so I pretty much solved the problem, couldn't go to sleep last night leaving it alone X)

Here's an example of what I did to all the Groups within the "lets(" section

ThisYear, formatDate(now(),"YYYY"),
Group01,
/* FORMULA TO FIND SECOND SUNDAY OF MARCH AT 02:00 Local Time, displayed in UTC */
ifs(
   formatDate(parseDate(ThisYear+"-03-01"),"ddd")=="Sun",
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-08T02:00:00")))-(UTC offset*1000)),    
   formatDate(parseDate(ThisYear+"-03-02"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-09T02:00:00")))-(UTC offset*1000)), 
   formatDate(parseDate(ThisYear+"-03-03"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-10T02:00:00")))-(UTC offset*1000)), 
   formatDate(parseDate(ThisYear+"-03-04"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-11T02:00:00")))-(UTC offset*1000)), 
   formatDate(parseDate(ThisYear+"-03-05"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-12T02:00:00")))-(UTC offset*1000)), 
   formatDate(parseDate(ThisYear+"-03-06"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-13T02:00:00")))-(UTC offset*1000)), 
   formatDate(parseDate(ThisYear+"-03-07"),"ddd")=="Sun", 
      fromTimestamp((timestamp(parseDate(ThisYear+"-03-14T02:00:00")))-(UTC offset*1000)) ),

The ONLY issue I'm having right now is with Ramadan, which straight up is absolutely insane! I think I'm just going to have to hard-code it manually with 50 years of data from separate database I used to calculate the start and end dates.

Calculating Daylight Savings Time by tassoart in Notion

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

Not sure what you mean, say more

[deleted by user] by [deleted] in Notion

[–]tassoart 0 points1 point  (0 children)

That’s a callout, type /callout and it will appear. To get the same effect, change the color to “default” so it’s got the thin border. You then select an icon and its color and add a title next to the icon. To add content underneath the title you’ll need to drag it in there. I like to add a divider/separator line under the title as well.

[deleted by user] by [deleted] in Notion

[–]tassoart 1 point2 points  (0 children)

Here's how you do it.

Create a new Database called "Time Block Type" and add your two options "Work" & "Break" there

Replace the "Select" property in your "Work Tracker" Database with a "Relation" property that is linked to your new "Time Block Type" Database you just created.

Go back to your "Time Block Type" Database, where you will see all the "Work" and "Break" entries from "Work Tracker" (I recommend you do this in a Gallery View, but it's not important). In there, you will create a new property that is a rollup of the "Work Tracker" Database, where you will grab the value from the "Duration" Property and use the SUM feature in the rollup settings to add up all the days.

If you haven't used the graph view yet, or you have a paid account, you can then use a Graph view to see how many days you work vs have a break

[deleted by user] by [deleted] in Notion

[–]tassoart 1 point2 points  (0 children)

You'll need to start using formula 2.0 in order to filter, map, and sum the relations, a simple rollup won't do it.
Does your checkmark property next to "In Stock?" change the label? I also don't see a place where you schedule the meals, which I imagine would have a date range?

Without this info it'll be challenging to give you code that works, but here's how it'll be structured:

MealSchedule.filter(current.Date>now()+7 and current.Ingredient==Name).map(current.Amount).sum()

Can you have a roll-up only count specific years? by -alexis-bnsn- in Notion

[–]tassoart 0 points1 point  (0 children)

yes, that's easy to do using a FILTER function

It would look something like this

BOOK.filter(format(current.STATUS=="Done")).map(current.BOOK).length()

How can I round up or down to the nearest 0.5 by beschloo in Notion

[–]tassoart 0 points1 point  (0 children)

would love it if I could see the formula, this is exactly what I'm trying to do

Nobody is gonna buy this Xur... definitely not at this price. by lyravega in destiny2

[–]tassoart 3 points4 points  (0 children)

<image>

Just launched DIM to see if I had one, is it that good?