Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
In order to filter the report, you will need to have a table populated with a Key field which concatenates the employee and the date and which contains all the possible combinations. If you had that, then you could create a relationships back to your details schedule table and make a summary of the # of entries for that Employee for that date.
There are a variety of ways to maintain that summary table. One way to get it started is to create a summary report off your schedule table and have it summarize the unique values for that field, which would be in the format
List("-", totext([Employee #],totext(date]))
and then use the "More .." button to copy it across to the summary table. Then the data could be maintained in that summary table using an Action to create the additional entries as they are required.
There are a variety of ways to maintain that summary table. One way to get it started is to create a summary report off your schedule table and have it summarize the unique values for that field, which would be in the format
List("-", totext([Employee #],totext(date]))
and then use the "More .." button to copy it across to the summary table. Then the data could be maintained in that summary table using an Action to create the additional entries as they are required.