# Selecting the most recent connected record

**URL:** <https://forums.knack.com/t/selecting-the-most-recent-connected-record/20358>\
**Category:** Get Answers\
**Created:** [April 23, 2026, 1:12pm UTC](https://forums.knack.com/t/selecting-the-most-recent-connected-record/20358 "2026-04-23T13:12:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)\
**Post date:** [April 23, 2026, 1:12pm UTC](https://forums.knack.com/t/selecting-the-most-recent-connected-record/20358/1 "2026-04-23T13:12:14Z")

</div>

In my app I have a table of Action Items which is connected to a table of Updates, each action item can have multiple updates. Updates have a. created timestamp.

What is the best way to only show the most recent update in a grid view of action items.

CSS works to hide the older ones but they are still present in an export. Seems like it should be simple but I’m struggling with this one. Any other ideas?

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [April 23, 2026, 10:25pm UTC](https://forums.knack.com/t/selecting-the-most-recent-connected-record/20358/2 "2026-04-23T22:25:41Z")

</div>

@LeighBerre96926, for something that seems like it would be easy to do, it isn’t…  
I’ve tried some funky record actions and conditional rules but couldn’t do it natively.

Which is your form doing?:

1. Updating the **Action item record** and inserting a connected **Update** via record actions
2. Inserting a connected **Update**

The most obvious solution to me here is a Flow/Make or JavaScript automation to update the Action item’s ‘latest update’ field to the newly inserted Update record.

---

<div class="post-metadata">

**Author:** ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)\
**Post date:** [April 23, 2026, 11:58pm UTC](https://forums.knack.com/t/selecting-the-most-recent-connected-record/20358/3 "2026-04-23T23:58:10Z")

</div>

Yes i was hoping to avoid that approach because the app had been loaded up from a spreadsheet dump, so right now the starting point doesn’t have that final piece in place.

I’m wanting to show a grid of actions and use a connected field to show comments/updates … but only the most recent one.