How do i display text values in summary field if i cannot make a reverse relationship?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Attached image poses the question better than the text below:

Question: How do I display the Date of the most recently completed work order on the Site record AND pull in the [Work Order ID] to the Site record???

I was able to create a summary field to pull in the maximum [Date Completed] for any Work Order related to that site, but I can’t figure out how to get the [Work Order ID] pulled in since the data fields are text instead of numeric. I also can’t create a reverse relationship based on the [Record ID#] because the key fields are text fields...

I created a summary field on the Sites Table: [Record ID# for Most Recently Completed Work Order], but I’m unable to get that into the Reference field when I make the reverse relationship.

Photo of M


  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Craig


  • 0 Points

   This would be easier to explain and assist on this if a QuickBase Care case was opened.

Thank you,


QuickBase Care Team
Photo of Ursula Ll

Ursula Ll

  • 1,680 Points 1k badge 2x thumb
were you able to get this question answered? I am dealing with something similar now.