This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Being able to easily add different time periods for a record.
I have a table to manage my tasks, and I need to work on some tasks in more than one occasion. There is no elegant solution for this. I think it is also necessary to be able to add these periods from a calendar view.
You could create a separate table to track time spent on each task. Each time you work on a task, link it to a new record on the other table and calculate the duration there. Then you could use a rollup on your Task table to calculate the total time spent.
You could imagine it kind of like line items on an invoice (where the line items are the chunks of time spent, and the invoice is the task).
