Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 25, 2023 01:42 PM
Ok, I have been trying to do this for a while on my own with no luck.
I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I would like to do is figure out a way that I can see only the last entry for every serial number. My thought is to have a third field for a conditional formula. Something that just posts the number 1 if it is the most recent date. Then I can use a view to only see everything with the number 1 in that field. The problem is that I need to pull the most recent date for EVRY serial number group. Not just the most recent date over all. Hope that I am explaining this right. Here is an example of the a sample base:
Please help! Thank you.
Jan 25, 2023 02:06 PM
I believe @W_Vann_Hall 's answer in this thread might be a good building block (though you'd still need to figure out the final step of it working for each serial number).
Jan 25, 2023 02:07 PM
Sorry, forgot to include the link!
https://community.airtable.com/t5/other-questions/lookup-to-show-latest-entry/td-p/106261
Jan 25, 2023 02:10 PM
Saw that one. But that is also for two separate tables. I am only using 1 table. But I do appreciate the tip.
Jun 21, 2024 06:29 AM
Same issue here. Did you find a solution?