Forum Discussion
About a decade ago I implement in QuickBase something called Allen's Interval Algebra which is a generic approach towards modeling how to schedule and compare resources that can overlap in time. There are 13 possibilities of how two events can be related to each other.
Yes each of these notations were used to write math equations such as "a proceeds b"
Here Notation: a p b
Allen Notation a < b
Krokhin Notation: a p b
These shorthand notations would be translated into various constraints on the start and end times of the two intervals a and b.
Amazingly the basic querying for open time slots and overlap classification can be implemented natively in QuickBase. The major issue at that time was defining the desired granularity - are you scheduling in terms week, days, hours of 15 minute intervals. Today there is a lot more freedom as we can use script.
I don't have the application any longer but if you want to pursue a solution you can contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt
Yes each of these notations were used to write math equations such as "a proceeds b"
Here Notation: a p b
Allen Notation a < b
Krokhin Notation: a p b
These shorthand notations would be translated into various constraints on the start and end times of the two intervals a and b.
Amazingly the basic querying for open time slots and overlap classification can be implemented natively in QuickBase. The major issue at that time was defining the desired granularity - are you scheduling in terms week, days, hours of 15 minute intervals. Today there is a lot more freedom as we can use script.
I don't have the application any longer but if you want to pursue a solution you can contact me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt