
Hi,
I'm trying to create a simple app where staff can lookup their shifts well in advance.
The excel table would have dates listed down the first column and names listed across the first row.
I then want the app to have a date picker box to select the date they want to find out about and a drop list to select their name.
The text box would reveal their shift for that day.
The data would be stored like this
| DATE | Dave | Chris | Kate |
| 31/5/21 | 06:05-15:05 | 14:35-23:35 | Off |
| 1/6/21 | 06:05-15:05 | Off | 14:35-23:35 |
| 2/6/21 | 06:05-15:05 | Off | 14:35-23:35 |
| 3/6/21 | 06:05-15:05 | 14:35-23:35 | Off |
| 4/6/21 | Off | 14:35-23:36 | 06:05-15:05 |
| 5/6/21 | Off | 14:35-23:37 | 06:05-15:05 |
| 6/6/21 | 14:35-23:35 | Off | 06:05-15:05 |