Forum Discussion

TaraStroup's avatar
TaraStroup
Qrew Member
4 years ago

how can I  have one table become the report headers for another table

Hello, 

I have multiple tables that all need to work off of a date range in this case I am calling it weekending. I want to assign dates to weekending and have it populate dates in other tables ie for hour entry and perdiem how can I  have one table become the report headers for another table? Here is a visual example of what I want to have happen: 

Table 1 Week ending Table Weekending Date Sunday  Monday Tuesday Wednesday Thursday  Friday Saturday
12/19/20 12/13/20 12/14/20 12/15/20 12/16/20 12/17/20 12/18/20 12/19/20
Table 2 Hours Entry Employee Name Day Time In  Time Out Time In  Time out  Total Hours
Jane Sunday 10:00 12:00 12:30 16:30 6.00
Jane Monday 10:00 12:00 12:30 16:30 6.00
Jane Tuesday 10:00 12:00 12:30 16:30 6.00
Jane Wednesday 10:00 12:00 12:30 16:30 6.00
Jane Thursday 10:00 12:00 12:30 16:30 6.00
Jane Friday 0.00
Jane Saturday 10:00 12:00 12:30 16:30 6.00
Joe Sunday 10:00 12:00 12:30 16:30 6.00
Joe Wednesday 10:00 12:00 12:30 16:30 6.00
Joe Friday 10:00 12:00 12:30 16:30 6.00
Report Desired Table to show hours by employee sorting by week ending Hours 12/13/20 12/14/20 12/15/20 12/16/20 12/17/20 12/18/20 12/19/20 Total Hours
Jane 6.00 6.00 6.00 6.00 6.00 0.00 6.00 36.00
Joe 6.00 0.00 0.00 6.00 0.00 6.00 0.00 18.00

Thank you

------------------------------
Tara Stroup
------------------------------

3 Replies

  • I suggest that you use a Summary report type (not a regular table report type).  Group by employee name and using column groups by date , where it groups by week.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • TaraStroup's avatar
      TaraStroup
      Qrew Member
      Hello Mark, 

      Thank you for this. Is it possible to create formulas that report on the summarized data from a summary table?

      Referring to the example above, The total hours for the summary report its great now I need to derive reg vs ot hours.


      Regular hours would be whichever is less, total hours or 40 
      OT would =Total -Regular hours

      Is this possible? and how?

      Thanks,
      Tara

      ------------------------------
      Tara Stroup
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        The route you take on that will depend on what you want to do with that information later. If you simply need to see it in the report and don't need to be able to do anything else with it, you can create a Report Formula in the settings of the report itself. However, if you think you may EVER need to do something other than look at the data, you'll need some additional structure to properly report / manipulate your data. 

        In your example, you are calculating Hours Worked for each Employee for a given Week. Generally, I would suggest having an Employees table, a Weeks table, a Timesheets table, and an Employee Weeks table. Employee's time will be reported on the Timesheet record (assuming each Timesheet would represent a single day for that employee). Each Timesheet would be a child to an Employee record, a Week record, and an Employee Week record. The Employee Week record could then have a summary field for the Hours Worked and a formula to calculate the OT hours for that week.

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------