# Exclude first items in list

**URL:** <https://forum.adalo.com/t/exclude-first-items-in-list/17945>\
**Category:** Get Help\
**Created:** [October 2, 2021, 11:03am UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945 "2021-10-02T11:03:50Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 2, 2021, 11:03am UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/1 "2021-10-02T11:03:50Z")

</div>

Hello dear Adalo people! I have a quick question:

Let’s say I have a list of 100 items, sorted based on how often users have liked the item. I know how to show only the top 10, by setting the maximum number of items to 10, but now on another screen I want to show items #11 to #20. How would I do this?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [October 2, 2021, 12:06pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/2 "2021-10-02T12:06:02Z")

</div>

Hi @mgwg ,

You need to have running number which then can be filtered using range like you mention.

Use logged in user as app variables to be start and end range, cause it is easier to manipulate using update action rather than change input value.

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 2, 2021, 12:27pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/3 "2021-10-02T12:27:20Z")

</div>

What do you mean exactly with “Use logged in user as app variables to be start and end range”?

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [October 2, 2021, 12:29pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/4 "2021-10-02T12:29:21Z")

</div>

Hi @mgwg 👋 👋

Tell me If I understand your problem correctly. Are you mean like this?

Thank you 😊 😊

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 2, 2021, 1:00pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/5 "2021-10-02T13:00:27Z")

</div>

Yes, that seems to be it! Can you share how you made it?

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [October 2, 2021, 1:01pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/6 "2021-10-02T13:01:03Z")

</div>

Ok I will send a video. Give me 5 mins.

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [October 2, 2021, 1:10pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/7 "2021-10-02T13:10:34Z")

</div>

Here it is @mgwg 😊 I did this with the simple list and you can do this with any list.

Thank you 😇

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [October 2, 2021, 1:46pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/8 "2021-10-02T13:46:33Z")

</div>

Add property in the users collection, so you can access them through logged in user\>property name, this kind of method works everywhere in the app.

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 2, 2021, 1:47pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/9 "2021-10-02T13:47:15Z")

</div>

Thank you very much, but my problem is slightly different. My items are sorted on a count of how many times they have been liked by users, which can change over time and can be any number. So I cannot just filter the list based on that count being between x and y.

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 3, 2021, 3:15pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/10 "2021-10-03T15:15:49Z")

</div>

Can you maybe explain this in a bit more detail?

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [October 3, 2021, 9:31pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/11 "2021-10-03T21:31:07Z")

</div>

Can you give spreadsheet example ?

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 4, 2021, 8:23am UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/12 "2021-10-04T08:23:02Z")

</div>

This would be an example. Note that the number of likes can change over time, so I won’t be able to set threshold values manually in the filter-settings

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3fd4bd900c09d2768b70a370e3149ba7b7cd1289.png)

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [October 4, 2021, 9:06am UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/13 "2021-10-04T09:06:05Z")

</div>

In Adalo, we don’t have list index, so we need to create it on our own.

In the database add another property for ranking.

To update the ranking, add another collection called sequence master collection.

You can read an example here,

> [@Recurring Assignments](https://forum.adalo.com/t/recurring-assignments/9817/2):
>
> Hi @eggeriley , I have looked at coaching app but it is better to create from scratch so we have more control of the database design. Here is my try, check it out. I have not implemented safety feature yet, so duplicate records are easily created. But you can see my other cloneable apps to see how it is done. For repetition, I have to use dummy sequence collection, but if Adalo has another way, I would like to know as well. Cheers, Yongki

Do batch processing using custom list and countdown to loop through this while using sort descending for number of likes.

This process need some time to finish, so it might be better to do it at the end of the day.

---

<div class="post-metadata">

**Author:** ![mgwg](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mgwg](https://forum.adalo.com/u/mgwg)\
**Post date:** [October 4, 2021, 11:05am UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/14 "2021-10-04T11:05:55Z")

</div>

Thank you Yongki! Unfortunately this solution will not be sufficient for my problem, given that the ranking will change continuously throughout the day and I need to show the properly sorted items at any moment. So I would need an automatic solution. Any other ideas?

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [October 4, 2021, 8:41pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/15 "2021-10-04T20:41:11Z")

</div>

Then you will need to process it everytime there is a change in the number of likes.

This will takes some moments to process it.

Try creating on your own first then when you are creating it, you will get some more ideas.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [October 14, 2021, 8:41pm UTC](https://forum.adalo.com/t/exclude-first-items-in-list/17945/16 "2021-10-14T20:41:41Z")

</div>

Closed on October 14, 2021, 8:41pm UTC

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