Time-Tracking in Notion: 2 Best Methods in 2023

Поделиться
HTML-код
  • Опубликовано: 15 янв 2025

Комментарии • 101

  • @yannic8402
    @yannic8402 Год назад +11

    Very cool! I also implemented the first method in my workspace and I found a workaround to also use it with teams. Long story short, I filtered in the stop button for only tasks (in your case clients) where the Asignee contains "Me", so that everyone in the workspace can use it simultaniously.

    • @mfreihaendig
      @mfreihaendig  Год назад +2

      Ah fair point, totally forgot about that! 😅 thanks for sharing, I‘ll update the blog post and video 😇

    • @jackpotmonroe
      @jackpotmonroe Год назад +1

      @@mfreihaendig I'm also trying to adapt it to a team of two users. I added the property User to the Time Tracker database. But I gave up as I couldn't make Notion display separately the total time EACH USER spent with EACH CLIENT. I have a feeling it might be possible now with Formulas 2.0, but I still can't figure it out.

  • @na-oori
    @na-oori Год назад +2

    That's really smart! Had a big question mark above my head when you said that we can do that using Button, but now it makes sense. Really creative. Didn't think of using it that way.
    Will try it myself, thanks for sharing!!

    • @mfreihaendig
      @mfreihaendig  Год назад

      Haha yeah it’s not the most intuitive, but once you see it, it all falls into place ☺️
      Let me know how it works out for you!

    • @NandapelosAyres
      @NandapelosAyres 7 месяцев назад

      agree! I came to the video to learn one thing and as a bonus found a solution for other thing. Amazing

  • @dinnerwithgeorge
    @dinnerwithgeorge Год назад +2

    Thanks for the guide. This was a great help

  • @jimpannell2035
    @jimpannell2035 11 месяцев назад

    Just implemented this. Fab! Thanks Matthias. I really like your style of videos btw. Extremely cool and quite funny as well 😂

    • @mfreihaendig
      @mfreihaendig  11 месяцев назад +1

      Oh amazing, that makes me really happy to hear! 😇

  • @vegantechnomad
    @vegantechnomad 9 месяцев назад +1

    Is there a way to make data viz in notion based on the data in the table?

    • @mfreihaendig
      @mfreihaendig  9 месяцев назад

      Well I’m glad you asked 😎
      Notion Charts: The Easiest Way To Get Charts in Notion (For Free)
      ruclips.net/video/LK6FAvjJii0/видео.html

  • @bentebrunia
    @bentebrunia Год назад +4

    to get the total time spent shown in Hours + minutes I used this formula: format(floor(prop("Total Time Spent")/ 60)) + "hrs" + " " + format(floor(60 * (prop("Total Time Spent")/ 60 - floor(prop("Total Time Spent")/ 60)))) + "min"

    • @mfreihaendig
      @mfreihaendig  Год назад

      Awesome! With the new formulas, we don’t even need format anymore, it happens automatically ☺️

  • @MindfulGrinds
    @MindfulGrinds 11 месяцев назад +1

    What a great video. As a non-coder, I have been trying to figure out how to make Notion also do time-tracking because I currently use TMetric. While I like the features, I want to track project time client time, and so on. Also, I wouldn't say I like spending money on templates that often need substantial modification to meet anyone's specific needs. This is a great starting point for me!

    • @mfreihaendig
      @mfreihaendig  11 месяцев назад

      Oh amazing, I’m glad to hear that!

  • @mihen666
    @mihen666 10 месяцев назад +1

    Very cool! Thanks for the tutorial.

  • @DarshanShah10
    @DarshanShah10 Год назад +1

    This is so cool! Thanks for the tutorial :)

  • @labulabuland
    @labulabuland 4 месяца назад +1

    🙋🏻‍♀️alone only, can't team 6:40
    I still don't understand above.. omg 😢. I will check ur blogpost

  • @birgitpestalozzi2722
    @birgitpestalozzi2722 Год назад +2

    It sounds really cool. Now, I wanted to get the time tracking template. Entered my emailadress and then got a file called "Subscriber Special". There are awesome templates in there. But the one template I was looking for, the time tracker template, I can't find. What am I doing wrong?

    • @mfreihaendig
      @mfreihaendig  Год назад

      Just linked it properly, now it should show up - sorry for that! 😇

  • @idromano
    @idromano 6 месяцев назад

    Thank you!

  • @freemind2809
    @freemind2809 11 месяцев назад +1

    Really helpfull! What kind odf screencast tool your are using?

    • @mfreihaendig
      @mfreihaendig  11 месяцев назад

      I use Cleanshot - great tool for a Mac 😇

  • @labulabuland
    @labulabuland 4 месяца назад +1

    🔖9:47 cara 2

  • @tropicaally
    @tropicaally Год назад +1

    hey, could you do a video showing formula examples that we can use in our templates with the latest formula update?

    • @mfreihaendig
      @mfreihaendig  Год назад

      I’ll add it to the list ☺️ although they should be fairly easily to adapt with the formula video on your side 💪🏻

  • @Smaffs59
    @Smaffs59 Месяц назад +1

    With all the updates in Notion during the last year are there now better ways to achieve time tracking?

    • @mfreihaendig
      @mfreihaendig  Месяц назад

      Yes, gotta record a new video soon! 😇

  • @prepos9376
    @prepos9376 Год назад +3

    we NEED a video tour on your entire workspace/system on Notion, please😭😭😭

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      Ah I‘ll add that to the list! ☺️ though it‘s fairly chaotic 😅

  • @pasemes
    @pasemes 11 месяцев назад +1

    Advanced filter configuration made @3:30 on the template is not working for me. When I open a specific Client it shows time trackers of all other clients. Can anyone help?

    • @mfreihaendig
      @mfreihaendig  11 месяцев назад

      Hm have updated the database template on the page? After setting up the filter?

    • @pasemes
      @pasemes 11 месяцев назад

      ​@@mfreihaendigThanks for the imediate response! Yes, I've updated the template on the page. Indeed, this happens even when I create a new Client, the time trackers table shows all rows registered at the moment.
      I also returned to the template and checked whether the filter is there (and it is there). Also, I noticed that the time trackers table on a Client page does not have any filter (I can create one and it works, but it does not come with the one I had set up on the template).

    • @pasemes
      @pasemes 11 месяцев назад

      I have found the problem. I did not have saved the filter for all pages after setting it up. Thanks again for the content and for the help.

  • @Damanjit
    @Damanjit Год назад +1

    Did not found the template link

    • @mfreihaendig
      @mfreihaendig  Год назад

      There’s a form at the bottom of the blog post 😇

  • @ItalianIndie
    @ItalianIndie Год назад +1

    Thank you. I tried the second method but it doesn't work.
    When I start tracking, the task in Toggle has no name. Then I can't see how the tracking should stop in Toggl

    • @mfreihaendig
      @mfreihaendig  Год назад

      Are you on the paid plan with toggle? That’s required for the method to work as mentioned in the video 💪🏻

  • @LuzonSol
    @LuzonSol 10 месяцев назад +1

    why i cant find the first notion template

    • @mfreihaendig
      @mfreihaendig  10 месяцев назад

      It’s part of the 21+ Notion templates you get when you sign up for my newsletter (which you can unsubscribe from asap afterwards if you don’t want to get new templates) 💪🏻
      Linked in the description or via matthiasfrank.de/special/

  • @StoreMarkiito
    @StoreMarkiito 4 месяца назад +1

    Thank you so much for your effort and value, I have a question if I use calendar in Notion and each day I have a template that I fill details on it so it means each day new Table with new ID, is it possible that toggl and make could update them automatically ?

    • @mfreihaendig
      @mfreihaendig  4 месяца назад +1

      Are you creating a new, separate database for each day? 🤔

    • @StoreMarkiito
      @StoreMarkiito 4 месяца назад

      @@mfreihaendig Thank you SIr for your response 🙏, No not separate but I have a DEFAULT template that I use in calendar on each day the same template but each day with new details that I fill on it, and I need to add inside of this ' DEFAULT ' template the time tracking with toggl and Make, like the automation that you explained I want to use them on each day, is that possible or not ?

  • @That.Channel593
    @That.Channel593 Год назад +1

    I can't figure out how to add this to a company that I already have

    • @mfreihaendig
      @mfreihaendig  Год назад

      What exactly are you struggling with? ☺️

  • @outboundcatalyst
    @outboundcatalyst 2 месяца назад +1

    Not sure how to do this across multiple clients. I also changed to tasks but then it still doesn't match the right client even though the task is linked to the same client database...

    • @mfreihaendig
      @mfreihaendig  2 месяца назад

      How does your setup look like? If you have a client relation, this should be fairly straightforward
      You can use formulas on the client level to aggregate all the time values from the individual tasks assigned to that client

  • @Hurrrrricaaaaane
    @Hurrrrricaaaaane Год назад +1

    Great tutorial - thank you! Is it also possible to start/stop the timetracking directly in a table item? So for example you have a database of tasks than you want to start/stop the tracking directly related on a task?

    • @mfreihaendig
      @mfreihaendig  Год назад

      Unfortunately not right now - the button automations don’t provide granular enough controls for that. You’re stuck with the fairly generic commands for now, but I‘m sure they‘ll give us more control in the future!

  • @flowwithmelody
    @flowwithmelody Год назад +1

    Thanks Matthias for those informations! Quick question, I can't create my button as at 5.10 of your video, you are adding a Tracker status and select ' Running'. But mine is empty, there's nothing I can select here! Any help? Thank you

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      Have you created these statuses prior as options in the select property?
      You need to do that step first and then it should show up as an option for the filter in the button 💪🏻

    • @flowwithmelody
      @flowwithmelody Год назад +1

      @@mfreihaendig i didn’t, I need to have a look on how to do that. I thought I knew Notion but learning so much through your channel, it’s a whole new level, thank you for your very quick response!

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      @@flowwithmelody thanks, really appreciate your kind words! ☺️

  • @litdav
    @litdav Год назад +2

    please lower the volume of the sound effects by at least 50%

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      Bit too much? Thanks, appreciate it - are you listening on headphones or with speakers?

    • @litdav
      @litdav Год назад

      @@mfreihaendig headphones :)

  • @Ardillazanahoria
    @Ardillazanahoria 10 месяцев назад +1

    Grazie!!!!!

  • @jleungf
    @jleungf 5 месяцев назад +1

    Great tutorial! I got stuck with the 2nd method when I added the Toggl Track, and the "Project ID" did not show up in my drop-down. I got an error that "value must not be empty". When I toggle on "Map", I didn't see any project ID. I tried using database ID, but it didn't work as I got a few errors when I tried to run Toggle Track. Any idea how to resolve this?

    • @mfreihaendig
      @mfreihaendig  5 месяцев назад

      Do you have a paid toggle account? 🤔

    • @jleungf
      @jleungf 5 месяцев назад

      ​@@mfreihaendig No. I am using a test account. Is a paid Toggl account need to set this up?

  • @m.ehtizan
    @m.ehtizan Год назад +1

    Hey Matthias, I just watched your video and I must say that it was really informative and well-made. I was wondering if I could help you edit your videos and also make highly engaging shorts for you, as well as make highly CTR thumbnails for you?

    • @mfreihaendig
      @mfreihaendig  Год назад

      Appreciate you reaching out! ☺️ no need at the moment but I‘ll keep your offer in mind - there will surely be opportunities in the future!

  • @henrycheney9602
    @henrycheney9602 Год назад +1

    this is exactly what I was looking for, and really well explained. I'm new to Make and I had an error come up when I tried to load my Toggl, it was '[402] Workspace needs to have the Tasks feature enabled' any ideas on what I can do to fix as I can't seem to find any answers online currently! Much appreciated

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      Yes, that’s the error if you’re on the free plan of Toggl - unfortunately, they only allow you to use the task separation on the first paid plan so you’d have to upgrade to use this

    • @henrycheney9602
      @henrycheney9602 Год назад

      @@mfreihaendig hey man, thanks for letting me know that was what caused it, will have to consider the upgrade

  • @pixelsyndikat
    @pixelsyndikat Год назад +1

    Thanks for that awesome tutorial, very happy with the results! I have a question regarding the conversion from Minutes to the hourly display that you added to your blog post --> is it possible to edit the formula so it only counts the minutes with the tag "billed" or "not yet billed"? My notion formula knowledge isn't big enough yet to know wether or how this would work? Any tipps appreciated! B-)

    • @mfreihaendig
      @mfreihaendig  Год назад

      Sure thing!
      You need to add a separate property to the time entries database and use a formula with this structure:
      If(prop(„Billed?“, prop(„Tracked Minutes“),0)
      That assumes that you have a checkbox for billed, if it’s a tag than you could adapt it accordingly
      Then, modify the roll-up to pull in the helper property instead ☺️💪🏻

  • @helenelarmoire
    @helenelarmoire 10 месяцев назад +1

    Hi, it doesn't work. Exactly in the parameters of the button, i can't see "Now" "Today". I find a solution with a column "Creation date" (when I click on I have my Start Time) and a button STOP in another column. I've kept the column End Time. I continue your video. Thank you.

    • @mfreihaendig
      @mfreihaendig  10 месяцев назад

      Hm that’s weird, it shows on my end 🤔 what’s the exact setup your using?

    • @helenelarmoire
      @helenelarmoire 10 месяцев назад

      @@mfreihaendig hi, I'm not sure to understand what "setup" means in this context. I've just followed your video. New database with tasks and I had already had a project base.

  • @xevenau
    @xevenau Год назад +1

    what if the task takes days to complete and you are using method 1? There's no way around that is there?

    • @mfreihaendig
      @mfreihaendig  Год назад

      That would require a different setup indeed - in that case, you don’t track your actual work hours though, right? Here, I would simply use buttons on the task level that fill the start and end time when clicked on this page 💪🏻

    • @xevenau
      @xevenau Год назад

      thats a great idea thanks!@@mfreihaendig

  • @marouaneelbelhadji4464
    @marouaneelbelhadji4464 Год назад +1

    Great video that's what i am looking for, just quick question if i want to PAUSE for e.g 30 min and continue the task later without restart counting, is that possible?

    • @mfreihaendig
      @mfreihaendig  Год назад

      Why do you not want to create a separate timer? 🤔
      In that case, you can simply add one more layer. Add a task layer after projects and then attach the timers to the task. That way, you can track several sessions per task easily.
      You could also add a pause button and then use formulas to deduct the paused amount but that would be a bit more complex

    • @marouaneelbelhadji4464
      @marouaneelbelhadji4464 Год назад

      @@mfreihaendig i see, i will try that thanks for reply and helpful information

  • @piloadami_
    @piloadami_ Год назад +1

    Thanks for the video and template. Does anyone knows how can I connect the client table to a projects table? Ideally when adding a new client name, I would like that data/task/name to be pulled from my projects client's database so they're all interconnected. The idea is that when I look over a project I can have a column linked to the database. I can then click on that link which takes me to the database system. Even better, is there a way to have the start/stop button within the project table which then connects to the database? many thanks

    • @mfreihaendig
      @mfreihaendig  Год назад

      Sure thing! You wanna use a relation to connect the entries and then rollups to get information from one database into the other
      If you don’t know how they work, I recommend you check out the third and fourth chapter in this Notion tutorial:
      ruclips.net/video/ivQ_9-gn1iI/видео.html

    • @piloadami_
      @piloadami_ Год назад +1

      ​@@mfreihaendigthanks for shining a light on it. So I added a relation from the projects database to the client timesheeet I now have a new column in the projects database which I can link to the clients on the timesheet database. Now how can I access the time tracker inside the clients page trough the project database? I was hoping to access it via the new column created but because that's a relation it's just a link, not an access to the clients template page with the timer function. does that makes sense? :)

    • @mfreihaendig
      @mfreihaendig  Год назад

      @@piloadami_ you can use a roll-up or formulas to pull the link to the tracker to the project based on the assigned clients 💪🏻

  • @andresfernandez2811
    @andresfernandez2811 7 месяцев назад +1

    Gotta go fast!

  • @davidcarao6421
    @davidcarao6421 Год назад +1

    hi Mathias, a question, if i have two or more Track Status at Running, how i can filter for that I Stop only one the Track Status

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      You can’t right now - with multiple timers, you’d need to use the second method until Notion offers more granular controls over button filters

    • @davidcarao6421
      @davidcarao6421 Год назад

      @@mfreihaendig ok Mathias, thank you for you answer. I going to wait this update.

    • @davidcarao6421
      @davidcarao6421 Год назад

      @@mfreihaendig Hi Mathias, what other method i can use for this??

  • @O.RafaelDiniz
    @O.RafaelDiniz 4 месяца назад

    Notion could had relsead this feature native. Thanks for the tutorial!

  • @MVS_DJGillyGill
    @MVS_DJGillyGill 10 месяцев назад +1

    i tried to implement the formula on method one but it comes out a bid different. is this still a viable method? it seems the notion made changes to formulas (2.0): dateBetween(prop("End"), prop("Start"), "minutes") : this is the formula I am talking about ..any help would be appreciated ...if i paste that in it gets converted to : dateBetween(End, Start, "minutes").
    with an error: End is not defined. [12,15] Start is not defined. [17,22]

    • @mfreihaendig
      @mfreihaendig  10 месяцев назад +1

      No the formula template still works - dateBetween(END DATE, START DATE, „minutes“) - you just need to have the corresponding properties correctly named 💪🏻

    • @MVS_DJGillyGill
      @MVS_DJGillyGill 10 месяцев назад

      ohh okay thank you@@mfreihaendig

  • @nooreldiensoltan1419
    @nooreldiensoltan1419 Год назад +1

    This video is what I want. I've already done mine, but I was just looking to organize the databases in a separate table like you did.
    Thank you so much🙏 .
    Do you have any idea how I can add another two buttons to stop the timer while working and continue it later? It's as if something interrupted me. How can I pause the timer and continue it without putting these data in the time tracker? (START, PAUSE, CONTINUE, STOP)"

    • @mfreihaendig
      @mfreihaendig  Год назад +1

      Glad you like it! 😍 for the start stop one, you would need to build another level down - sort of a „sub-tracker“ database. Pausing the timer would create a sub-tracker item with a start pause and end pause time. Based on that, you calculate the total Time paused, roll it up and deduct it from the time tracked on the tracker level 💪🏻