I know a lot of people have asked
Leesburg Final_v3_airtable (copy).blueprint (1).json (112.3 KB)
about this, but after 2 days am losing my mind. Scenario: Scrapping website to grab pricing info for storage units, and update Airtable as follows: 1) If it is a completely new combination of Facility ID, UnitSize, and Price - add record. If it is an existing combination of Facility ID and UnitSize, but different price - update existing record with new price. No matter what I have tried, I can’t seem to filter the search reords airtable formula to return records where {Facility ID} = {Facility ID} AND {Unit Size}={{106.unitSize}} Attaching JSON for reference.