I think I would do it by marking the last one in a Checkbox field (manually), and creating an Automation that find and unchecks it when a new Record is created, and checks it as Latest. Then you could filter by that Checkbox field.
Anyway, what is your use case? :grinning_face_with_sweat:
What is your base structure? If you have something like Sensors and Measures, you could get the last Measure of every Sensor like this:
MAX()so you get the most recent date of measures.
Now you can show your Sensors table in Softr. It’s a little tricky but you avoid the automations.
Have you tried with FALSE, FALSE(), or just leaving it blank?
I like this solution, I was able to use it in my application. In my case its the most recent scan, but since I'm scanning every few seconds it marks several as true. 😞 Unless I'm missing something this suggestion will only be viable if timestamps are consistently a minimum of 1 min apart. any suggestions?