Totaling Daily Time Entries Per User

Question

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 total from all time entries per day, per user into a field that I can utilize elsewhere in the app.I am also not wanting to have to manually enter a separate entry into a parent table per user, per day. (That would just take forever)Any help would be appreciated.
------------------------------Matt Blankenship------------------------------

MarkShnierYou · Answer

There are two options.Plan AThe 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 forTotal Time todayTotal 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community