Forum Discussion

NateElme's avatar
NateElme
Qrew Trainee
8 years ago

Getting the most recent field data, using a summary field, of a non-date field.

Greetings Quickbase Community! The title of this post may sound a bit confusing so I will provide my goal followed by an example: Goal: I have two tables related to each other, Submissions and O...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem
Make a Summary field of the Maximum Offer Date, and call it [date of latest offer]

Lookup that field down to offers

Make a summary if the maximum offer amount subjust to the filter where Offer Date equals [date of latest offer]
  • NateElme's avatar
    NateElme
    Qrew Trainee
    8 years ago
    Hi!

    Thanks again for your help 2 months ago.

    Do you think this would be possible for a non numeric field(i.e. a text field)?

    Thanks in advance.

    Nate 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Yes, you will need to do a reverse relationship.  

    First make a summary of the minimum record ID# subject to the filter that the date = maximum offer date.
    call it [Record ID# of Most Recent Offer]


    Then make a new relationship with is backwards - ie reverse.

    One Offer has many Submissions, but when you go to the right side use the field [Record ID# of Most Recent Offer].  Then look up anything that you want form the Offer to the Submission.