# filterByFormula : Search on Filtered fields (API integration with Airtable)

**URL:** <https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232>\
**Category:** Get Help\
**Created:** [August 12, 2020, 2:43pm UTC](https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232 "2020-08-12T14:43:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![intimur](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/intimur/32/17493_2.png) [@intimur](https://forum.adalo.com/u/intimur)\
**Post date:** [August 12, 2020, 2:43pm UTC](https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232/1 "2020-08-12T14:43:08Z")

</div>

Hi!

I am trying to extract a filtered view from a specific field (list of document = to the user ID) and have this user from a search bar Search() or Find () a document tag .

AND(  
Search(‘Search Term’, {doc-tag}),  
({company-id}=‘User company-id’)  
)

The first time the user logs in and nothing has been typed (yet) in the search bar, it seems that the query is not yet triggered (maybe because as their is no search term typed, the AND formula returns false), it’s only after the user types any string that the query is enabled.

Any tips on that issue?

Thanks!

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 12, 2020, 7:26pm UTC](https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232/2 "2020-08-12T19:26:45Z")

</div>

As far as I understand, the search in Airtable is triggered, but if nothing is typed in the search field, the search is done for an empty string _’’_ ,which does not find any records.

---

<div class="post-metadata">

**Author:** ![intimur](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/intimur/32/17493_2.png) [@intimur](https://forum.adalo.com/u/intimur)\
**Post date:** [August 13, 2020, 1:38pm UTC](https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232/3 "2020-08-13T13:38:16Z")

</div>

Hi, thanks for your message.

Yes, I guess. As nothing is typed yet, the AND formula returns false, only after the first typo the AND formula returns true with the correct set of records.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [August 23, 2020, 1:38pm UTC](https://forum.adalo.com/t/filterbyformula-search-on-filtered-fields-api-integration-with-airtable/3232/4 "2020-08-23T13:38:22Z")

</div>

Closed on August 23, 2020, 1:38pm UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
