This BSV demonstrates:
1) Advanced Search ability explained at http://www.awareim.com/forum/viewtopic.php?t=1548
2) Custom button - also explained at http://www.awareim.com/forum/viewtopic.php?t=3005
3) How to ensure that new appointments do not conflict with existing appointments.
Download BSV: here.
Remove BIN extension after download
#1 Advanced Search -- uses:
FIND Appointment WHERE Appointment.Room.RoomName=LoggedInRegularUser.Room.RoomName OR LoggedInRegularUser.RoomExclude='Yes' ORDER BY Appointment.RoomName,Appointment.StartTime
#2 Custom Button -- RegularUser form "Room Filter" uses:
<button type="button" onclick="AwareApp.saveForm(this)"View</button>
Note that the saving of the RegularUser form triggers the refresh of the query "Appointment Calendar for Selected Room" because RegularUser is listed in the Auto Refresh triggers.
#3 - Conflicting appointments eliminated:
Three rules in Appointment BO ensure that new appointments for a particular room do NOT overlap with existing appointments.
Example BSV: Adv Query / Appt conflicts / Custom Button
Example BSV: Adv Query / Appt conflicts / Custom Button
Tom - V8.8 build 3137 - MySql / PostGres