Most Recent Record
How do you filter a report to only display the most recent record? ------------------------------ Kimberly Massa ------------------------------
Forum Discussion
There any relationship involved? Is this a Child table to a parent record?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I have created an automated table that creates records when they meet the assigned criteria which would be the child table.
------------------------------
Kimberly Massa
------------------------------
------------------------------
Kimberly Massa
------------------------------
- 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
------------------------------- 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
------------------------------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
------------------------------
