# How to find next employee?
**URL:** https://community.glideapps.com/t/how-to-find-next-employee/20836
**Category:** Ask for Help
**Created:** [January 7, 2021, 3:55pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836 "2021-01-07T15:55:19Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@DareSteps](https://community.glideapps.com/u/DareSteps)
#### Post date: [January 7, 2021, 3:55pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/1 "2021-01-07T15:55:20Z")
Hello all,
I’ve been trying to figure out how to find the next employee but couldn’t. For example, I have start time and end time as it is shown in the screenshot. It’s Joe’s shift as it equals 1 based on If Then Else Column.
I would like the app to show who is next? the next one will be Steven (last row), how to do so? any hint/clue?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 7, 2021, 4:13pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/2 "2021-01-07T16:13:42Z")
I think you can have a numerical order column in the sheet (1, 2, 3, etc.) and make a math column in Glide (current row’s numerical order + 1), then make a relation.
---
### Author:  [@DareSteps](https://community.glideapps.com/u/DareSteps)
#### Post date: [January 7, 2021, 4:49pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/3 "2021-01-07T16:49:48Z")
Seems a solution but can you elaborate more? make a relation? between Order (Numerical Order) and If Start & End? it won’t match! I might be confused and I will be so glad if you elaborate more
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 7, 2021, 4:53pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/4 "2021-01-07T16:53:35Z")
I think the missing part here is a column that determines which numerical order value is “current”. Possibly a long con but you can make a math column with the value 1, make a relation back to the start & end if then else, then a lookup to return the current row (15).
Then a math column to determine the next, so current + 1 = 16. A relation from that “next” column back to the order will be the final one.
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [January 8, 2021, 6:54am UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/5 "2021-01-08T06:54:34Z")
🤔But… Am I wrong or these are fixed shifts? If the end time always coincides with the start time of the next shift, then you could simply relate end time to start time in the same table. In this case, after Steven it would not be anyone’s turn because the relationship would be empty.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [January 8, 2021, 3:23pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/6 "2021-01-08T15:23:38Z")
If you are wanting to know who is next using the times and they are fixed shifts you can use the now function within glide to find the current time. Then make visible only times that are greater than current time. sort the list from smallest to large and limit the list to 1 item.
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:58pm UTC](https://community.glideapps.com/t/how-to-find-next-employee/20836/7 "2024-01-17T16:58:24Z")