# Best way to pull data into Simple List viewer

**URL:** https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837
**Category:** Questions about Thunkable X
**Created:** [October 12, 2023, 1:34pm UTC](https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837 "2023-10-12T13:34:04Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)
#### Post date: [October 12, 2023, 1:34pm UTC](https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837/1 "2023-10-12T13:34:04Z")

</div>

Hi,

I have a table in Xano called Retailer (fields - Name and Id) and am using an API to pull the data and display in a Simple List Viewer sorted by name.

Once a name is selected, I want to search another table (fields - id, location\_name, retailer\_id) for the locations of the retailer. The way I prefer to search this table is by the retailer\_id rather than by name, but the only information that the Simple List viewer holds is the name and the index (and the index does not necessarily match the retailer\_id).

Is there any way to substitute a variable for the index in the Simple List Viewer?

Thanks  
Steve

---

<div class="post-metadata">

### Author: ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)
#### Post date: [October 14, 2023, 11:07pm UTC](https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837/2 "2023-10-14T23:07:50Z")

</div>

Anyone??

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 15, 2023, 1:03am UTC](https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837/3 "2023-10-15T01:03:54Z")

</div>

There is no automated way to do this. You’ll need to search the second table for the value from the green [item] block from the Simple List Viewer click event. You can use the [find first occurrence] of block to figure out which row it is found in and then use that value (integer) as the row id to get the other values from that same row.

---

<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 13, 2024, 1:04am UTC](https://community.thunkable.com/t/best-way-to-pull-data-into-simple-list-viewer/2640837/4 "2024-01-13T01:04:03Z")

</div>

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