# \[Solved\] Advise for Database

**URL:** <https://community.thunkable.com/t/solved-advise-for-database/530333>\
**Category:** Questions about Thunkable X\
**Tags:** solved\
**Created:** [March 23, 2020, 10:37am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333 "2020-03-23T10:37:09Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [March 23, 2020, 10:37am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/1 "2020-03-23T10:37:09Z")

</div>

Hello,  
I hope someone can help me because i can’t figure out what aproach i need to take to realize my idea.

I need to find a way to store data and i hope to do it locally with localdb or local storage

This should be the structure.

1. Main project name
2. Each project can contain up to x subprojects
3. Each subproject can contain up to x children (text values combined with numeric values)

Everything needs to be editable and deleteable for the user.

What I can’t figure out is how to store so many values connected to one project.

Thank you for your help.

---

<div class="post-metadata">

**Author:** ![darren](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darren/32/69854_2.png) [@darren](https://community.thunkable.com/u/darren)\
**Post date:** [March 24, 2020, 7:59pm UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/2 "2020-03-24T19:59:02Z")

</div>

Hey @Christian_Sigge,

Hopefully this gets you pointed in the right direction: [Thunkable](https://x.thunkable.com/copy/69f07e22fa4f8a20348ea8160f0a8bf7)

### Stored Variable Structure

 ![Screen Shot 2020-03-24 at 2.37.46 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/e/0eb9744c85e1ddd02a791090a643c1bbfdf84d39.png)

### Display Subproject Item Data

 ![Screen Shot 2020-03-24 at 2.38.26 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/b/dbd01cd8732fcc764bb29a5c091679d7d69bbaa6.png)  
 ![Screen Shot 2020-03-24 at 2.38.49 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e15d1f10a10c496da70812c55a8b7412734e43f.png)

### Delete Subproject

 ![Screen Shot 2020-03-24 at 2.39.01 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9dc916a7b453dd5e85e704b63cfed0aecec9d458.png)

### Update Subprojects in a Project

 ![Screen Shot 2020-03-24 at 2.39.10 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/2/825301d1b64f70c5f17d3f2d65491095cc510e9b.png)

The project is currently live and working here:

> **[thunkablecompanion](https://thunk.app/web-build/index.html?webAppId=J9H0CXW0z)**
>
> Powered by Thunkable

---

<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:** [March 24, 2020, 8:25pm UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/3 "2020-03-24T20:25:35Z")

</div>

Nice work @darren!

---

<div class="post-metadata">

**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\
**Post date:** [March 25, 2020, 2:17am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/4 "2020-03-25T02:17:28Z")

</div>

Amazing work, @darren! 🙌

This technique would be very useful in a dynamic to-do list app, which would also have Sub-list option! 👍

Thanks! 😊

---

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [March 25, 2020, 7:09am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/5 "2020-03-25T07:09:41Z")

</div>

Hello Darren,  
that looks fantastic, well structured and easy to follow,  
thank you so much for your help.

---

<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:** [March 25, 2020, 9:02am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/6 "2020-03-25T09:02:28Z")

</div>

@Christian_Sigge glad to see that helped - ok to mark Darren’s answer as the Solution to this question?

---

<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:** [March 29, 2020, 4:19am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/7 "2020-03-29T04:19:25Z")

</div>

@Christian_Sigge  
here is another example of something similar!  
I will post a tutorial after i complete the data mod portion. maybe another day or two? I’ve been working on this when i have the time!

this is the general data format ![Screen Shot 2020-03-28 at 8.22.12 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9d411fb6d1fe145386001e012ed50e6fc949528e.png) Thanks @darren for the idea on how to construct this.

I will put out a written tutorial for this early next week!

find it live and get the remix link [here](http://jaredgibb.xyz/index.php/2020/03/28/in-progress-a-guide-to-working-with-lists-with-objects-that-have-lists-of-objects-unfinished-demo-link-in-the-post/)

---

<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, 11:29am UTC](https://community.thunkable.com/t/solved-advise-for-database/530333/8 "2024-11-08T11:29:59Z")

</div>


