Jump to content
Claris Platform 2023 Roadmap ×

Calculation to see if a time slot is effected by calendar items

This topic is 3111 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Having a problem getting my head around this.


I have 4 time slots that can be used to book interviews in.to our meeting room, which is used for other things by other people other than for interviewing.


I am builing a system so that users can allocate a timeslot to a candidate for an interview, but first I would like to query the calendar to make sure that the slots arent effected by other events in the calendar





These are the timeslots.


9:00 - 1030





So im thinking i have the following fields












Then in my Calendar items I have these fields.


ID: self generated serial





I could have a record in my calendar items database say from 8am to 12pm on 01/04/2015. This would effectively make Timeslotone and Timeslottwo unavailable.


I have tried to use the calcualtion count  to count related databases using > < but it doenst want to work.


File is attached


I would be grateful for any help





checking times.zip

Link to comment
Share on other sites

Use a self-join relationship where Date Matches and Time Matches. For the Time, you'll need some greater-than/less-than relationships to get the time overlapping correct. You can then see if there's a conflict immediately upon creation of the appointment.

Link to comment
Share on other sites

This topic is 3111 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.