# Template or project which uses list to display contents of local DB?

**URL:** https://community.thunkable.com/t/template-or-project-which-uses-list-to-display-contents-of-local-db/74889
**Category:** Questions about Thunkable X
**Tags:** listview
**Created:** [April 19, 2019, 11:42am UTC](https://community.thunkable.com/t/template-or-project-which-uses-list-to-display-contents-of-local-db/74889 "2019-04-19T11:42:18Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![himicanuck](https://avatars.discourse-cdn.com/v4/letter/h/59ef9b/32.png) [@himicanuck](https://community.thunkable.com/u/himicanuck)
#### Post date: [April 19, 2019, 11:42am UTC](https://community.thunkable.com/t/template-or-project-which-uses-list-to-display-contents-of-local-db/74889/1 "2019-04-19T11:42:18Z")

</div>

Hi, I’m trying to figure out how to display contents of a local DB based on logic (if column A shows a value of X, show the values in columns Y, Z) and how to update the local DB. Can you please point me to a template or project which I can look at to see how to set that up?  
Thanks!

---

<div class="post-metadata">

### Author: ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [June 5, 2019, 12:46pm UTC](https://community.thunkable.com/t/template-or-project-which-uses-list-to-display-contents-of-local-db/74889/2 "2019-06-05T12:46:28Z")

</div>

Hi @himicanuck - this sounds similar to a VLOOKUP - we have an example of how to do this here:

> [@Performing a VLOOKUP in LocalDB](http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057):
>
> One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start…

Let us know if you have any follow-up questions!

---

<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:13pm UTC](https://community.thunkable.com/t/template-or-project-which-uses-list-to-display-contents-of-local-db/74889/3 "2024-11-08T12:13:33Z")

</div>


