Display Latest Status For Each Account

Hi ,

I would like to know how to display only the latest records for each account. Basically , I have a table for names with their status. I only want to display the latest status of each name.

Example:
image

Expected Result:
image

Thank you

1 Like

Is there anyone that could help me achieving this? thank you

Can you show me the corresponding data table you have in bubble?

Its llike that I would like to know the latest result for each code based on created date

If you don’t want to change much you could do it this way. However, this could possibly lead to performance problems with very large tables.

pic2

It would make more sense to have a table with a list of “last_status_tables” for each user.
You can see this here in the example. With this you can solve it very easily.