Selecting the most recent connected record

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?

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

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.