calculated column for unique records

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Answered
I have a list of records which lists data of different dates for each employee.

There are multiple employees listed in the same table but each employee may have multiple records. Each Record has a field that has a number that will need to be calculated into a "Total" field. Sort of like a summary report but I need it to be a field so that I will always know what employee has the highest number at any given time. Any ideas?
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
Do you have a relationship where 1 Employee has many "records"?
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb
Yes, I do...

Here are the Tables I have:

Employee List
Overtime List

The "Employee List" feeds the Overtime List with Each Employee has many records.

Within the Overtime list, I would create a record each time an employee has overtime. In that record, there is a field that indicates how many hours of overtime they worked such as 1, 4, or 8, etc.

On that list, I need to indicate at all times how many hours of Overtime they have worked.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
If you just want to have a summary of the total overtime, go to the relationship and create a Summary field to total the overtime. Is that what you want? 

Your first question is different from your second question.
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb
Im sorry, I am a little new at this so I am probably asking it wrong. I have tried the summary and it shows the number I need. The issue is, I need that number to be in a field for each employee on every record. This will allow for me to sort for reports that require the employee with the most Overtime to be on top. I hope that makes more sense. I appreciate the help! 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
No problem, just lookup the field probably called [Total Overtime] down to the time records. Just go back into the settings for the relationship and add a lookup field on the right side.
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb
Well, That worked....Very cool, Thanks for the help!!