Most Recent Record

MarkShnier__You
Qrew Legend
3 years ago
Are you looking for the most recent record in that whole table? Are these child records of a parent table where there's a relationship and you want the most recent child for each particular parent record?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- KimberlyMassa
  Qrew Trainee
  3 years ago
  I am looking for the most recent record in the child table created.
  I have a Parent Table that includes all types of records.
  I have a Child Table that only includes records that include injuries.
  I have created a formula field that displays the days since the last injury.
  This is only correct on the most recent Child Table record, this is the record that I want displayed in a report.
  
  ------------------------------
  Kimberly Massa
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Ok make a summary field of the most recent injury date.
    
    Lookup down to injuries.
    
    Then make a report on the child table of records where the most recent injury date equals the injury date.
    
    You can also float up the text from the injury record up to the Parent record using a combined text summary field with a similar filter. It will appear in a bubble-like format, but you can make a new field of type formula text to convert it to a more familiar text format.
    
    ToText ([Combined Text Injury Name])
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion