Hi @Maryam16 ,
Follow these Steps:
Create Time Slots: Determine the range of hours you want to show and create a collection with all the time slots.
ClearCollect(TimeSlots, [
{Time: "8:00 AM"}, {Time: "8:30 AM"}, // Add all time slots here
...
{Time: "5:00 PM"}
]);
Use a Gallery for Time Slots: Create a vertical gallery to display the collection TimeSlots.
Use a Horizontal Gallery: Inside each row of the vertical gallery, add a horizontal gallery that will represent the employees.
Filter Work Orders for Each Time Slot: For each employee, filter the 'Work Orders' table to show only the orders for the given day and time slot.
Filter(WorkOrders, DateDiff(StartTime, SelectedDate, Hours) = ThisItem.Time && EmployeeID = EmployeeGallery.ThisItem.ID)
Create Navigation: Provide buttons to navigate between days.
Customize the Look: Use conditional formatting to change the appearance of each slot based on its status (e.g., free, busy).
Bind Data: Bind the work order details to the relevant controls in the horizontal gallery to display the data.
Add Functionality: Implement selection, editing, and addition of work orders through the gallery.
Best Regards,
Hassan Raza
