Staff availability database
I'm looking at building a spreadsheet that will show the availability of staff at hour intervals for a week. I'm wondering if there is a tool within filemaker that would make this a lot easier. So for instance I'd like to have a record with the details of a staff member but then his availability on a Monday 7AM - 7PM at hour intervals and then the same for Tuesday and so on.
I thought you could do this with checkbox fields titled Mon 7-8, Mon 8-9 and so on but I can see this making for a very messy database. At the moment I just need to enter data, show data and then be able to search staff availability for specific hours. I know I could make it work with checkboxes but I'm sure there must be a tidier way.