# Why do I have hundreds of empty records in my Posts table?

**URL:** <https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710>\
**Category:** Ask for Help\
**Created:** [October 28, 2021, 11:15pm UTC](https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710 "2021-10-28T23:15:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\
**Post date:** [October 28, 2021, 11:15pm UTC](https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710/1 "2021-10-28T23:15:06Z")

</div>

See screenshots below. Appears to be many hundreds of empty posts. Could it be because I added an ARRAYFORMULA to my underlying Google Sheet to get the date format I wanted?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6adf87be1fa198b6d4245a05c65be62f75f5b5e.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c904aac4307c31ac9e8f4d597c1f13050c5ec892.png)

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [October 28, 2021, 11:25pm UTC](https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710/2 "2021-10-28T23:25:28Z")

</div>

Yes, your ARRAYFORMULA is putting empty text in all extra rows.

You can learn how to avoid this here: [https://docs.glideapps.com/all/reference/using-sheets/functions/arrayformula](https://docs.glideapps.com/all/reference/using-sheets/functions/arrayformula)

---

<div class="post-metadata">

**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\
**Post date:** [October 28, 2021, 11:38pm UTC](https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710/3 "2021-10-28T23:38:07Z")

</div>

Fix worked great. And I was able to delete the auto-generated records from the Google Sheet. Thx!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 29, 2021, 11:38pm UTC](https://community.glideapps.com/t/why-do-i-have-hundreds-of-empty-records-in-my-posts-table/33710/4 "2021-10-29T23:38:10Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.