Hello Makers. I am making a scenario which is connected with voiceflow. This will be a home recommendation for any user that is looking to buy a house. In the chatbot it will ask for a price range. So if the user says they have a budget of $500,000 for example it should be sent to make.com where it willl search records in my airtable with my clients listing. Here is a small problem though. I am not getting the correct records back. I am not getting anything close. So If I test it with $700,000 I get back records of houses that have maybe $300,000 prices or way more. It is usually off by hundred of thousands of dollars. Can some one help me? I want to say that its with my formula but I believe my formula is correct. So I am not sure what is going on here. Please help.
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.