# I cant fix the formula in the airtable "Search Records"
**URL:** https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462
**Category:** Questions
**Tags:** airtable
**Created:** [March 17, 2025, 6:58pm UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462 "2025-03-17T18:58:39Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Santos](https://community.make.com/u/Santos)
#### Post date: [March 17, 2025, 6:58pm UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462/1 "2025-03-17T18:58:39Z")
I am working on an appointment scheduler, rescheduler and canceler.
I need a formula that searches for a specific **Firstname, Lastname, Date, and Time**. The formula should check whether the specified appointment details are available.
- If no matching appointment is found, the output should be **TRUE**.
- If there is an overlapping appointment, the output should be **FALSE**.
This is my formula right now: after this module i want to make a router. but is doenst seem to work.
---
### Author:  [@dilipborad](https://community.make.com/u/dilipborad)
#### Post date: [March 18, 2025, 4:19am UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462/2 "2025-03-18T04:19:37Z")
Hello @Santos,
The formula you write on the Airtable Formula box in Make, Is not the same as you write on Airtable Formula Field.
This formula in the make follows the specific syntax of the airtable formula that you can check here. [Airtable Web API - Using filterByFormula or sort parameters](https://support.airtable.com/docs/airtable-web-api-using-filterbyformula-or-sort-parameters)
As of now try to remove the surrounded if and use `AND()` only.
**Also, please check my answers related to this topic.**
> [@Issue with Airtable Search Records Module and Formula](https://community.make.com/t/issue-with-airtable-search-records-module-and-formula/66005/2):
>
> Hello @Lucie_Pospechova, Welcome to the community. First of all +1 for explaining things in detail. This is a direct solution for you. Formula: REGEX\_MATCH({Image field},"Stored Image name in Airtable without extension") To remove file extension from the name you need to use Make’s string functions. If you need to understand it more. Understand the Basics You need to understand things about how the Airtable formula function works here while you use it with API or in make …
> [@Creating Interations From Multiple Arrays](https://community.make.com/t/creating-interations-from-multiple-arrays/58261/3):
>
> Hello, Use filterByFormula API Function with Airtable’s original functions. Check some reference posts of articles about how to use filterByFormula. Posts in Make Community: Other Posts:
> [@Airtable: \[422\] Unknown field name: true](https://community.make.com/t/airtable-422-unknown-field-name-true/64804/4):
>
> Hello @Scottinabox, Instead of that try this AND({Status}='Done') Instead of AND you can use OR, SEARCH, or REGEX\_MATCH. But it all depends on the requirements. The things you’ve tried were not matched with the Airtable formula structure. You need to match with airtable formula syntax. Read more on these help docs and community articles.
* * *
💡P.S.: Always search first, Check [Make Academy](https://community.make.com/t/make-academy-course-overview/29699). If this is helpful, [Mark Best as Solutions](https://community.make.com/t/mastering-the-make-community-mark-best-answers-as-solutions/4685) ✅ and give 👍
If you need expert help or have questions? Contact or comment below! 👇
---
### Author:  [@Santos](https://community.make.com/u/Santos)
#### Post date: [March 18, 2025, 4:28pm UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462/3 "2025-03-18T16:28:29Z")
it works right now!
Thank you for helping
---
### Author:  [@dilipborad](https://community.make.com/u/dilipborad)
#### Post date: [March 19, 2025, 4:35am UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462/4 "2025-03-19T04:35:25Z")
✅ Please remember to mark the most helpful replies to your questions as [solutions.](https://community.make.com/t/community-handbook-p-5-marking-a-solution/4685) It helps keep the community organized.
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [April 3, 2025, 5:46am UTC](https://community.make.com/t/i-cant-fix-the-formula-in-the-airtable-search-records/75462/5 "2025-04-03T05:46:43Z")