# addRow in LocalDB not working

**URL:** https://community.thunkable.com/t/addrow-in-localdb-not-working/248028
**Category:** Questions about Thunkable X
**Tags:** database
**Created:** [September 28, 2019, 12:58am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028 "2019-09-28T00:58:19Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![brucemortland7e6c](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@brucemortland7e6c](https://community.thunkable.com/u/brucemortland7e6c)
#### Post date: [September 28, 2019, 12:58am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/1 "2019-09-28T00:58:19Z")

</div>

It doesn’t get much simpler than this, but I can’t seem to get the addRow function to work with my LocalDB. Here’s a link to the code. The ADD button doesn’t add the new data.

[https://x.thunkable.com/projects/5d8e9ed196390d45707f0795/96d2342b-241c-4a4b-8889-58ac90ef64c9/blocks](https://x.thunkable.com/projects/5d8e9ed196390d45707f0795/96d2342b-241c-4a4b-8889-58ac90ef64c9/blocks)

What am I doing wrong? Thanks!

---

<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: [September 28, 2019, 2:43am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/2 "2019-09-28T02:43:39Z")

</div>

Hi, @brucemortland7e6c! 👋

* * *

> [@brucemortland7e6c](#):
>
> What am I doing wrong? Thanks!

What you were doing wrong is,

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/f/ef5729847fa352c760b8684415db1d679834e012.png)

But, it’s not your fault - 😐

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bf1c94f5b1bbf54eb6abda2ddc75912fe24d99eb.png)

* * *

**So, try this -** 😄

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/e/ee941384472ea246b9bacbcc6633ba4fd56bb971.png)

* * *

➡ Conclusion -

- The **`addRow`** is working, **`getColumn`** is not (in your case)
- **`getColumn`** needs **`text`** value, not _ **`number`** _ 😅

* * *

Hope I helped you! 😄  
**Thanks! 😊**

---

<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: [September 28, 2019, 8:13am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/3 "2019-09-28T08:13:37Z")

</div>

Hi,

> **`getColumn`** needs **`text`** value, not _ **`number`** _

I’m on 12.4.1 iOS and Android 8.1 GetColumn with number works well

![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/6/26db38faf4dccb34264111faa6ceb8653fcaf024.png)

---

<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: [September 28, 2019, 8:14am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/4 "2019-09-28T08:14:48Z")

</div>

I work with column names always, didn’t test this ever 😅

Nice!  
Thanks, @actech! 😊

---

<div class="post-metadata">

### Author: ![brucemortland7e6c](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@brucemortland7e6c](https://community.thunkable.com/u/brucemortland7e6c)
#### Post date: [September 28, 2019, 2:33pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/5 "2019-09-28T14:33:33Z")

</div>

Hmmm, didn’t work for me. I am running IOS 12.4.1

Here’s what happened:

Screen1 Open block Name  
AddButton Click bock 1 --------\> data displayed

Screen1 Open block 1  
AddButton Click bock 1 --------\> data displayed

Screen1 Open block Name  
AddButton Click bock Name --------\> data NOT displayed

In none of the above scenarios does a row get added with “bob” OR it is getting added, and listviewer is not being updated.

So, if you load my app on your device, does it work? With numbers or column titles or both?

I only found one example of someone using addRow in a tutorial and I’m going to try to replicate it right now. I have a feeling this is an IOS problem, but that’s my gut talking. No real evidence (or Android)

Thanks for all the help!

---

<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: [September 28, 2019, 3:49pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/6 "2019-09-28T15:49:55Z")

</div>

Hi,

You can not add a row because on iOS 12.4.1 row adding block simply does not work. Congratulations to the discovery of a bug!

---

<div class="post-metadata">

### Author: ![brucemortland7e6c](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@brucemortland7e6c](https://community.thunkable.com/u/brucemortland7e6c)
#### Post date: [September 28, 2019, 4:19pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/7 "2019-09-28T16:19:57Z")

</div>

Whew!

OK, I suppose there is a bit of a relief that is is NOT ME!!

Thanks for the help!

---

<div class="post-metadata">

### Author: ![maptheunknown](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@maptheunknown](https://community.thunkable.com/u/maptheunknown)
#### Post date: [October 20, 2019, 1:30pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/8 "2019-10-20T13:30:58Z")

</div>

Do you guys know if this AddRow in iOS 12.4.1 bug has been resolved? If not yet, is it going to be resolved?

Thanks,  
Marco

---

<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: [October 20, 2019, 4:21pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/9 "2019-10-20T16:21:49Z")

</div>

iOS 12.4.2 - AddRow not work.

---

<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: [October 21, 2019, 12:19am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/10 "2019-10-21T00:19:33Z")

</div>

@maptheunknown @actech is this while live testing/installing or both?

---

<div class="post-metadata">

### Author: ![maptheunknown](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@maptheunknown](https://community.thunkable.com/u/maptheunknown)
#### Post date: [October 21, 2019, 12:57am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/11 "2019-10-21T00:57:44Z")

</div>

I was only testing live. I will try again today on both live and downloaded app and let you know the results and blocks I used to test

---

<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: [October 21, 2019, 12:58am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/12 "2019-10-21T00:58:53Z")

</div>

Thanks, keep us posted!

---

<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: [October 21, 2019, 8:03am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/13 "2019-10-21T08:03:53Z")

</div>

iOS 12.4.2 - AddRow not work only on Live testing. On installing work good.

---

<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: [October 21, 2019, 4:57pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/14 "2019-10-21T16:57:48Z")

</div>

Thanks @maptheunknown and @actech.

I just took a closer look and was able to reproduce this error on my own device.

It seems that @brucemortland7e6c already reported this through our public Github and it’s currently on the to-do list.

I’ll be sure to update this topic as and when I learn more.

---

<div class="post-metadata">

### Author: ![maptheunknown](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@maptheunknown](https://community.thunkable.com/u/maptheunknown)
#### Post date: [October 22, 2019, 12:01am UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/15 "2019-10-22T00:01:37Z")

</div>

Thanks! Please keep us posted. Goodluck!

---

<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:08pm UTC](https://community.thunkable.com/t/addrow-in-localdb-not-working/248028/16 "2024-11-08T12:08:36Z")

</div>


