First time poster, really liking the functionality in Airtable at the moment.
Im struggling to Create what i describe to be an online Auction. Its nothing super important as its more for an online gaming community but its still a learning experience either way.
My Database consists of the following Fields
Name: Name of Person Bidding (Single Line Text)
Number: Number of the item being bid on (Drop Down Menu selection 1-100)
Location: Auction Location (there may be more than one location) (Drop Down Menu)
Offer: Cash Offer Made
I have a form that i would like to use to feed the information in and i can see that all works as expected.
What im stuck on is im trying to created a View that is filtered to show the following.
Location > Number > Offer (MAX Offer ONLY)
So in other words i guess what im trying to display is the Name of the highest bidder for a particular Number at a Particular Location.
I hope that is understandable.
If there is a suitable base example i can work off that is similar im happy to work off that.
Thanks in advance!