# Assigning work shifts
**URL:** https://community.glideapps.com/t/assigning-work-shifts/83985
**Category:** Ask for Help
**Created:** [August 23, 2025, 5:39pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985 "2025-08-23T17:39:09Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [August 23, 2025, 5:39pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/1 "2025-08-23T17:39:09Z")
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)
- DESCANSO means “day off”.
- Is this layout at all possible with Glide?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 23, 2025, 7:42pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/2 "2025-08-23T19:42:52Z")
Does this data need to be interactive or is this a view only interface?
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [August 23, 2025, 8:22pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/3 "2025-08-23T20:22:05Z")
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?
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [August 23, 2025, 8:33pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/4 "2025-08-23T20:33:26Z")
Just to clarify, the manager will do this every friday for the week ahead.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 24, 2025, 7:22pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/5 "2025-08-24T19:22:29Z")
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.
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [August 28, 2025, 8:23pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/6 "2025-08-28T20:23:21Z")
Thanks for the tip. I ended up using GLIDE though.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 4, 2025, 8:24pm UTC](https://community.glideapps.com/t/assigning-work-shifts/83985/7 "2025-09-04T20:24:18Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.