# Limited listings

**URL:** https://community.glideapps.com/t/limited-listings/1249
**Category:** Feature Requests
**Created:** [October 17, 2019, 9:49pm UTC](https://community.glideapps.com/t/limited-listings/1249 "2019-10-17T21:49:40Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![designerbrett](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/designerbrett/32/1013_2.png) [@designerbrett](https://community.glideapps.com/u/designerbrett)
#### Post date: [October 17, 2019, 9:49pm UTC](https://community.glideapps.com/t/limited-listings/1249/1 "2019-10-17T21:49:40Z")

</div>

Is there any way to show only a certain number of items in a list. If you were making a storefront like Amazon but you don’t want to show all the books or all the tech products all at once. So display 6 of the latest books with an optional button to view all books? Then have another display for the latest 6 hard drives. Etc.

Maybe there’s a way to create that in sheets by referencing rows from the “products” tab? Just select the top 6 rows or something?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 17, 2019, 10:04pm UTC](https://community.glideapps.com/t/limited-listings/1249/2 "2019-10-17T22:04:27Z")

</div>

The referencing option in the sheet is all I can think of right now.

---

<div class="post-metadata">

### Author: ![muazz1m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muazz1m/32/189_2.png) [@muazz1m](https://community.glideapps.com/u/muazz1m)
#### Post date: [October 18, 2019, 12:51am UTC](https://community.glideapps.com/t/limited-listings/1249/3 "2019-10-18T00:51:41Z")

</div>

You can try this method =QUERY(MASTER!A:G,“order by A desc limit 6”) to query only 6 latest item from ‘MASTER’ sheet

---

<div class="post-metadata">

### Author: ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [November 28, 2019, 10:33am UTC](https://community.glideapps.com/t/limited-listings/1249/4 "2019-11-28T10:33:23Z")

</div>

Did you get this to work? Thanks
