I cant fix the formula in the airtable "Search Records"

[Santos]

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.

[dilipborad]

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

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

Hello @Lucie_Pospechova, Welcome to the community. First of all 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. [image] 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

Hello, Use filterByFormula API Function with Airtable’s original functions. [Make_airtable_filterByFormula] Check some reference posts of articles about how to use filterByFormula. Posts in Make Community: Other Posts:

Airtable: [422] Unknown field name: true

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. If this is helpful, Mark Best as Solutions and give
If you need expert help or have questions? Contact or comment below!

[Santos]

it works right now!

Thank you for helping

[dilipborad]

Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.