Hi All,
I'm having an app built on a Sharepoint Calendar Application, in order to book meeting slots.
So far I'm having a good gallery listing out the events within the FromD (from date) to the ToD (To date), but I strugle in having the filtering expanding to have also the hours and minutes taken in consideration. (Picture Attached)
objects at the moment
FromD: Datepicker
ToD: Date Picker
FromH:dropdownlist
FromM:dropdownlist
ToH:dropdownlist
ToM:dropdownlist
NZA534 Gallery Items:
Sort(Filter(NZA534;
DateDiff(DateAdd(FromD.SelectedDate;-Weekday(Now()-7));EventDate)>0;
DateDiff(DateAdd(FromD.SelectedDate;7-Weekday(Now();7));EventDate)<=0
And
DateDiff(DateAdd(FromD.SelectedDate;-Weekday(Now()-0));EndDate)>0;
DateDiff(DateAdd(FromD.SelectedDate;0-Weekday(Now();0));EndDate)>=0
);EventDate;Ascending)
What i would like to achieve based on the picture is the following:
1) since if we look at the selected time, there is already an entry, i would like the gallery to write out "Timeslot not available" and not list the times
2) since if we look at the selected time, there is already an entry, i would like to disable the visibility of the "Book" button
Every suggestion is well appreciated,
