How to get last stage from linked table by date not row order

Hi there!
I have 2 tables: Stages and Applicants and them are linked together.
I need to get the last stage of applicant based on date and time column not on row number.

How to do that?

Hey there, thanks for reaching out to the community!
From what I can see in your setup, it looks like things are working as intended. Can you elaborate on what you’re hoping to see in that column instead?

Hey!

Sorry I saw this earlier and meant to get to it. If you don’t want it to sort by the table order you need to use your sort() function to force the list to sort by date, THEN call last() for the latest entry

2 Likes