# Update all rows in the local db except some

**URL:** https://community.thunkable.com/t/update-all-rows-in-the-local-db-except-some/644519
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [June 29, 2020, 4:57pm UTC](https://community.thunkable.com/t/update-all-rows-in-the-local-db-except-some/644519 "2020-06-29T16:57:15Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![oreeldadln](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/oreeldadln/32/89185_2.png) [@oreeldadln](https://community.thunkable.com/u/oreeldadln)
#### Post date: [June 29, 2020, 4:57pm UTC](https://community.thunkable.com/t/update-all-rows-in-the-local-db-except-some/644519/1 "2020-06-29T16:57:15Z")

</div>

Hello,

I’m trying to create a graph with values from a column in the local DB.  
the column is built from a cumulative number.

Now I want to create a delete option to delete values from the list and graph, but in order to do that, I need to decrease the deleted number from all rows above the deleted row.

I’m trying to create some kind of a loop but couldn’t find a proper way to do it.  
do someone knows how to create this functionality?

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 29, 2020, 7:32pm UTC](https://community.thunkable.com/t/update-all-rows-in-the-local-db-except-some/644519/2 "2020-06-29T19:32:31Z")

</div>

Hey @oreeldadln

I’d highly recommend taking a look at @jared’s work on charts and graphs:

> [@\[Sovled\] Graphs? Charts? Is there a good way to make them with thunkable?](http://community.thunkable.com/t/sovled-graphs-charts-is-there-a-good-way-to-make-them-with-thunkable/470099):
>
> I know a lot of other Thunkers out there are likeminded to me. We like to not only take data and analyze data and stare at numbers, but we also want to see a chart. A graph. A visual representation of the data so that we may quickly make visual inferences and judge those data that we are viewing without having to crunch numbers or do too much thinking. We want to see trends visually without having to use our minds to infer that trend. I currently use [quickchart.io](http://quickchart.io) to complete all of my charting…

Let us know whether or not that helps!

---

<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:25am UTC](https://community.thunkable.com/t/update-all-rows-in-the-local-db-except-some/644519/3 "2024-11-08T11:25:22Z")

</div>


