summary field for text value

  • 2
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have created a table (Design Status) which is one to many with projects table This table is intended to allow our planners to document various design stages a plan goes through. On the other hand construction guys want to have a real time design status in their form on the last status achieved. 

I thought I could use the summary field option to report back the last design status but that unfortunately works only with numerical values. Either my approach is wrong or I have to have some support from you so that I could report the text field of last record in the parent table. Any chance we could report a field in the last record into the parent form.  

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
No problem. You just need to make s reverse relationship.

Make Summary of the Maximum Record iD.

Then make a new relationship where 1 Status update has Many Projects based in a reference field in the right side of the a relationship. Then lookup the status (text field) to the Parent Project record. .
Photo of Ursula Ll

Ursula Ll

  • 1,562 Points 1k badge 2x thumb
So,
1. you make a summary field called Maximum Record ID on the original relationship (one Design Status to many Projects).
2. Create a reverse table relationship (one Project to many Design Status).
3. In this newly created table, create a Lookup field - using the original status field?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Yep!  Lookup that Project Status field to the Design Status table.  It's a little hard to decide if you are "looking up" or "looking down", but yes, it's just a regular lookup field on a backwards (reverse) relationship.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thank you so much.  This all sorted out.