Skip to main content
Question

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

  • February 10, 2018
  • 0 replies
  • 127 views
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 Offers, where Submission records are the parents and Offer records are the children(1 Submission has many Offers.)  What I need to do, is retrieve the integer field(or value) of the "Offer" that is most recent of all the "Offers" related to that Submissions.

Example:    Offers            Offer Amount               Offer Date
 
                    Offer 1            10,000                          1/12/17
                    Offer 2            30,000                          1/18/17
                    Offer 3            20,000                          2/28/17

In the above table, my goal is to have the Submission record retrieve the "20,000" from its related offers.

Any help would be much appreciated!

Cheers,
    This topic has been closed for replies.

    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
    • Author
    • Quickbase Alumni
    • February 15, 2018
    Thanks for the reply!

    I've tried this as well but unfortunately you can only use filters on fields in Offer records.  IE:


      -Only summarize records where the following is true in Offer:

          -all of these conditions are true:
          - [Some Date Field In Offers]  'is equal to'  'the date in the field'  [Some Other Date Field In Offers]


    In other words, I cannot use fields in the Submissions table fields as a reference when creating filters.
    Terms & ConditionsAccessibility statement