# Bug Data Airtable

**URL:** <https://forum.adalo.com/t/bug-data-airtable/1508>\
**Category:** Get Help\
**Created:** [May 24, 2020, 9:22am UTC](https://forum.adalo.com/t/bug-data-airtable/1508 "2020-05-24T09:22:32Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![j.renaud](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@j.renaud](https://forum.adalo.com/u/j.renaud)\
**Post date:** [May 24, 2020, 9:22am UTC](https://forum.adalo.com/t/bug-data-airtable/1508/1 "2020-05-24T09:22:32Z")

</div>

Hello everyone, I find a bug with External collection.

If the user, refresh the webpage with external collection with filter.  
All the data are available, is a big issue.  
Someone have the same problem ?

 ![Capture d’écran 2020-05-24 à 11.19.36](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/1X/12cff95c5bf4a4f71d5e2eeb30c2979c2a809ea9.png)

Also is impossible to put this topic in bug

---

<div class="post-metadata">

**Author:** ![j.renaud](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@j.renaud](https://forum.adalo.com/u/j.renaud)\
**Post date:** [May 24, 2020, 9:23am UTC](https://forum.adalo.com/t/bug-data-airtable/1508/2 "2020-05-24T09:23:20Z")

</div>

@Ben that is normal .

---

<div class="post-metadata">

**Author:** ![AddyEdwin](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@AddyEdwin](https://forum.adalo.com/u/AddyEdwin)\
**Post date:** [June 14, 2020, 5:54pm UTC](https://forum.adalo.com/t/bug-data-airtable/1508/3 "2020-06-14T17:54:41Z")

</div>

Hello, I think I’m having the same problem that Renaud is saying here. Here’s how I am replicating the bug each time:

I’m using an external collection (airtble database) and have made a custom list. I have set a filter on the list to show only specific records from my database. I’m using a filter which connects to a property of the user, say “{user\_designation}” = “executive” where the “executive” value is pulled from the user’s login input via magic text.

In the mobile app, when I load the screen with this custom list, in the beginning all the records in the list is displayed, which quickly corrects itself after approximately one second to show only the filtered records. On desktop, if I recreate the same list with the same set of database and filters, all the records show up but they don’t go away after 1 second. They remain there until I perform any sort of action or click a button (this could be clicking on a link and going back, clicking on a button with a ‘blank’ action, etc.). This is frustrating because it opens up the possibility of the user accessing information they’re not supposed to, on the desktop app. They can also do the same in the mobile app, if they click on an item on the list before the filter kicks in, but I’m at least trusting that they won’t be fast enough.

Please note that this only happens if I set the filter to query from Adalo’s database via a magic text. If I set the filter to simply as {user designaton} = ‘executive’ then this doesn’t happen

---

<div class="post-metadata">

**Author:** ![AddyEdwin](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@AddyEdwin](https://forum.adalo.com/u/AddyEdwin)\
**Post date:** [June 14, 2020, 8:59pm UTC](https://forum.adalo.com/t/bug-data-airtable/1508/4 "2020-06-14T20:59:17Z")

</div>

I’ve found the solution here @j.renaud

> [@Query Parameter with Airtable](https://forum.adalo.com/t/query-parameter-with-airtable/418/8):
>
> Hello Everyone! Even I had the same issue and support people gave me a work around with which I was able to solve this issue. The issue here is that the way the screens load the table is not able to load the user email all in one as you have set up. To work around this you can have a blank screen before this screen that transitions by none in which through a text component and magic text you have the logged in users email on that screen (it can be white/hidden to not show). We have also seen u…

---

<div class="post-metadata">

**Author:** ![j.renaud](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@j.renaud](https://forum.adalo.com/u/j.renaud)\
**Post date:** [June 19, 2020, 10:15am UTC](https://forum.adalo.com/t/bug-data-airtable/1508/5 "2020-06-19T10:15:05Z")

</div>

I don’t really understand the solution.  
I need to create a blank screen before make a redirection to the page ?  
Because this happen only if the user refresh the page

---

<div class="post-metadata">

**Author:** ![AddyEdwin](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@AddyEdwin](https://forum.adalo.com/u/AddyEdwin)\
**Post date:** [June 19, 2020, 11:58am UTC](https://forum.adalo.com/t/bug-data-airtable/1508/6 "2020-06-19T11:58:45Z")

</div>

Hello @j.renaud

I found a better solution than the above workaround, that I’ve now mentioned in that thread. This eliminates the need for having an input field altogether, and works 100% of the time, even after pressing F5 on a page. This is based on an observation that running any action triggers the filter to ‘readjust’ and work properly.

# What you need to do

So what you need to do is add a ‘blank’ action in the _screen’s_ properties (e.g. “Change input value” but keep the fields empty; see the image below), and this triggers the filter to run correctly whenever the page loads. It does add a jarring stutter every time you transition back and forth the page though, so you can disable screen transition animations since they aren’t used that much in web apps anyway

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

---

<div class="post-metadata">

**Author:** ![Russ](https://avatars.discourse-cdn.com/v4/letter/r/e36b37/32.png) [@Russ](https://forum.adalo.com/u/Russ)\
**Post date:** [November 10, 2020, 4:53pm UTC](https://forum.adalo.com/t/bug-data-airtable/1508/7 "2020-11-10T16:53:47Z")

</div>

> [@AddyEdwin](#):
>
> you can disable **screen transition animations** since they aren’t used that much in web apps anyway

Hello, I’m looking to understand screen transitions better. Could I ask please, where is the setting to disable screen transition animations.

Separately, when setting a screen transition to Push or to None, does that choice control just the visual effect in how the new screen is rendered, or does it control other things as well, like data passed to the new screen or other parameters.

(I’m not seeing a description of this in the Adalo training, hope I didn’t overlook something obvious.)

Thank you,  
Russ

---

<div class="post-metadata">

**Author:** ![AddyEdwin](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@AddyEdwin](https://forum.adalo.com/u/AddyEdwin)\
**Post date:** [November 12, 2020, 6:55pm UTC](https://forum.adalo.com/t/bug-data-airtable/1508/8 "2020-11-12T18:55:24Z")

</div>

To disable screen transition animation, I just set the screen transition to None.

As for your second question, it only controls the visual effect on how the screen is rendered, nothing else. The data is passed normally and is not affected

---

<div class="post-metadata">

**Author:** ![Russ](https://avatars.discourse-cdn.com/v4/letter/r/e36b37/32.png) [@Russ](https://forum.adalo.com/u/Russ)\
**Post date:** [November 13, 2020, 8:24pm UTC](https://forum.adalo.com/t/bug-data-airtable/1508/9 "2020-11-13T20:24:32Z")

</div>

AddyEdwin, thank you, much appreciated!  
Russ
