# List View update

**URL:** https://community.thunkable.com/t/list-view-update/1658130
**Category:** Questions about Thunkable X
**Created:** [December 21, 2021, 9:48am UTC](https://community.thunkable.com/t/list-view-update/1658130 "2021-12-21T09:48:12Z")
**Posts on this page:** 17
**Page:** 2

<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: [January 10, 2022, 11:24am UTC](https://community.thunkable.com/t/list-view-update/1658130/21 "2022-01-10T11:24:30Z")

</div>

I think what you see is the effect of previous searches. So if you start by clearing the previous results then you will see the difference.

See this

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/4/74833abf335fe399bd6a3bb4877ecb7805d55dde.png)

---

<div class="post-metadata">

### Author: ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)
#### Post date: [January 10, 2022, 12:05pm UTC](https://community.thunkable.com/t/list-view-update/1658130/22 "2022-01-10T12:05:35Z")

</div>

That’s how it works, great  
In the meantime I have changed something else

Three problems remain

1. If the object is not assigned to any team, and therefore finds “-” in the corresponding column, upon selection it updates the column corresponding to the selected Team and updates the list, if instead it finds a different Team, the alert opens with the request to confirm the modification or not to modify anything, if I click on “Yes, modify” it does not update the cell in the corresponding column, but updates the “List\_Employee\_Select”  

2. if I insert the “SerchString” variable that has been populated by the “Item” of the ListView, a white cell appears in the “List\_Employee\_Select”, leaving the “Item” working  

3. if the “-” is present in the “Selected” column, it works, if I leave it empty it doesn’t work, obviously also by changing the parameters in the search variables  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/ae255a42a1f3ced0f285a07badb84cd07fd2542c.png)

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d9f9ff3a7b854e05d99998a32c053f67feccd518.png)

Thanks for your help

---

