Jan 25, 2022 11:34 AM
Hello there. I’d like a view to only show the last record added. I can’t seem to figure out how to do this. Is it possible? If so, how? Thank you!
Jan 25, 2022 02:10 PM
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:
Jan 25, 2022 05:48 PM
Thank you, I will see if that works.
We’re storing data from several sensors in an airtable database. We want to display the latest entry as a Web page using Softr, but only want that web page to show the most recent enrty. This seems like a good way to do it. Open to any suggestions.
Jan 26, 2022 01:46 PM
I’m stuck on the Automation. Where do I tell it I want to uncheck the check? In the attached image I’ve tried entering false and 0 in the “Fields” field.
Apr 07, 2022 04:01 AM
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?
Apr 07, 2022 04:05 AM
I’ve tested it and worked with
Apr 07, 2022 04:09 AM
I’ve recorded a video about the automation test:
Jun 02, 2023 03:02 PM
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?