Conditionally counting records based on field on new record

ok - yea, that makes sense. this is tricky! I am thinking that some javascript will be required here because the native way to do it would probably require a days table and a employee_days table in order to summarize per diems given for any given employee on a given date. With a javascript solution, it could query the other timesheet_employee records for a timesheet and allow or disallow per diems.