# Create Row in google sheets executes, but just gets stuck here

**URL:** https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074
**Category:** Issues / Bugs
**Created:** [June 17, 2022, 9:24pm UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074 "2022-06-17T21:24:33Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![adorriableonerm](https://avatars.discourse-cdn.com/v4/letter/a/51bf81/32.png) [@adorriableonerm](https://community.thunkable.com/u/adorriableonerm)
#### Post date: [June 17, 2022, 9:24pm UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/1 "2022-06-17T21:24:33Z")

</div>

I looked at all the Create row not working and this is similar to the one that was posted a while that had the create row working and then the next command isn’t executed.  
It was working before, but all of a sudden, it stopped working. I did not have it in a loop, it was just a straight command.  
I took out the actions in the “do” part and still gets stuck at that create row command (it actually creates the row, just doesn’t move past it).  
I took the create row out and everything worked fine (except it didn’t create the row because i took it out obviously).  
i took the create row out and put it on a different screen and had it execute it when that screen opens, it creates the row and still gets stock and doesn’t move on.

This all of a sudden happened.  
As a standalone command, it doesn’t move to the next command (“go to” screen)  
I tessted on live, preview and it failed in the app (started failing yesterday).

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

---

<div class="post-metadata">

### Author: ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [June 18, 2022, 4:30am UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/2 "2022-06-18T04:30:49Z")

</div>

have you tried the create\_row with a valid value for ‘Resident Received Value’ - ie. connect a box to it.

---

<div class="post-metadata">

### Author: ![adorriableonerm](https://avatars.discourse-cdn.com/v4/letter/a/51bf81/32.png) [@adorriableonerm](https://community.thunkable.com/u/adorriableonerm)
#### Post date: [June 18, 2022, 5:32am UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/3 "2022-06-18T05:32:21Z")

</div>

Yep, i did. I tried basically everything. the only time my code works if i just remove the create row command all together.  
Is there a certain limit on the number of rows? i I have over 680 rows in my google Sheet.

---

<div class="post-metadata">

### Author: ![adorriableonerm](https://avatars.discourse-cdn.com/v4/letter/a/51bf81/32.png) [@adorriableonerm](https://community.thunkable.com/u/adorriableonerm)
#### Post date: [June 18, 2022, 5:51am UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/4 "2022-06-18T05:51:14Z")

</div>

Okay, here is a clue (and i don’t think it will be helpful). I changed to a different tab and it worked. I even put data on the first 700 lines and it still worked on the “analysis” tab. Then i went to put the original tab and it didn’t work. Something is messed up.  
On the picture, you can see the two create rows i interchanged. the analysis one worked, the other didn’t

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

---

<div class="post-metadata">

### Author: ![adorriableonerm](https://avatars.discourse-cdn.com/v4/letter/a/51bf81/32.png) [@adorriableonerm](https://community.thunkable.com/u/adorriableonerm)
#### Post date: [June 18, 2022, 5:59am UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/5 "2022-06-18T05:59:20Z")

</div>

Okay, i fix the issue, but you guys are not going to like it. I basically cut a bunch of rows at the end of the sheet(tab) that was giving me problems. Tried the app, it worked.  
I then pasted back all the rows to the sheet and then ran the app, it still worked.  
So, this is a BIG BUG in the create a row function and how it works with google sheets after a certain amount of rows it adds, something is going to go bad. don’t know how to replicate this guys till it happens again.

---

<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, 1:13pm UTC](https://community.thunkable.com/t/create-row-in-google-sheets-executes-but-just-gets-stuck-here/1930074/6 "2024-11-08T13:13:06Z")

</div>


