Forum Discussion

DavidDeGraaff's avatar
DavidDeGraaff
Qrew Trainee
7 years ago

I don't see a way to create a hierarchy from a table that just shows employee and manager.

Is there a way to handle the recursion for any number of levels, so I could have one table that has:  employee   manager bill              mary mary           jane jane            bob and fro...
Ask about Quickbase functionality
Relationships
DebbieTaylor's avatar
DebbieTaylor
Qrew Trainee
7 years ago
A few more thoughts:
  • You should only build one recursive relationship (eg employee to manager).  For additional reporting, add look-up fields (eg second level manager.)
  • When you need to change many records, create a report with the records.  Use the "More" button in the upper right hand corner of the screen to access the "Search and Replace in this report" feature.  See below.
  • Consider getting an extract from your company's HR system OR, better yet, integrate with it.  Some changes can then be automated.