AnsweredAssumed Answered

Staff availability database

Question asked by SimonSherwood_1 on Sep 21, 2013
Latest reply on Sep 22, 2013 by davidanders


Staff availability database


     Hi All

     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.