Need some help figuring out how to go about this!
I have a list, people will add items to it, sometimes with the same title (which is correct).
We then group these items by the column 'title' on the list.
We want people to create new items, rather than editing the old one, so we have a log of the new additions.
For example: The list would have 4 items, 3 with the title 'dog' and 1 with the title 'cat'
We would then group the items with the title dog, and group with the title cat.
However, I also want to have a view where we only see the last added item for each title - so we would only see the latest 'dog' item, and the latest 'cat' item.
I couldn't filter by time/date, because some groups may not have had items added to in a while.
Is there a solution to this?
Any help would be greatly appreciated!