Hello, I have already asked a similar question with no success.
I will try to explain a bit better what I am trying to achieve here.
I am building a website where users can send offers/bids for items on Webflow.
I connected Zapier and Airtable to achieve this flow. Everything is ok, the only problem is if someone sends a bid that is lower than the highest bid it will show as the highest.
I managed to see the record I want to be synced to Webflow on my airtable if I multi filter by “bid” (highest first) and “date” (latest first).
The problem is that when I run Zapier, it will transfer all the data from airtable and not only the top one. Here a screenshot to help you understand:
Also, the bids sent are for connected to multiple records on another table, so I would need to select only the top bid for different records.
My question is: How do I select only the highest number and the latest created?
I hope that someone could help me with this or if you have any other different solution I am happy to change my workflow.
Thanks you very much