Hi guys,
I’m looking for some opinions and solutions to my problem. I built a webhook that is connected to the Webflow website. I’m working on a search on the website for Airport Transfer. I have a search form “from location” and “to location”, and Google Maps is integrated into those searches.
In Google Sheets, I have exact routes also from-to and prices, with postcodes in column A, for example, SW10, E11, etc. The other column is Airport postcodes or names column B. And inversely, from the airport to home.
So I tried to filter google sheets with contains, to split locations and find exact matches. But for example, if I search SW10 and I have contains method, it will show me W10 as the answer. The latest problem was that I tried to split the location and word by word to see is it matched and to ask if the airport location included the airport from the sheet. But then there was a problem, that it found 4 answers and one was right. The wrong answers were, for example, found an airport like an exact match and the location contains the postcode from the sheet.
So I could try to write every possible way, and I will work nicely but I think that there is easier way and I want to see if anyone could help me.
Thank you.