# Not all items created via pp are listed in the sheet

**URL:** <https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231>\
**Category:** Ask for Help\
**Created:** [October 17, 2019, 9:07am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231 "2019-10-17T09:07:22Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [October 17, 2019, 9:07am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/1 "2019-10-17T09:07:22Z")

</div>

I have created 4 Event items via the form through the use of a Form, all 4 are visible on the app, but I can only see two in the corresponding g-sheet, this is very strange, have refreshed the app and the sheet and still can see the two remaining items.

any ideas? anyone else having a similar issue? could this be a much wider isse?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/d55cccf8e91922bae98bc43d6493630b77976361.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bebe6ccb46a1a680febb5f1a5a081da282a615f0.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/fd16891fc4b6e78fb7a0d25b3ba5fb11abbf2ffa.png)

---

<div class="post-metadata">

**Author:** ![Andreas\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_p/32/478_2.png) [@Andreas\_P](https://community.glideapps.com/u/Andreas_P)\
**Post date:** [October 17, 2019, 9:08am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/2 "2019-10-17T09:08:51Z")

</div>

> [@Rogelio](#):
>
> I have created 4 Event items via the form through the use of a Form, all 4 are visible on the app, but I can only see two in the corresponding g-sheet, this is very strange, have refreshed the app and the sheet and still can see the two remaining items.

Sometimes rows are added in the bottom of the sheet I have noticed, have a look down there

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [October 17, 2019, 9:10am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/3 "2019-10-17T09:10:22Z")

</div>

AAH! Yes they have been created right at the bottom - have never seen this before - why is that the case? how can i fix it?

---

<div class="post-metadata">

**Author:** ![Andreas\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_p/32/478_2.png) [@Andreas\_P](https://community.glideapps.com/u/Andreas_P)\
**Post date:** [October 17, 2019, 9:12am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/4 "2019-10-17T09:12:20Z")

</div>

😉 Don’t know why I am afraid, I was quite puzzled as well when it happened to me… It must be a bug I guess…

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [October 17, 2019, 9:13am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/5 "2019-10-17T09:13:18Z")

</div>

hmm - what’s the fix? or did you just leave it?

---

<div class="post-metadata">

**Author:** ![Andreas\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_p/32/478_2.png) [@Andreas\_P](https://community.glideapps.com/u/Andreas_P)\
**Post date:** [October 17, 2019, 9:16am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/6 "2019-10-17T09:16:22Z")

</div>

I deleted all empty rows between the ones at the top and the ones in the bottom and just carried on from there. The issue has not come back after that but I guess it could happen again…

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 17, 2019, 11:28am UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/7 "2019-10-17T11:28:39Z")

</div>

This is because you most likely are using an arrayformula in one of the columns. Even though there is no data in those empty rows, the formula goes to the very bottom of the sheet. So when Glide “looks” it sees data at the last row and appends a row for the new record.

---

<div class="post-metadata">

**Author:** ![Rogelio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rogelio/32/1054_2.png) [@Rogelio](https://community.glideapps.com/u/Rogelio)\
**Post date:** [October 17, 2019, 9:02pm UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/8 "2019-10-17T21:02:46Z")

</div>

I do have an ArrayFormula but on another sheet that is simply replicating the values.

Would this cause an issue further down the track? How can I fix it?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 17, 2019, 9:48pm UTC](https://community.glideapps.com/t/not-all-items-created-via-pp-are-listed-in-the-sheet/1231/9 "2019-10-17T21:48:33Z")

</div>

Your best bet is to delete all the empty rows as @Andreas_P suggested. That is what I do with all my sheet whether I have arrayformulas or not. Again Glide handles the add rows just fine this way and you are sure to have continuous data.

Just be sure you do this on any sheet that you plan on adding rows to if it does use Arrayformulas.
