# Show partial records when using Data Viewer List

**URL:** <https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829>\
**Category:** Questions about Thunkable X\
**Created:** [October 24, 2023, 8:19am UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829 "2023-10-24T08:19:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)\
**Post date:** [October 24, 2023, 8:19am UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/1 "2023-10-24T08:19:02Z")

</div>

Ciao.  
I’d like to generate a page with the simple DVL but with not all the records it founds on table, but with only some of them, selected (for example) by Customer Code.

f.i…

**Records in Table XXX**  
12,alpha,beta  
12,gamma,delta  
13,jolly,tango  
13,lion,tiger

I want to show (by using DVL) only records starting with “12”

Grazie

---

<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:** [October 26, 2023, 6:46pm UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/2 "2023-10-26T18:46:26Z")

</div>

Hello @rusticone  
You will need to connect the Data Viewer List with a local table. Each time that you will open the screen, the old data will be deleted from the local table and the new data will be saved to the local table if the condition is true. Please check the example below.

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

---

<div class="post-metadata">

**Author:** ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)\
**Post date:** [October 27, 2023, 8:47am UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/3 "2023-10-27T08:47:07Z")

</div>

Grazie! I’ll try it asap!

---

<div class="post-metadata">

**Author:** ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)\
**Post date:** [October 27, 2023, 9:55am UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/4 "2023-10-27T09:55:38Z")

</div>

Well. I did this:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/2/d2aba4fda485ba49e1613381a8bee35e0127023c.png)  
But I have two problems:

- the local table (tmpAcquisti) doesn’t erase;
- the loop “repeat X times” doesn’t ends…

Grazie!!

---

<div class="post-metadata">

**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\
**Post date:** [October 27, 2023, 10:06am UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/5 "2023-10-27T10:06:09Z")

</div>

> [@rusticone](#):
>
> the loop “repeat X times” doesn’t end…

Because you are creating a row, triggering the loop. It’s like having one paper and adding a new paper the number number of papers.

> [@rusticone](#):
>
> the local table (tmpAcquisti) doesn’t erase;

Because you are adding a row again

---

<div class="post-metadata">

**Author:** ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)\
**Post date:** [October 27, 2023, 5:28pm UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/6 "2023-10-27T17:28:14Z")

</div>

I tried to copy the note suggested by @ioannis up here…

---

<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:** [January 25, 2024, 5:28pm UTC](https://community.thunkable.com/t/show-partial-records-when-using-data-viewer-list/2660829/7 "2024-01-25T17:28:19Z")

</div>

Closed on January 25, 2024, 5:28pm UTC

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