Hello Gliders! Hoping all are doing great! I want to build an app where I assign work-shifts for workers of a fast food restaurant as shown in the attached excel. Requirements are:
See the whole week at a glance
The first column is the workers. If a worker resigns, I should be able to change his name for the new guy.
Each day has three columns: start time, end time, hrs:min worked. I should be able to set the start time and end time of each worker on each day of the week.
The last column sums up the total hrs:min worked in the week
Identify shifts by color: green is the first shift (morning), blue is the last shift (night) and yellow is an intermediary shift (a middle time-segment during the day)
Hello Robert! The manager must be able to enter the start time and end time for each worker for each day of the week. Then each worker just views his/her schedule for the week. I can only think of a DATA GRID. And one table per week. Am I on the right track?
If you are building something like that purely for display purposes, I’d probably build an HTML table using template columns and joined list columns to put it all together as valid html, along with any applicable formatting. Then display the html in a Rich Text component.
I guess it all depends on how your data is structured, but you could use a series of IF columns to determine colors and formatting, or maybe plug everything into a javascript column that returns your html.
