# Airtable formula in Search records module **URL:** \ **Category:** Questions\ **Tags:** airtable\ **Created:** [January 31, 2023, 8:41am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443 "2023-01-31T08:41:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Sandra](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sandra/32/7091_2.png) [@Sandra](https://community.make.com/u/Sandra)\ **Post date:** [January 31, 2023, 8:41am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/1 "2023-01-31T08:41:47Z")
Hi, with a webhook I retrieve the values when an order is paid in Woocommerce webshop. I want to upsert the contact in the contacts table in Airtable. So, I think I first have to search for a record in the contacts table with the same mailaddress as in the order. So after the webhook I inserted the Airtable module Search records. As formula to filter the records I typed {E-mail} = and the the email field retrieved by the webhooksmodule. But in the Search module I get the error " RuntimeError[422] The formula for filtering records is invalid: Invalid formula. Please check your formula text." I have tried the same formula without brackets but that doesn’t help. Screenshots: ![Schermafbeelding 2023-01-31 om 08.11.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/a/a90384c1e50855315ea8d0454ed6b4a890f0db3a.png) ![Schermafbeelding 2023-01-31 om 08.12.24](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/5/5cc76c2a27e01a4c12c4b38daa04879eb99d77ce.png) ![Schermafbeelding 2023-01-31 om 08.40.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/d/d896699a3ce3c9e4ddd4d5d75e767363d1600a0f.png) What am I doing wrong? Thanks, Sandra ---
**Author:** ![SebastianMertens](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sebastianmertens/32/4439_2.png) [@SebastianMertens](https://community.make.com/u/SebastianMertens)\ **Post date:** [January 31, 2023, 8:48am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/2 "2023-01-31T08:48:27Z")
@Sandra ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/b/b4cb29ccba7a132ec8d8deb4ae987aa24bfbdb26.png) - Remove the spaces - and put the email into “[some@inbrakets.com](mailto:some@inbrakets.com)” brakets. ---
**Author:** ![Sandra](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sandra/32/7091_2.png) [@Sandra](https://community.make.com/u/Sandra)\ **Post date:** [January 31, 2023, 9:20am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/3 "2023-01-31T09:20:33Z")
Thanks @SebastianMertens for your quick response! It’s working now 😃 ---
**Author:** ![Milan](https://avatars.discourse-cdn.com/v4/letter/m/c77e96/32.png) [@Milan](https://community.make.com/u/Milan)\ **Post date:** [February 24, 2023, 6:37pm UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/4 "2023-02-24T18:37:12Z")
Hello! I have the same error but with this formula: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/b/b6707fd13dfd3e5fa730ab20c5f0df775d888782.png) Can’t figure out where the error is. Any suggestions? ---
**Author:** ![Milan](https://avatars.discourse-cdn.com/v4/letter/m/c77e96/32.png) [@Milan](https://community.make.com/u/Milan)\ **Post date:** [March 6, 2023, 10:26am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/5 "2023-03-06T10:26:35Z")
@SebastianMertens sorry for bothering, but we really need some assistance with this. We want to test if Make can work for us, and if does we want to transfer many of our workflow and move from Zapier. ---
**Author:** ![SebastianMertens](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sebastianmertens/32/4439_2.png) [@SebastianMertens](https://community.make.com/u/SebastianMertens)\ **Post date:** [March 6, 2023, 10:48am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/6 "2023-03-06T10:48:59Z")
{Post\_Date\_String}=“{{formatDate({{now}}; YYYY-MM-DD}}” Do not use the equation function ( the green = ) Use a typed = ---
**Author:** ![Milan](https://avatars.discourse-cdn.com/v4/letter/m/c77e96/32.png) [@Milan](https://community.make.com/u/Milan)\ **Post date:** [March 6, 2023, 11:07am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/7 "2023-03-06T11:07:47Z")
Thank you, but then I get an error: The operation failed with an error. [404] NOT\_FOUND ---
**Author:** ![SebastianMertens](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sebastianmertens/32/4439_2.png) [@SebastianMertens](https://community.make.com/u/SebastianMertens)\ **Post date:** [March 6, 2023, 11:28am UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/8 "2023-03-06T11:28:57Z")
[https://support.airtable.com/docs/formula-field-reference](https://support.airtable.com/docs/formula-field-reference) ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 7, 2023, 3:43pm UTC](https://community.make.com/t/airtable-formula-in-search-records-module/7443/9 "2023-09-07T15:43:19Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.