Discussions

 View Only
  • 1.  Most Recent Record

    Posted 01-03-2023 15:22
    How do you filter a report to only display the most recent record?

    ------------------------------
    Kimberly Massa
    ------------------------------


  • 2.  RE: Most Recent Record

    Posted 01-03-2023 16:46
    There any relationship involved? Is this a Child table to a parent record?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Most Recent Record

    Posted 01-03-2023 17:43
    I have created an automated table that creates records when they meet the assigned criteria which would be the child table.

    ------------------------------
    Kimberly Massa
    ------------------------------



  • 4.  RE: Most Recent Record

    Posted 01-03-2023 18:34
    Edited by Mark Shnier (Your Quickbase Coach) 01-03-2023 18:34
    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
    ------------------------------



  • 5.  RE: Most Recent Record

    Posted 01-04-2023 08:33
    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
    ------------------------------



  • 6.  RE: Most Recent Record

    Posted 01-04-2023 09:09

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