Forum Discussion

MattBlankenship's avatar
MattBlankenship
Qrew Trainee
5 years ago

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 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
------------------------------
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    There 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
    ------------------------------
    • MattBlankenship's avatar
      MattBlankenship
      Qrew Trainee
      5 years ago
      Hey Mark,
      Thanks for your reply. 

      I am VERY interested in the "Plan A" with automation. 
      I've got pretty decent Quickbase skills, and am definitely willing and eager to learn more. :)

      In my "Time In/Out" table (child table), I'm guessing we will use the "User Name" field and the "HH:MM" duration field.
      What fields do I need to make in the "Time Summary" table (parent table).

      ------------------------------
      Matt Blankenship
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        OK, I will answer in pieces as I'm also dong real work.
        We will need a new Parent Table called Employee Days.
        Make a Relationship where 1 Employee has many Employee Days.

        Can you tell me what is the Key field of the Employees table?

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------