Grab our *free templates* and escape spreadsheets forever 👉👉 gapconsulting.io/templates Learn how to *automate your work* with our webinar 💡💡 gapconsulting.io/webinar-registration
This is great! When you get to Part 2, I would love to see how it looks with more than 1 person tracking time to the same project, so they only see their time records against the project. Thanks so much!
Been looking for something that could do this outside of 3rd party app like toggl for a long, long, time I see in some of your comments you mentioned the possibility of adding button inline. Does that mean it would be possible to time track sub tasks? E.G. if I thought a project would take 2 hours to do and it took 10 hours. It would be helpful to see which task held me up or held up the team
Absolutely! I'll try to include this in the Part 2 video as well... For subtasks, I'd suggest that you create a new table, so your data schema would look like this: Projects -> Tasks -> Sub Tasks -> Time Log This way, you'd assign time logs to the sub tasks and roll that total time up to the tasks, then roll all task time up to the projects. But you'd also have the granular ability to view the time to complete the sub tasks. Hope this helps!
Hello and thank you for your tutorials. I have a tricky question. I have my tasks interface and also my products interface. When i create a form i have my link to another record that is products. I have problem with the quantity. I am a technitial and i use a lot of products i dont want to have an juction table cause is time consuming to do it for every client and each product. Its possible to have to a task form something like an excel table that in the first colum to add the product name or number and to the second colum to add the quantity of eah product? I am trying to find the solution at least 3-4 weeks. Thank you so much.
Hi, thanks for the comment. I don't really understand the question I'm afraid. If you are tracking quantity for products and multiple products can be sold on one order, I'm afraid a junction table is the only way I know to solve this.
I honestly think the end time is not as simple for beginners. You would have to set this on time tracking record and not the project record. The only workaround is looking for a record that has no end date yet in this project and update that end date, but I guess that’s not for the newbies 😊 - good to explain that next time, or am I missing something
You can definitely set it on the time tracking record and create a button inline. Alternatively, you can create it on the project record and add a step to search for incomplete time records that are linked to the project. I'll do a Part 2 video and share both options!
@@GarethPronovost, sometimes people forget to stop their time tracking. Some CRMs automatically stop tracking when the workday is about to end. That coult be a good case for your next video.
Grab our *free templates* and escape spreadsheets forever 👉👉 gapconsulting.io/templates
Learn how to *automate your work* with our webinar 💡💡 gapconsulting.io/webinar-registration
This is great! When you get to Part 2, I would love to see how it looks with more than 1 person tracking time to the same project, so they only see their time records against the project. Thanks so much!
You got it!
Thanks for sharing!!
Thank you Gareth! As usually very simply and qualitatively.
Thanks for watching! Glad you found it useful!
very nice, thanks. it would be great to see an integration to "pause" the timer, too :)
Thanks for the idea, we'll try to include that in our Part 2!
That’s handy. Can add those buttons inline? Meaning a list of projects with the start and end time buttons in each project? I’ll try it later.
You sure can, but to have buttons inline you'd need to use a different interface page type, like List or Grid, to share the projects.
Been looking for something that could do this outside of 3rd party app like toggl for a long, long, time
I see in some of your comments you mentioned the possibility of adding button inline. Does that mean it would be possible to time track sub tasks?
E.G. if I thought a project would take 2 hours to do and it took 10 hours. It would be helpful to see which task held me up or held up the team
Absolutely! I'll try to include this in the Part 2 video as well...
For subtasks, I'd suggest that you create a new table, so your data schema would look like this:
Projects -> Tasks -> Sub Tasks -> Time Log
This way, you'd assign time logs to the sub tasks and roll that total time up to the tasks, then roll all task time up to the projects. But you'd also have the granular ability to view the time to complete the sub tasks. Hope this helps!
@ perfect! Thank you
Hello and thank you for your tutorials. I have a tricky question. I have my tasks interface and also my products interface. When i create a form i have my link to another record that is products. I have problem with the quantity. I am a technitial and i use a lot of products i dont want to have an juction table cause is time consuming to do it for every client and each product. Its possible to have to a task form something like an excel table that in the first colum to add the product name or number and to the second colum to add the quantity of eah product? I am trying to find the solution at least 3-4 weeks. Thank you so much.
Hi, thanks for the comment. I don't really understand the question I'm afraid. If you are tracking quantity for products and multiple products can be sold on one order, I'm afraid a junction table is the only way I know to solve this.
And same for duplication, is there a list of keyboard combos?
I don't have a shortcut for duplication unfortunately
You did it super fast in your clip, or did you edited the video?
Thanks for sharing. How the hell did you selected multiple fields and delete them? I’ve never seen that shortcut 😮
Ha! One of our team members just shared this with me the other day. Hold down shift to select multiple columns. 👌
@@GarethPronovost love this
I think this could be really useful, but I sorta wish you had been able to show the end-time trigger as well to see how it updates.
I'll create a part 2 and share it here when we do!
I honestly think the end time is not as simple for beginners. You would have to set this on time tracking record and not the project record. The only workaround is looking for a record that has no end date yet in this project and update that end date, but I guess that’s not for the newbies 😊 - good to explain that next time, or am I missing something
You can definitely set it on the time tracking record and create a button inline. Alternatively, you can create it on the project record and add a step to search for incomplete time records that are linked to the project. I'll do a Part 2 video and share both options!
@@GarethPronovost, sometimes people forget to stop their time tracking. Some CRMs automatically stop tracking when the workday is about to end. That coult be a good case for your next video.
@cvadim88 great point, I'll add that to the mix!
@@GarethPronovost great