3 Replies Latest reply on Sep 22, 2013 8:36 AM by davidanders

    Staff availability database

    SimonSherwood_1

      Title

      Staff availability database

      Post

           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.

            

           Simon.