Ability to create summary fields using Report Link instead of a relationship

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
Month<Hours>Projects
Month<Monthly Status>Projects

I have an app with the tables above:  Month and Projects are parents to Hours and Monthly Status.  I would like to total the hours per month for a project in the Monthly Status table and set up a report link between Monthly Status and hours using a text formula field I created  (Project&Month).  Is it possible to create summary fields based on this report link?

Thanks
Photo of Christine

Christine

  • 332 Points 250 badge 2x thumb

Posted 5 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
A report link field will run any report. It does not allow summary fields.  But you can make a summary of the total hours using your first relationship and then you can look that up down to the Monthly Status table by a lookup on the 2nd Relationship.