Title
Multiple find with omits
Post
Hi guys,
Im fairly new to FileMaker and am trying to write a simple tool for my boss to see who he can call when someon calls in sick for a certain shift.
I have two databases : one with all the staff including the different functions they're allowed withint the company (some can do a and b but not c etc) and one with all the shifts.
Lets say that John calls in sick for his shift on Wednesday with function A. My boss now wants to find people allowed on function A who are not working on Wednesday afternoon and who are obviously not John.
I came up with a layout with three fields
Name
Day
Function
Obvviously I need a script tha searches the records of the shifts table for people and omits the name entered, the day entered and includes the function entered.
The name and day field are drop down value lists, the function field I'm not sure about since the functions are entered in the staff table in a checkbox value list that doesn't relate to a table (I entered the values for the checkbox manually since I thought it stupid to make a table with just a couple of records for each function).
8 hope anyone can help me
You don't need a script. (With one caveat: you may need to trigger a refresh with a script triggere, as I have here, but that depends on the way your real tables relate.)
This sample file shows how to relate the staff table to itself and then use portal filtering to get the list you want. Think of the boss going to the sick staff record (to see their phone number, check what they do, mark them as sick, whatever): while they are looking at that record they can pick a day and the function they need covered.
You could make it that when they click on the staff member's record in the portal it takes them directly there (to get their phone number, etc). Or just show them the phone number directly there in the portal.
http://www.4shared.com/file/yKkNHEly/CallInSick.html