I would like to directly link a field in one table to the number of records by type that I have in another table. Is there any way to do this?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have two tables that I am dealing with. One table includes all of my employees and all of their jobs that they have been placed into (we can call this table "Employees"). The other table lists the locations for each job, and how much man power I have in that particular location, based on the number of employees (we can call this table "Locations"). Because the number of employees fluctuates on a regular basis due to changing contracts, I would like to directly link the number of employees (based on job type) into the various locations. 

Photo of John

John

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
I think that we need more details here.  Your first table is really not Employees, but rather Employee Assignments.  Can we Assume that you have a Relationship where 1 Location has Many employee Assignments?

So are you looking to have an embedded Summary report of the Employee Assignments on each Location record?  Are you looking to summarize, for example the # of Employee Days or hours by Job type on the Location record?
Photo of John

John

  • 0 Points
That's right about Employee Assignments, sort of. The jobs, however, are first determined by a "Bid Location" number which acts as a unique ID, then rolled up into more-general buckets in the same table (about 3,000 bid location id's fit into 5 more-general buckets).

Each of the totals for these general buckets breaks down further... by location, as I mentioned earlier. This information is all in the first table I described.

There is another table, for which I am trying to determine the labor capacity for each particular location, broken down by those 5 general buckets. Ideally, I would like to have a formula field that uses the total # of employees per bucket (per location) to calcuate various totals for 'hours available', etc, etc.

I also want to compare current capacity to the current demand for each location to determine the surplus/defecit for each general job bucket.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
I can't really help further without a complete list of the relevant tables and their relationships.  Or you may want to contact me directly via the information in my profile to work though the details of this together.  it sounds like you know in a general sense what you are trying to accomplish but its not really a crisp enough question yet to be answered on this Forum.
Photo of John

John

  • 0 Points
Do you have some free time? We can set up a call and I'll share my screen
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Please contact me via the information in my profile.  Click on my QuickBase Coach name and it should show my profile.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Just to close off this thread, we spoke off line using a GoToMeeting screen sharing session and got it working