Skip to main content

Multiple dates for same record

  • May 18, 2019
  • 1 reply
  • 7 views

Forum|alt.badge.img+3

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.

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • May 20, 2019

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).