# Strategy For Large Datasets - Input Appreciated!

**URL:** <https://community.glideapps.com/t/strategy-for-large-datasets-input-appreciated/12710>\
**Category:** Ask for Help\
**Created:** [July 18, 2020, 9:33am UTC](https://community.glideapps.com/t/strategy-for-large-datasets-input-appreciated/12710 "2020-07-18T09:33:26Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 18, 2020, 9:50am UTC](https://community.glideapps.com/t/strategy-for-large-datasets-input-appreciated/12710/2 "2020-07-18T09:50:54Z")

</div>

> [@V88](#):
>
> A separate Admin app provides access to all feedback items.

You can have an array column of emails to not have another app, let’s say “email 1” stores the user’s email, “email 2” is automatically populated by the admin email when “email 1” is not empty. Then set the row owner on that array column in the Editor.

> [@V88](#):
>
> 25 feedback items and use something like Integromat to “clean up things” on a daily basis by extracting the oldest feedback items and moving them to another “data store” somewhere

I actually did this same thing a while ago for a post on here, you can see the idea here. Duplicate the sheet and show only last 25 feedback items by each user in the app. I don’t think you need to delete it, 25000 rows is not much for a Sheet, the maximum cells they can hold is 5 million, it’s more of a bottleneck in the connection between Glide and Sheets, but as long as you keep it to only last 25 I don’t think there would be a problem.

> [@How would I duplicate a sheet to only show an updated list of the 'last 10 items logged by each user'](https://community.glideapps.com/t/how-would-i-duplicate-a-sheet-to-only-show-an-updated-list-of-the-last-10-items-logged-by-each-user/12234):
>
> I am working on an app for a sport club and want to show the last 10 workouts logged by each user. Is there some simple formula to duplicate a sheet filled with dozens of items for several users but only the most recent 10 items per user? Thanks!

---

_[View the full topic](https://community.glideapps.com/t/strategy-for-large-datasets-input-appreciated/12710)._
