# \[Solved\] Create charts from LocalDB?

**URL:** <https://community.thunkable.com/t/solved-create-charts-from-localdb/351243>\
**Category:** Questions about Thunkable X\
**Tags:** solved\
**Created:** [December 4, 2019, 6:57pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243 "2019-12-04T18:57:29Z")\
**Posts on this page:** 13\
**Page:** 1

<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:** [December 4, 2019, 6:57pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/1 "2019-12-04T18:57:30Z")

</div>

I developed this app to be used for my Masters Capstone Project in Professional Behavior Analysis. The app is designed to be used for caregivers to collect and submit data on three behaviors for their child and to send it to their therapy program supervisor.

Currently, a parent opens the app and decides on a few things. Who to send the info to daily. What behaviors to track. And how to record them (e.g. occurrence/non-occurrence, Likert scale, count each response).

All data is stored as “stored variable pb1,” for example, and the information is then submitted to my database on AirTables though there I port the data to google sheets and am creating graphs from each user’s data.

Is there a way to make these charts from within the app itself? If so, could someone help me with this. My project will be distributed free/close to free when it’s finished for use with low-income families. Anyone that can help or collab would certainly receive credit!

[https://x.thunkable.com/copy/8b43d100c4031a16d59d23c1447bef4e](https://x.thunkable.com/copy/8b43d100c4031a16d59d23c1447bef4e)

---

<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:** [December 4, 2019, 8:38pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/2 "2019-12-04T20:38:34Z")

</div>

Sounds like a useful app and good of you to offer it for free or at an affordable price.

I don’t believe there are any built-in ways to graph data in Thunkable but you could stack colored squares without border lines and create a bar graph, for example, from the value of a variable.

---

<div class="post-metadata">

**Author:** ![jacob1](https://avatars.discourse-cdn.com/v4/letter/j/a87d85/32.png) [@jacob1](https://community.thunkable.com/u/jacob1)\
**Post date:** [December 4, 2019, 9:16pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/3 "2019-12-04T21:16:16Z")

</div>

@actech may have a newer version but here is his demo project, you can create graphs using the google api shown in his chart screen [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [December 5, 2019, 8:32am UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/4 "2019-12-05T08:32:29Z")

</div>

In my example, data URI is used, and this does not work in applications installed on iOS.

Map Canvas allows you to create different charts. See [Map canvas](https://x.thunkable.com/projects/5db56eadb7c037443fadb222/project/properties/designer/) and [Polipaint](https://x.thunkable.com/projects/5db56632a1e1fcefd3932db7/project/properties/designer/)

Best regards, Alex  
[ACtech demo project](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/)  
[Thunkable X Basic Programming Course](http://droidscript.ru/main/title_ds15.php)  
[Block Reference](http://droidscript.ru/main/statyi/thunkableios_blockhelper.php)  
[Component Reference](http://droidscript.ru/main/statyi/thunkableios_objects.php)  
[Bug tracker](https://x.thunkable.com/projects/5dbd5243a77acad1b26f851f/project/properties/designer/)  
[Polipaint](https://x.thunkable.com/projects/5db56632a1e1fcefd3932db7/project/properties/designer/)  
[Map canvas](https://x.thunkable.com/projects/5db56eadb7c037443fadb222/project/properties/designer/)  
[Method Inspector](https://x.thunkable.com/projects/5d9310fcdf0a8f208bd2bb11/openProject/designer)  
[Performance](https://x.thunkable.com/projects/5db93ebab8e0fc9c685b3477/project/properties/designer/)

---

<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:** [December 5, 2019, 12:01pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/5 "2019-12-05T12:01:36Z")

</div>

> [@actech](#):
>
> In my example, data URI is used, and this does not work in applications installed on iOS.

Thank you! This makes sense why it’s not working. I use iOS. Thank you for clarifying that.

Has anyone had success creating charts within a thunkable app rubbing on iOS from a data set held within the app or in Airtable?

---

<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:** [December 7, 2019, 2:22pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/6 "2019-12-07T14:22:41Z")

</div>

@actech when i open your app, i dont see any charts. you say it doesnt work on iOS so i tried to open on android and the app says that android is not supported at this time.

am i doing something wrong?

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [December 7, 2019, 3:02pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/7 "2019-12-07T15:02:31Z")

</div>

There are sample diagrams on the scrChart screen. Are they displayed on your device?

 ![изображение](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/2/92f8203c0a2fe0553daff9a4deabced95b0ccaca.png)

---

<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:** [December 7, 2019, 3:15pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/8 "2019-12-07T15:15:50Z")

</div>

I had the 2018 version. i have the updated version now. thank you, i was clicking the wrong link before.

When i open it on iOS, it doesn’t work. Do you know if this will work ever on iOS?

Thank you for taking time to respond to this @actech

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [December 7, 2019, 4:11pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/9 "2019-12-07T16:11:19Z")

</div>

I do not think this will work.

---

<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:** [December 7, 2019, 4:29pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/10 "2019-12-07T16:29:41Z")

</div>

@domhnallohanlon @jane

Do either of you know if this feature will work on iOS anytime? Should I throw this onto the requests/bugs page?

---

<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:** [December 13, 2019, 6:43pm UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/11 "2019-12-13T18:43:05Z")

</div>

Hello @actech @domhnallohanlon and @jane along with the rest of the community!

This has been solved by using [quickchart.io](http://quickchart.io)!

check out this sample app to demonstrate graphing from the localDB. this does require an internet connection!

[https://x.thunkable.com/copy/fa5f858f2e709bd598c257e4460f5168](https://x.thunkable.com/copy/fa5f858f2e709bd598c257e4460f5168)

---

<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:** [November 6, 2020, 12:20am UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/12 "2020-11-06T00:20:01Z")

</div>

Here is an update almost a year later.

[https://x.thunkable.com/copy/86b456a916720bccfad8fa6c0a8e64b3](https://x.thunkable.com/copy/86b456a916720bccfad8fa6c0a8e64b3)

this allows for both online and offline graphing! checker out! hit me up for 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, 11:46am UTC](https://community.thunkable.com/t/solved-create-charts-from-localdb/351243/13 "2024-11-08T11:46:23Z")

</div>


