AnsweredAssumed Answered

Omitting dates

Question asked by FileMakerNovice on Feb 5, 2013
Latest reply on Feb 6, 2013 by FileMakerNovice

Title

Omitting dates

Post

     Hello,

     I am interested in omitting date ranges while an employee is in training, sick away, etc.  Here is the

Relationship View:

     Employee--Stats
                   \
                   Calls--CallQuality

      

Tables:

     Employee
     Consists of Employee Name, Manager, Employee ID, StartDate (global), EndDate(global) and Calculation fields that provide a range of "Metrics" from Stats and Call Quality.

     Stats
     Consists of employee ID, dates that the employee worked, how many customer surveys they received, the grades of these surveys, how long the employee was on calls, how long they were on break, etc.

     Calls
     Consists of employee ID, dates a call was analyzed, and a call ID.  The call ID is a unique number given to a call.  Sort of like a case id.

     Call quality
     This holds values (1-10) for certain skills.(CustomerSkills, TechSkills, ListeningSkills, etc)

Relationships

     Employee to Stats
     EmployeeID=EmployeeID
     StartDate<=Date
     EndDate>=Date

     Employee to Calls
     EmployeeID=EmployeeID
     StartDate<=Date
     EndDate>=Date

     Calls to Call Quality
     CallID = CallID

      

     I currently have a layout in form view that I enter the start and end dates and it gives me the metrics for an employees that I perform a find on.  I also have a layout in list view that gives me a list of all employees.

     I am looking to have a table of start and end dates for an employee of dates that I'd wish to exclude.  This would have employeeID, start, end, note.  For instance, John Doe was training 1/1/13 to 1/2/13 and was sick from 1/13/13 to 1/15/13.  I do not want these dates to be included in the two layouts mentioned.

     I am having difficulty determining how to incorporate these into the layouts.  Please note, I cannot combine States or Calls.

Outcomes