Lotus IBM
Lotus IBM

How to control the Time Slots?

I'm working on an application used for booking Transport cabs, since we work in shifts; employees use the transport facility as per the shift schedule. The shift schedule as well as the transport schedule is prepared for a fortnight. To manage the transport system efficiently we have a policy that user should not select a time slot within 12 hour window for pickup and should not pick a drop slot with in 1 hour window. I have created a form to program the slots like 7:00, 11:30, 15:45, and 17:45 etc. User has option to select the predefined slots from the master form. Im using @dbcolumn formula to select the slots from a view.
Now what I want to program is when user tries to change the pickup slot lets say around 7:00 in the morning, he should only see the slots available on or after 19:00 similarly if it he tries to change the drop slot at 7:00 he should able to select any slot after 8:00. Pls help in developing this functionality.

Thanks

PrashantbhatnagarAsked: 2008-06-19

Who is Participating?

LVL 63

SysExpertCommented: 2008-06-19

You need to select with a date value, so that the difference is > 12 hours, in your select formula.
All time slots should be set as full dates, so that you can use Date math to figure out > 12 hours.

I hope this helps !

LVL 63

SysExpertCommented: 2008-06-19

see

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_21234834.html

for some code sample

LVL 63

SysExpertCommented: 2008-06-19

also

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_21695897.html

PrashantbhatnagarAuthor Commented: 2008-06-19

The problem is the time slots I have put are 7:00, 9:00, 11:30, 15:45, 17:45, 20:45, 23:30, 00:30 - Now when I compare using SELECT Form = "Pickup Slots" &@TextToTime(PickupS)>@Adjust(@Now;0;0;0;12;0;0) it does not work. The when the user try to change the slot at any point of the day the slot which are within 12 hours should be hidden.
One crude method which I can think of is storing the time slots in different views and calling the views in the combobox depending on the time of the day.