# In this code ,each time to run project ,the result different

**URL:** <https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [August 5, 2021, 4:53pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030 "2021-08-05T16:53:59Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 5, 2021, 4:53pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/1 "2021-08-05T16:53:59Z")

</div>

This project I add database from Airtable into list name whiteboard. and I found the result of running project are different. I think it 's because of time in each process. but I’m not sure. In fact it should be the same result in every run time. How can I fix it or what’s the problem of my code. Actually I don’t want to used wait block because I think it’s not make sense .

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 5, 2021, 4:56pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/2 "2021-08-05T16:56:07Z")

</div>

![12](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/6/162bdb4e616a91dfbae6865e430a7b4972f4fdf2.jpeg)

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 5, 2021, 5:25pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/3 "2021-08-05T17:25:30Z")

</div>

![13](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/01ba4ef3153c13342c44e58c4e5f60a01f3ef0e7.jpeg)

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 5, 2021, 6:40pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/4 "2021-08-05T18:40:37Z")

</div>

Can you explain why are you using a `cloud` variable for the list you are building from Airtable?

Can you also explain why when you are trying to find a matching entry in the list, you added “,” to the string to be found?

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 3:28am UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/5 "2021-08-06T03:28:54Z")

</div>

Can you explain why are you using a `cloud` variable for the list you are building from Airtable?

> > I just try to change from app , store and cloud for see the difference result . and I found that it’s not effect for the result.

Can you also explain why when you are trying to find a matching entry in the list, you added “,” to the string to be found?

> > “,” is added by airtable3.getallrow  
> > I try to find the record that match both date and name and want to retrieve jobname from that record.  
> > because actually I want to script in airtable but the problem is I use free pro for airtable so the automatic script not provide in free pro.  
> > and after that I use airtable.getallcell to list j and use for loop to check data in each row in the list . I found that for loop work through until the end of the list by passing any checking process. (if condition inside for loop)  
> > so I decided to getalltable to the whiteboardlist and loop for check each row instead. and now this is the probem I found again.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 6, 2021, 10:11am UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/6 "2021-08-06T10:11:52Z")

</div>

> [@yinnatthachatfly](#):
>
> I just try to change from app , store and cloud for see the difference result

For this case, better use **app variable**

> [@yinnatthachatfly](#):
>
> “,” is added by airtable3.getallrow

There must be something wrong. Airtable will not add any text to your entries. Please check again as this will make the condition to evaluate to **FALSE** every single time.

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 12:51pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/7 "2021-08-06T12:51:55Z")

</div>

![Untitled](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/f/efd07e9fe2ad253a76dc75416b4dd670767093d0.png)

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 12:54pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/8 "2021-08-06T12:54:18Z")

</div>

this is a result from airtable3.getallrow . “,” is added into the list automatically.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 6, 2021, 12:55pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/9 "2021-08-06T12:55:37Z")

</div>

This is correct. You are trying to view a **list** in a **text** field so Thunkable will show you the entries in the list separated by comma.

If you view the same list in a `List Viewer` you will see the content of the list without the comma.

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 1:16pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/10 "2021-08-06T13:16:50Z")

</div>

ahh,I see.

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 1:18pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/11 "2021-08-06T13:18:51Z")

</div>

![Untitled](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4ddd1622682e3e47f51667a4dc62f17921704b13.png)

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 1:20pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/12 "2021-08-06T13:20:25Z")

</div>

This is text I want to search in the list ,but it’s still not found.  
I deleted “,” from list condition to search already.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 6, 2021, 1:26pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/13 "2021-08-06T13:26:57Z")

</div>

Now we come to the other point that you made in your own code.

If you closely look at how you add to the list you will see that you are adding a list to a list

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/8/a801464e9b56c081e150fb95c22a4ed2101eccf3.jpeg)  
Your code is searching in **List 1** but you are saving your data in **List 2** and therefore the test condition will always yield **FALSE**.

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 6, 2021, 2:30pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/14 "2021-08-06T14:30:14Z")

</div>

I understand that this code keep data set of list2 into whiteboardlist as insert at last. Is it true?  
How can I correct it in searching process?

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 6, 2021, 2:46pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/15 "2021-08-06T14:46:19Z")

</div>

A picture worth a thousand word

I created this List of a List to be similar to your situation.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/0/c0e173928af7887ddf51acb1f4340a04fea8ba8b.png)

This is the code under the button

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c63d8d4588ba5038a4345d689353b276941b6df3.png)

I’m looking for “KLM”. When I run it I get the following  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/4/142fff3526ef4d539bc3280b099e3f36a898a1ae.png)

---

<div class="post-metadata">

**Author:** ![yinnatthachatfly](https://avatars.discourse-cdn.com/v4/letter/y/7ba0ec/32.png) [@yinnatthachatfly](https://community.thunkable.com/u/yinnatthachatfly)\
**Post date:** [August 7, 2021, 2:03am UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/16 "2021-08-07T02:03:46Z")

</div>

Thank you so much . I try following your suggest and it’s work!!.

---

<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, 1:17pm UTC](https://community.thunkable.com/t/in-this-code-each-time-to-run-project-the-result-different/1433030/17 "2024-11-08T13:17:33Z")

</div>


