# Inconsistency in results returned from Airtable

**URL:** <https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642>\
**Category:** Questions about Thunkable X\
**Created:** [August 22, 2019, 7:02am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642 "2019-08-22T07:02:38Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![bloomort1txs](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bloomort1txs/32/41703_2.png) [@bloomort1txs](https://community.thunkable.com/u/bloomort1txs)\
**Post date:** [August 22, 2019, 7:02am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/1 "2019-08-22T07:02:38Z")

</div>

Does anyone else have the problem when live testing that the results returned from a query to Airtable are not consistent?  
If so how do I fix this?  
I have added a 3 second delay and most of the time the full results are returned, but this is inefficient.

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [August 22, 2019, 12:02pm UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/2 "2019-08-22T12:02:07Z")

</div>

See my example of working with AirTable on the scrAirTable screen. Does it work for you well?

[https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/](https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![bloomort1txs](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bloomort1txs/32/41703_2.png) [@bloomort1txs](https://community.thunkable.com/u/bloomort1txs)\
**Post date:** [August 23, 2019, 8:20am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/3 "2019-08-23T08:20:17Z")

</div>

Sorry, no. There are no airtable functions on scrairtable

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [August 23, 2019, 8:26am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/4 "2019-08-23T08:26:50Z")

</div>

Your words surprise me a little. You do not have these blocks on the screen?

![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/01afa30ede440b07c6bde304f15897ef1c627da8.png)

To run my project, you do not need to do remix (otherwise access to the database will be closed and nothing will work).

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [August 23, 2019, 6:57pm UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/6 "2019-08-23T18:57:55Z")

</div>

Doing nested loops with Internet requests inside them is a bad decision. Solve the problem sequentially.

1. First, find the app User Id. If it is successfully found, then
2. find the information in the following table. If this information is found,
3. then find the information in the last table.

And your algorithm spars in cycles even without checking for errors! Of course there will be problems.

Remember for the future. If your application uses a block with a delay, then in 99% this indicates that the algorithm is incorrectly composed.

---

<div class="post-metadata">

**Author:** ![bloomort1txs](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bloomort1txs/32/41703_2.png) [@bloomort1txs](https://community.thunkable.com/u/bloomort1txs)\
**Post date:** [August 24, 2019, 7:53am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/7 "2019-08-24T07:53:02Z")

</div>

Thanks I’ll give it a go and let you know the reslults.

---

<div class="post-metadata">

**Author:** ![bloomort1txs](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bloomort1txs/32/41703_2.png) [@bloomort1txs](https://community.thunkable.com/u/bloomort1txs)\
**Post date:** [August 24, 2019, 8:24am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/8 "2019-08-24T08:24:00Z")

</div>

Deleted

---

<div class="post-metadata">

**Author:** ![bloomort1txs](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bloomort1txs/32/41703_2.png) [@bloomort1txs](https://community.thunkable.com/u/bloomort1txs)\
**Post date:** [August 24, 2019, 8:57am UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/9 "2019-08-24T08:57:32Z")

</div>

deleted

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [August 24, 2019, 2:20pm UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/10 "2019-08-24T14:20:51Z")

</div>

1. If I were you, I would not use the app global variables. Use function variables instead which work more reliably.

2. Try to solve the problem sequentially. First look, the first GetAllRows block returns the correct Pharmacy value? If so, then indicate it in the second block and verify that this block returns the correct value Pharmacy Name? And so on.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 12:11pm UTC](https://community.thunkable.com/t/inconsistency-in-results-returned-from-airtable/191642/11 "2024-11-08T12:11:46Z")

</div>


