Hi,
I have a need to extract the name of each calendar interval that is used by a task.
We plan to link data from associated to the task directly to another set of data that drives calendar intervals. These intervals are fairly dynamic and can be user defined.
This does not have to be real time/per change, I would be happy for it to be triggered by button press, etc.
For example I have data structure:
Tasks:
Task 1,
Task 2
Calendar 1:
Interval 1: Name: some day
Interval 2: Name: another day
Interval 3: Name: third day
Calendar 2:
Interval 4: Name: other cal day
Task 1 is allocated interval 1 and 2
Task 2 is allocated interval 1, 3, and 4
My output would be:
Task: 1
Interval: Cal 1, some Day
Interval: Cal 1, another Day
Task: 2
Interval: Cal 1, some Day
Interval: Cal 1, third Day
Interval: Cal 2, other cal day