Build a time tracking application in 20 minutes
HTML-код
- Опубликовано: 15 сен 2024
- ► Hire a Coda expert! Contact us at info@simpladocs.com or start chatting with us here: www.simpladocs...
► Learn Coda for FREE in 30 days: coda.grsm.io/3...
► Sign-up for Coda: coda.grsm.io/t...
► Become a Coda expert: www.codaschool.io
► Coda templates: codatemplates.io
► Template for this video: buy.stripe.com...
Come along with me as I make a complete time tracking application in under 30 minutes! Along the way, I'll explain a massive amount of Coda fundamentals, formulas, and tricks that are applicable to help you in any of your docs.
#coda #codatips #codaio #lowcode #nocode #automation #productivity #productivityhacks #workflow #workflows #projectmanagement #notion #airtable #clickup #excel #google #googledrive #timetracking #asana #timemanagement #timemanagementtips
![Eminem - Fuel (Shady Edition) feat. Westside Boogie & GRIP [Official Audio]](http://i.ytimg.com/vi/k1OquBida9s/mqdefault.jpg)
Coda Guy indeed 😉
Thanks for the tutorial. Clear and straight to the point.
You got it.
Hello, thank you very much for the content!! A tip for a next video would be to use prompts in chatgpt to help create formulas in coda
Are you going to make a follow up on how to create the graphs?
Any particular reason why the the visual timer might be flickering even when the timer is not running? I can't figure out what it's doing. I noticed also that if you do not use the pause function, the time logged does not log the total duration, so if you just use start and stop with no pauses, it doesn't log any time at all in the time logged. Is there a way to fix this?
This tutorial is very interesting because of the method you used to log times and the pause time tracking.
The time tracker I previously created had Start & Stop buttons (never thought about tracking Pause time) which added a new row for each Start/Stop session directly to my time tracking table which you have as DB Logged Time.
I think your method is more performant because the per session time duration is only being calculated once in the Timer table and then moved to the DB Logged Time table. With my method the per session duration is calculated on each row everytime the table is viewed.
I've never seen another using this method in a Coda time tracking app.
However, I do have one question. Does your method work with multiple workers?
It would seem to be an issue because multiple users tracking tasks at the same time would override the Start/Stop times.
I think a possible solution would be to create a separate row for each user/worker on the Timer table. Would that work?
Right now the template I made was optimized for a single user! But it would be easy to extend it for multiple users by simply creating a PEOPLE column and having each button add the current user() who presses it.
Then filter all your tables by the user() in the PEOPLE column you created
So helpful, thanks! One hiccup - though my Coda settings, table/button formulas mimic yours it is adding the wrong time [zone] to my table. Coda and computer both set to Central, but button adds as Eastern...
Hi! How about the dashboard? How do we calculate all time spent in doing a project/task?
+1 kinda sucks to explain only half the feature... coda is expensive enough as it is without having to pay extra for templates after someone explain only half, where is the feature for billable or the charts etc.
Hey I can't find Logged Stop in my doc for this portion of the video ruclips.net/video/OATUZGUoMTU/видео.html any ideas where I can find this?
what ide did you use?
Too bad I can't "like" this multiple times over 😊 Huge thanks!
Always
Hey I am Notion and ClickUp user, want to move to Coda, but not sure how to set up central dashboard, so I ll have different projects, databases (must be different for protecting data sensitive private from work related that employees see), but I want a central dashboard where I can see all tasks personal or work in same spot. Any video about it? Do not find lots of tutorials on Coda compared to Notion or Clickup. Thanks.
I've been exactly there with Notion & ClicUp, Still using both and I consider myself as an intermediate Coda user and I love it. I was trying to replicate Notion dashboard in Coda. What I've found out is that you can't have it the same way Notion is doing it. One of the few advantages of Notion over Coda is the relational databases and how it's available to any page instantly. In Coda, each Doc lives on its own universe, by default a database on Doc A can't be viewed in Doc B. You must use Coda packs to connect both Doc. Or should I say, connect any number of Docs together so you will be able to view databases inside the Doc you are using the pack with. The Coda pack that will achieve this is called Cross-Doc pack. The other essential pack is Coda Doc List and it's dispensable for me. Basically, it lists all Docs you have in your workspace. I couldn't imagine using Coda without it.
This route Coda is using to connect Docs together forces you to restructure the home dashboard. Simply, it can't be the same way as in Notion. What I did is the following:
1. I have a master Doc for all Docs I have in my workspace using Coda Doc List pack. In this Doc, I'll do categorizing, filtering of all Docs that I need to view in my Dashboard. What is nice about Coda Doc List pack is that it brings in a table all Docs attributes to the database in the Master Doc (folders, date created, user, etc.). You can choose which attribute to show, you can also add new columns etc.
2. I added a check box column for all Docs that I want to see in my Dashboard. Then I create a page (To Dashboard) that includes a filtered view of the Master Doc List where the Check Box is checked. This page will be used in the following step. Because I don't need to view all workspace Docs in my Dashboard, I use this to categorize and filter whatever Doc I need. You may add any other condition if you want.
3. I connect this view in the Master Doc List to a newly created Doc (Dashboard Doc) using Cross-Doc Pack. For my need, I don't need to view rows from multiple databases in a single dashboard page. I just need the Doc Name, Category, Tag, Date modified and Doc URL. Whenever I need to view a doc, I click on the URL, and it's opened in a new browser tab. I found this more focusing than having a lot of information in front of you.
Since I'm not an expert in Coda, there might be some other better approach. However, this is what I've done for my dashboard. I know it's not as easy as in Notion, but it's totally worth it. Coda is a far superior tool than Notion.
You definitely can make this happen - And I have many systems like this running for clients, but its more of an advanced set-up using webhooks to connect multiple docs to a single private and central document
While Coda has many workarounds to keep data private, it is optimized as a collaborative workspace and tool - therefore privacy of info inside a document isn't first of mind in coda.
Notes:
None.