<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: [January 10, 2022, 12:46pm UTC](https://community.thunkable.com/t/list-view-update/1658130/23 "2022-01-10T12:46:20Z")

</div>

I’m not in front the computer now but will look into it later.

---

<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: [January 10, 2022, 5:05pm UTC](https://community.thunkable.com/t/list-view-update/1658130/24 "2022-01-10T17:05:08Z")

</div>

Hello @dimaurosalvo19717s1y ,  
I just checked the project you shared earlier and the blocks you are describing above are not present. Can you share the project again?

---

<div class="post-metadata">

### Author: ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)
#### Post date: [January 10, 2022, 5:11pm UTC](https://community.thunkable.com/t/list-view-update/1658130/25 "2022-01-10T17:11:10Z")

</div>

I thought that with the same link you could resume the updated project

here is the link  
[https://x.thunkable.com/copy/d45e373b5394e90227bb179cf8574458](https://x.thunkable.com/copy/d45e373b5394e90227bb179cf8574458)  
thank you

---

<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: [January 10, 2022, 5:25pm UTC](https://community.thunkable.com/t/list-view-update/1658130/26 "2022-01-10T17:25:41Z")

</div>

Thank you.

There are two types of links

1- The one which has `/copy/` gives a snapshot in that time.  
2- The one which has `/projects/` or `/projectPage/` can give you the updated project every time you click on it.

---

<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: [January 10, 2022, 5:59pm UTC](https://community.thunkable.com/t/list-view-update/1658130/27 "2022-01-10T17:59:29Z")

</div>

Let me try to explain something that is not easy to grasp with linear programming languages.

Thunkable is color coding the blocks to make it easier to identify and most of the **purple** ones as **asynchronous** which means they will not hold the execution of the blocks coming after them but rather will do take the commands and give control to the next block while they do whatever is required from them to do.

Now let me be specific about your code.  
You have this block  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/3/d35c4e2e5098e097bfa19004076adb57e9fbe574.png)  
Which you would think it should wait for your response to confirm if you want to update the value or not and it is actually doing that.

However, before showing you the `Alert` message, remember this block is purple, it will give control to the next available block to execute while waiting for you to select an option.  
By the time you have selected an option, this block has executed already.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/0/f08c46bf9c247b8ad88732e138a564148d381691.png)

Therefore, the update to the Google sheet will fail.

Hope this clarifies why this option never get executed correctly.

---

<div class="post-metadata">

### Author: ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)
#### Post date: [January 10, 2022, 8:49pm UTC](https://community.thunkable.com/t/list-view-update/1658130/28 "2022-01-10T20:49:09Z")

</div>

You opened a world to me … Thanks  
you were very clear,  
I think I solved it by moving the function by placing it inside the blocks I run, I did some tests, I believe that by doing so everything works perfectly.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9db3efe2521aaf060febc34826b6a16f3c232188.png)

the only “problem” that remains is that if I leave the cell in the Team column empty, it seems unable to retrieve the “empty” data

---

<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: [January 10, 2022, 9:14pm UTC](https://community.thunkable.com/t/list-view-update/1658130/29 "2022-01-10T21:14:27Z")

</div>

> [@dimaurosalvo19717s1get y](#):
>
> it seems unable to retrieve the “empty” data

I will look into this tomorrow. It’s after midnight where I live.

I need more details from you. What do you mean **unable to retrieve empty data**?

Do you mean when you use `get value` block you don’t get a result?

---

<div class="post-metadata">

### Author: ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)
#### Post date: [January 11, 2022, 9:34am UTC](https://community.thunkable.com/t/list-view-update/1658130/30 "2022-01-11T09:34:14Z")

</div>

Basically when the cells are empty, without any sign, it freezes without moving forward, as per the attached video

![Cells Empty](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/b/fb0ce87ecb3c8b1ec17fa148557a7f99e4a0615e.gif)

Another “Problem”, when I insert an object already belonging to a Team, the Team changes correctly with the new one after accepting the change, at the second request to insert the same object, it is as if the variable was not updated, proposing the initial Team again , although on google sheet it has already been updated, see the attached video

![Double](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/9/c91d812cb05ccedab31cfd1489388e74ac316751.gif)

---

<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: [January 11, 2022, 3:47pm UTC](https://community.thunkable.com/t/list-view-update/1658130/31 "2022-01-11T15:47:29Z")

</div>

I will need to check the first issue and let you know later.

As for the second issue, this is an old **BUG** (@jared, let me know if it falls into other categories ) in Thunkable. If you use `get value` then it will only get the value the first time you issue the command all subsequent requests will take the value from cache instead of the true value in the Google sheet.

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [January 11, 2022, 9:50pm UTC](https://community.thunkable.com/t/list-view-update/1658130/32 "2022-01-11T21:50:59Z")

</div>

It’s not a ‘bug’ as much as it is poor UX. It’s not broken, it just doesn’t do what most of us expect it to or doesn’t behave fully the way most of us expect it to, it would seem. Ideally we would be able to toggle between using cached data or requesting fresh data.

Do you know if a feature request or bug report has been created in relation to this, by chance? Does this affect all data sources or only google sheets?

---

<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: [January 12, 2022, 9:27am UTC](https://community.thunkable.com/t/list-view-update/1658130/33 "2022-01-12T09:27:26Z")

</div>

> [@jared](#):
>
> Do you know if a feature request or bug report has been created in relation to this

No, I don’t. I rarely scan through the bug list.

---

<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: [January 12, 2022, 11:14am UTC](https://community.thunkable.com/t/list-view-update/1658130/34 "2022-01-12T11:14:07Z")

</div>

The workaround for your second issue is to use the `ger row` block instead of `get value`. You will get the updated value with the `get row` block.

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [January 12, 2022, 11:37am UTC](https://community.thunkable.com/t/list-view-update/1658130/35 "2022-01-12T11:37:41Z")

</div>

I’ll make sure to raise this with a support ticket today. It is poor UX to only grab data once, ideally it only caches the data until the next data grab. This could help mask connectivity issues but makes getting fresh data (currently) a pain in the but.

We want it to be easier to use, not harder. 🙂

---

<div class="post-metadata">

### Author: ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)
#### Post date: [January 12, 2022, 1:12pm UTC](https://community.thunkable.com/t/list-view-update/1658130/36 "2022-01-12T13:12:49Z")

</div>

It works, great

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [April 12, 2022, 1:12pm UTC](https://community.thunkable.com/t/list-view-update/1658130/37 "2022-04-12T13:12:55Z")

</div>

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

[Previous page](https://community.thunkable.com/t/list-view-update/1658130.md?page=1)
