I'm making a rota for my employees, I have a matrix with availabilities.

days Employee name EMployee name Employee name
1-feb 1
2-feb 1 1
3-feb 1 1
4-feb 1

Then I have another page where I would make another calendar, where to choose the person depending on their availability no the first calendar/matrix.

I want to have a dropdown field with the people available on that day. to make the new calendar with correct data and not having to do it automatically.


days Employee1 EMployee2 Employee3
1-feb Employee name1
2-feb Employee name 2 Employee name 1
3-feb Employee name 1 Employee name 2
4-feb Employee name 1
I've been looking in google and youtube but I couldn't find any good information. I know it's possible but I'm a bit lost.