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

Question

Greetings Quickbase Community!The title of this post may sound a bit confusing so I will provide my goal followed by an example:Goal:&nbsp;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.)&nbsp; 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:&nbsp;&nbsp; &nbsp;Offers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Offer Amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Offer Date&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Offer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/12/17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Offer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/18/17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Offer 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/28/17In 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,

quickbasecoachd · Answer

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 · Answer

Thanks for the reply!I've tried this as well but unfortunately you can only use filters on fields in Offer records.&nbsp; IE:&nbsp; -Only summarize records where the following is true in&nbsp;Offer:&nbsp; -all of these conditions are true:&nbsp; &nbsp; &nbsp; - [Some Date Field In Offers]&nbsp; 'is equal to'&nbsp; 'the date in the field'&nbsp; [Some Other Date Field In Offers]In other words, I cannot use fields in the Submissions table fields as a reference when creating filters.

quickbasecoachd · Answer

Please do this step from aboveLookup that field down to offers&nbsp;Then the field you need to compare to will&nbsp; be in Offers

nateelme · Answer

Genius!&nbsp; Worked like a charm.&nbsp; Thanks!

nateelme · Answer

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&nbsp;

Forum Discussion

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

Related Content

New Nav, New Gains: Get Moving with Sidebar Navigation

Summary Reports

Maximum Summary field not working

Getting stuck on this form rule...

Get data from an unrelated table