# Filtering for Airtable not working with Magic Text

**URL:** <https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748>\
**Category:** Get Help\
**Created:** [July 25, 2020, 5:46pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748 "2020-07-25T17:46:24Z")\
**Posts on this page:** 16\
**Page:** 1

<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:** [July 25, 2020, 5:46pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/1 "2020-07-25T17:46:24Z")

</div>

@Ben @jeremy @ashley  
This filter is working:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/9230b7319347d953901f22a865567003f967bbd4.png)

This one fails, delivering all records:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/e8210a079818a38242947cdaa7a200aa98a7e959.png)

Something is wrong with the parameter send to Airtable when Magic Text is involved.  
I know you are busy with the rollout of the Component Marketplace. But this BUG is making Airtable connections almost unusable.

---

<div class="post-metadata">

**Author:** ![ashley](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ashley/32/1635_2.png) [@ashley](https://forum.adalo.com/u/ashley)\
**Post date:** [July 28, 2020, 5:27pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/2 "2020-07-28T17:27:58Z")

</div>

Thanks, the team is doing some testing and see if they can see if/what the issue may be.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.adalo.com/u/patrick)\
**Post date:** [July 28, 2020, 7:57pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/3 "2020-07-28T19:57:15Z")

</div>

@karimoo @ashley  
I was just able to get a filter to apply to a list of an airtable collection using magic text. Can you send some more information about your setup in Adalo?

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 28, 2020, 8:04pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/4 "2020-07-28T20:04:55Z")

</div>

It’s not working with multiple magic text inputs. And there have been times where I can get a single magic text input to work, but sometimes it doesn’t. It also doesn’t work at all for a list within a list.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.adalo.com/u/patrick)\
**Post date:** [July 28, 2020, 8:16pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/5 "2020-07-28T20:16:57Z")

</div>

@karimoo  
@bgschust

Can one or both of you please send me a video of where this happening along with which app and screens are having the problems so that I may take a look at an example? (Preferably one where there is only one Magic text component)

I will look into the list in a list problem as well as with multiple magic text inputs.

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 28, 2020, 8:21pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/6 "2020-07-28T20:21:48Z")

</div>

Patrick, what’s your email? I will send you a Zoom invite.

I’m not that scary to talk to in person or on the phone 🙂

---

<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:** [July 29, 2020, 5:14am UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/7 "2020-07-29T05:14:45Z")

</div>

@patrick @bgschust @ashley  
I guess I figured it out.  
In my example I used:

- Screen 1  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/dc69f1de6ed8ab00164aaf816df0538550b3e24b.png)

- Screen 2  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/63c5d5279ec99372647f5ddfcffbc4bba522420c.png)

**The Challenge**  
I now have TWO Current Simple.  
When I click the Magic Text Button, I first see the one for the list I am trying to filter.  
If I select Current Simple \> fields \> Name from here, I have an invalid selection trying to filter the list with itself.

**Solution**  
I have to scroll down and find _More… Current Simple \> fields \> Name_  
So it all depends on selecting the right context. This “Current duplication” typically also shows up for Lists in Lists.

 ![2020-07-29_06-42-09 (1)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/2007b2ff03e5c1609a30b2ab2d0bed8960ed80ad.gif)

_Result_

 ![2020-07-29_06-57-31 (1)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f0b494af521a7633759dd13ad04bf551367a4729.gif)

**Lesson Learned**

1. **We can have only ONE filterByFormula**. Airtable does not except this query parameter twice. To combine multiple filter we have to use AND, OR in a single query parameter
2. **Choose the right context when using Magic Text**.  
The first “Current” refers to the list you are going to filter and is usually the WRONG one. Look for “More…”
3. **Filtering on Lookup Fields/related tables**  
Do **not**  **use** the airtable **id**. _filterByFormula_ expects the _Primary key_ of the linked table, which is usually _Name_.  
When adding Lookup fields in Airtable always add the _Name/Primary Key_.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1ceb63b77f9035d27885512af92000573b58e397.png)

Choose this lookup\_name field for filtering:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3df80fec0647f58fe3d3c2bef6ec5194b1619012.png)

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 29, 2020, 3:15pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/8 "2020-07-29T15:15:48Z")

</div>

Do you have an example of where you were able to pass in multiple inputs/filters into one filterByFormula? I regularly go to “More…” when selecting options but that hasn’t fixed the issue for me yet.

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 29, 2020, 3:18pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/9 "2020-07-29T15:18:52Z")

</div>

@jeremy @patrick  
Could people stop working on the live version because now a bunch of my input fields are missing in my primary app. There should be more compatibility testing before features go live.

---

<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:** [July 29, 2020, 3:33pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/10 "2020-07-29T15:33:59Z")

</div>

@bgschust One Example I have:  
Combination of Dropdown Menu and Search:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7ca81e1f0a4ae763771ba7fe06d65314863413b2.png)

According to Airtable API documentation any _formula_ with Airtable syntax should work:  
See: [Formula Field Reference - Overview | Airtable Support](https://support.airtable.com/hc/en-us/articles/203255215#logical)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/fc0cf7507db21457a81f694d5a1d3ccbe7bc2902.png)

---

<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:** [July 29, 2020, 3:37pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/11 "2020-07-29T15:37:33Z")

</div>

@bgschust The combination from the example works from Airtable side, but there is still an issue under investigation 😉  
See: [Change in dropdown does not trigger refresh of list](https://forum.adalo.com/t/change-in-dropdown-does-not-trigger-refresh-of-list/2690)

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 29, 2020, 4:13pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/12 "2020-07-29T16:13:45Z")

</div>

I’m pretty sure I’m running a different version from you and most people because a lot of my stuff breaks and crashes. My input fields disappeared.

The math (sum, avg, count) etc. was the main thing holding me back until the input fields disappeared.

---

<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:** [July 29, 2020, 4:44pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/13 "2020-07-29T16:44:18Z")

</div>

What browser are you using? I am using Chrome.  
And as they are doing continues changes, the usual suspect: Browser Cache??

---

<div class="post-metadata">

**Author:** ![bgschust](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bgschust](https://forum.adalo.com/u/bgschust)\
**Post date:** [July 29, 2020, 4:51pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/14 "2020-07-29T16:51:31Z")

</div>

I’ve used both browsers. Firefox works better when I load Adalo in it than in Chrome on my system. I have Windows 10 running on a Lenovo E series laptop. The problems I’m having don’t seem to be related to the browser cache.

But I will reset my router and wait 10 seconds if you want me to. JK, I wouldn’t actually go that far.

---

<div class="post-metadata">

**Author:** ![jeremy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jeremy/32/385_2.png) [@jeremy](https://forum.adalo.com/u/jeremy)\
**Post date:** [July 29, 2020, 5:26pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/15 "2020-07-29T17:26:17Z")

</div>

@karimoo I believe the issues here are most commonly caused by using data that’s not yet available.

For example if you have a home screen with a filtered list, and the filter includes something from **Logged In User \> name** , then we’ll have to load the logged in user first, then load the filtered list, based on the response that included the logged in user’s name.

Right now, we’re requesting all the data at the same time, so Logged In User is not available by the time we try to load data from Airtable.

We are working to solve this issue, but unfortunately it’s a bit involved, and may take a couple of weeks still before it’s fixed.

---

<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 8, 2020, 5:26pm UTC](https://forum.adalo.com/t/filtering-for-airtable-not-working-with-magic-text/2748/16 "2020-08-08T17:26:19Z")

</div>

Closed on August 8, 2020, 5:26pm UTC

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