# Show Expired Subscription **URL:** \ **Category:** Ask for Help\ **Created:** [September 3, 2023, 11:55am UTC](https://community.glideapps.com/t/show-expired-subscription/65736 "2023-09-03T11:55:00Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![BodyBuilding](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bodybuilding/32/62534_2.png) [@BodyBuilding](https://community.glideapps.com/u/BodyBuilding)\ **Post date:** [September 3, 2023, 11:55am UTC](https://community.glideapps.com/t/show-expired-subscription/65736/1 "2023-09-03T11:55:00Z")
Hey, I have a person’s name field with a registration date for a month. How can I know the people whose subscription period has expired and it appears in a field alone… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 12:16pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/2 "2023-09-03T12:16:05Z")
Create an if-then-else column: - If Expiration Date is before Now, then Expired ---
**Author:** ![BodyBuilding](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bodybuilding/32/62534_2.png) [@BodyBuilding](https://community.glideapps.com/u/BodyBuilding)\ **Post date:** [September 3, 2023, 12:33pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/3 "2023-09-03T12:33:27Z")
Thanks for the answer, but this appears in a column and I want them all in one row ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 12:43pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/4 "2023-09-03T12:43:44Z")
What, the results for all users in a single row? That seems odd - can you show me a screen shot of how this looks in the Data Editor please? How are you intending to use the result? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 12:55pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/5 "2023-09-03T12:55:14Z")
Okay, I just re-read your question and I think I understand now. Do it in two steps: - Start with a similar if-then-else column: – If Expiration Date is before Now, then Name - Then add a Joined List column that targets the if-then-else column. This will give you a comma separated list of names of all of those with expired subscriptions. ---
**Author:** ![BodyBuilding](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bodybuilding/32/62534_2.png) [@BodyBuilding](https://community.glideapps.com/u/BodyBuilding)\ **Post date:** [September 3, 2023, 12:55pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/6 "2023-09-03T12:55:17Z")
I am working on an application that consists of the customer’s name with the date of subscription and the end of the subscription. All of this worked well. I want to make a button whose name is expired. When clicking on it, every expired person appears. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 1:05pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/7 "2023-09-03T13:05:32Z")
> [@BodyBuilding](#): > > I want to make a button whose name is expired. When clicking on it, every expired person appears. We’re going around in circles a little bit here, because I’m still not clear on how you want this to look? Would you want: - a) One big blob of names that you would show in some sort of text component on the screen? – If yes, use the below: > [@Darren\_Murphy](#): > > - Start with a similar if-then-else column: > – If Expiration Date is before Now, then Name > - Then add a Joined List column that targets the if-then-else column. This will give you a comma separated list of names of all of those with expired subscriptions. - b) A list of users that you could use in a Collection, which would allow you to drill down to the details screen for each user? – If yes, then use my first answer: > [@Darren\_Murphy](#): > > Create an if-then-else column: > > - If Expiration Date is before Now, then Expired – And then add a collection, set your Users Table as the source, and use the if-then-else column as a filter. If neither of the above gets you what you want, then you’ll need to help me understand better. ---
**Author:** ![BodyBuilding](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bodybuilding/32/62534_2.png) [@BodyBuilding](https://community.glideapps.com/u/BodyBuilding)\ **Post date:** [September 3, 2023, 4:26pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/8 "2023-09-03T16:26:30Z")
Thanks again but can you enhance this with pictures please because I am a beginner ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 4:28pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/9 "2023-09-03T16:28:51Z")
Which option - a) or b) ? ---
**Author:** ![BodyBuilding](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bodybuilding/32/62534_2.png) [@BodyBuilding](https://community.glideapps.com/u/BodyBuilding)\ **Post date:** [September 3, 2023, 4:52pm UTC](https://community.glideapps.com/t/show-expired-subscription/65736/10 "2023-09-03T16:52:43Z")
a please