Totaling Daily Time Entries Per User
I have a table that allows users to clock in/out, which totals each separate time entry duration. Each day we end up with multiple entries per day, per user. I am needing to automatically get a to...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere are two options.
Plan A
The first is to set up some automated process to create a parent table which has a concatenated key field which combines the employee and the date. Then you can easily have that be a parent to the time entries and get your perfect report.
Plan B is to make a bunch of summary fields on the employee record for
Total Time today
Total Time today -1 (yesterday)
Total Time today -2 (the date before)
etc back say a couple of weeks, assuming that you need this for some kind of payroll purposes.
If you want Plan A, depending on your Quick Base skills we may be able to slowly muddle our way through that on this forum or else it might need an hour of consulting to get it going.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Plan A
The first is to set up some automated process to create a parent table which has a concatenated key field which combines the employee and the date. Then you can easily have that be a parent to the time entries and get your perfect report.
Plan B is to make a bunch of summary fields on the employee record for
Total Time today
Total Time today -1 (yesterday)
Total Time today -2 (the date before)
etc back say a couple of weeks, assuming that you need this for some kind of payroll purposes.
If you want Plan A, depending on your Quick Base skills we may be able to slowly muddle our way through that on this forum or else it might need an hour of consulting to get it going.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------