i have 1.master table and 2. transaction table and first table having fixed time slots and second tabel having booked time slots and i have slots numbers 1to8 of the if the candidate booked one slot no and that slot number not shown to the other user while he selecting
i need which are available slots for every user i have the properties are Date and slot number based on date that avaliable slots always shown to the user
below requirements is one user has to meet one employee at the particular time frame like 10:00-10:30 if some user booked this slot for next user on that day and for that particular employee that which are booked time frame result not to shown to the user which are available only need to show to the user
refere below screen shot and please give good activity steps to achieve and if possible screen shots also needed
Posted: 4 years ago
Posted: 6 Jul 2018 13:10 EDT
Ron Lee (RonLee_GCS)
Principal Software Solutions Engineer
You need to be a little more specific about what the parameters of this problem are.
1) I assume it is the user who is booking the meeting. Is it with a specific employee, or with any available employee?
2) Are these virtual (e.g., online) meetings or physical meetings? If the former, then any number of employees can meet with separate users at the same time. If the latter, then that may not be possible (e.g., if there is a specific room that all meetings take place in).
3) Is the UI you are designing cascaded? For instance, does the user pick a day, then a time slot based on the slots available for that day, then an employee based on the slot chosen? Or are you just presenting the user with all the available meeting slots at once?
The solution to this problem is different depending on how you want to present it to the user.