Please Any one help me with airtable search records formula

[Ajit_Rao]

This is my Airtable in this i was converting the time in desired time-zone into IST

This is Settings of that column please any one help me to write a formula that only returns a record that matches the current time in IST. I tried different ways But the airtable was not returing any records.

[dilipborad]

Hello @Ajit_Rao,
Welcome to the community.

I’ve already given multiple answers on this topic about how to use Airtable FilterByFormula with Make.
Please check this answers where I’ve also attached multiple related to it.

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

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. 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. :light_bulb:P.S.: Always search first, Check Make Ac…

[422] The formula for filtering records is invalid: Unknown field names: false

Hello @cleanbooks, There are 2 solutions you can do. As per Current Setup The Airtable Search Module formula field needs a formula syntax based on the airtable formula check this Airtable Web API - Using filterByFormula or sort parameters In your case, you need to use airtable functions AND, SEARCH or any of the Regular Expression. Please try both of these because the field {temp4} returns a boolean(true or false). Not sure that quote ("), is needed. Add these to your airtable field formula…

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!