AnsweredAssumed Answered

List view daily schedule

Question asked by KylerPhilips on Apr 29, 2015
Latest reply on May 12, 2015 by philmodjunk

Title

List view daily schedule

Post

This might be a bit ambitious or entirely possible. I have two relevant tables which I think should achieve the following approach: Requests Table and Staff.

Requests:

Requests::RequestedDate

Requests::RequestStartTime

Requests::RequestEndTime

Requests::RequestsStaffRequired

Requests::TypeOfPackage

Requests::StaffMemberName

The Staff information is just relevant information such as FirstName, LastName etc... Can I create a list view which has a calender toggle and below showing the requests that have been created for that day - see below picture for rough plan. So each member of staff can see their schedule for the day and click on the request tied to the dots and lines.

It would also be great if I could prevent someone creating the same record request which matches the same StaffName, StartTime, EndTime, RequestDate - so prevent duplicate requests at any one time. Any advance would be fantastic, thanks as always!

list_view_staff.JPG

Outcomes