Forum Discussion
18 Replies
- Dan... here is my big issue. I am not familiar with scripts. While I follow the explanation you provided on meeting the correct conditions, albeit at times in can get confusing, script is altogether different for me. How do I even begin to implement your suggestion?
- I am afraid I am out of time as I have to travel home shortly and my schedule is packed through the weekend. If I don't reply on my own by early next week ping me.
- Will do, thanks Dan
Have same problem as above. Are there any suggestions?
- 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 - Thank for your reply. I am familiar with interval algebra, which was my initial idea of how to solve this problem. My issue is that I am not familiar with any language for scripting. I will have look myself and contact you if I get on a dead end.
