Search records module with airtable

Okay I figured it out! If anyone else wants to create a scenario like this the formula is:

OR(
AND({Price} >= ({{10.Price}} - 50000), {Price} <= ({{10.Price}} + 50000)),
AND({Price} >= ({{10.Price}} - 100000), {Price} <= ({{10.Price}} + 100000))
)

The {10.Price} is from my transform to text module with openAI to transform the input the user got. so if the user is telling the chatbot 400k for example the openAI will change it to 400000 because it has to match what you have in your airtable. This will help you help you give a couple of example houses to send back to the user. It goes a little above their budget and a little below, as well as staying on target a lot. I am only providing three examples to the user but you can provide more if your client or your business has a crap ton of listings or products.

3 Likes