# Displaying 2 different collection with the same column **URL:** https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241 **Category:** Ask for Help **Created:** [September 9, 2024, 10:45am UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241 "2024-09-09T10:45:14Z") **Posts on this page:** 11 **Page:** 1
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 10:45am UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/1 "2024-09-09T10:45:14Z")
Hi, I have a list of 100 musicians with a random number which determines a position in the list like 448, 65, 945, 561, 446, 217, etc… I need to display the first 60 person who are those they can perform live (easy) BUT I also need to display the others 40 who are in the waiting list (argh) When one of the first 60 is out, it deletes his number, the first in the waiting list takes his place and appears in the performers list automatically. How can I do all of this ? 🙏 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a9bc128a69331b480b3af5e0c0342d5a1c6b626.png) ---
### 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: [September 9, 2024, 12:15pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/2 "2024-09-09T12:15:02Z")
I think you could filter your collection to only show rows where the number is not empty, and then set up the collection to be limited to showing only 6o rows. Every time a number is removed, the next available person should show up in the list. ---
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 12:26pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/3 "2024-09-09T12:26:11Z")
Yes but I want to show in another collection the 40 others ---
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 12:33pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/4 "2024-09-09T12:33:06Z")
Is there a way to have in another column the number of the place ? Like this : 30 → 1 47 → 2 68 → 3 95 → 4 136 → 5 219 → 6 It will be easier to filter the 2 collections : 1 to 60 61 to 100 ---
### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin) #### Post date: [September 9, 2024, 1:41pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/5 "2024-09-09T13:41:11Z")
Try doing it with query column. ---
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 1:47pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/6 "2024-09-09T13:47:01Z")
I’ve already done it. I can filter from the first item to the 60th by displaying but I cannot filter from 61 to 100. ---
### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin) #### Post date: [September 9, 2024, 1:49pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/7 "2024-09-09T13:49:54Z")
Is your total number of shows always 100 or does it fluctuate? ---
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 2:00pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/8 "2024-09-09T14:00:50Z")
It can fluctuate if a user decide to unsubscribe. ---
### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin) #### Post date: [September 9, 2024, 2:02pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/9 "2024-09-09T14:02:07Z")
If you want to number them, you will need 3 additional columns as follows: ![Screenshot 2024-09-09 at 21.00.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84aa20437e497dbc950b4c2bee27474953eedeca.jpeg) ---
### Author: ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib) #### Post date: [September 9, 2024, 2:21pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/10 "2024-09-09T14:21:18Z")
Ho yes, it helps a lot 🥳 Thank you 🙏 ---
### 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: [September 16, 2024, 2:21pm UTC](https://community.glideapps.com/t/displaying-2-different-collection-with-the-same-column/76241/11 "2024-09-16T14:21:55Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.