# Relating a Category to a List of Episodes to a List of Videos with Details **URL:** \ **Category:** Ask for Help\ **Created:** [May 30, 2020, 12:52am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011 "2020-05-30T00:52:28Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 12:52am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/1 "2020-05-30T00:52:28Z")
Hi folks, Hope everyone is having a good Friday and staying safe and healthy with everything going on! I’ve been going through as many threads as I can find on here to understand how to get this to work, but haven’t been able to find a resolution. I’m trying to set up a tab within the app that follows the structure below: Category → Episodes → Videos → Details for each video (screenshots attached, 3 columns for first are highlighted and then there’s “Details” in the 2nd screenshot) I have all of this information within one tab already, but I can’t seem to get a relation that brings back the correct inline list(s). It’s making me question if that’s even the correct method to employ since I already have all of the data that I want in this tab within a single sheet. Does anyone have suggestions on how to tackle this? Would appreciate any insight as this may just be a simple fix, but I’m not finding it. Thanks in advance! ![Screen Shot 2020-05-29 at 7.48.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8a9eb842e704128e8093f6729e95829176e62329.png) ![Screen Shot 2020-05-29 at 7.49.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6524b458bcdd6b5de9a18f1d11c079ff135204d7.png) ---
**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:** [May 30, 2020, 1:07am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/2 "2020-05-30T01:07:07Z")
Can you copy out that sheet only and give me a link here? I will take time to try it. ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 2:00am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/3 "2020-05-30T02:00:02Z")
Hi ThinhDinh! Thanks for offering to help out again. I put together a copy with the 4 columns (columns M to P) and the rest of the columns are details related to that video link in column P. Let me know if any of that is confusing. Again, the flow I would envision is: Category --\> Episode --\> Video Title --\> Video Link I included the “Episode” column because I think it’s necessary to make a relation to the category and then the proceeding link to the video, but I’d prefer to have the “Video Title” displayed since it describes what that episode is about. Let me know if any of this doesn’t make sense and I can clarify. Thanks again for taking a look! EDIT: there’s also details within each of the rows that describes the video link…I would be putting these in the screen that would be clicked on when the “Video Title” is clicked…the “Video Link” is simply a component within that next screen once the “Video Title” is click / tapped. > **[Copy of Episodes Detail](https://docs.google.com/spreadsheets/d/1BXXVVFr4BjlGhO5LznGrQOiOZ-hhpfAAs64K8FJ8CI0/edit?usp=sharing)** > > Copy of Episodes Detail > > Person,Company,Industry,Business Model,Date,Topic,Summary,Short Description,Lead Investor,Funding Stage,Money Raised,Pre-Money Valuation,Category,Episode,Video Title,Video Link,Start,Stop,Duration,Tag 1 > Anne... ---
**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:** [May 30, 2020, 2:43am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/4 "2020-05-30T02:43:00Z")
I have made an example of how it would look. Is this what you want? ![ezgif-3-d0caae05b0dc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ed7aeb102ff343b9bc71457806b466aa1875fe11.gif) ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 2:47am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/5 "2020-05-30T02:47:39Z")
Yep! Looks like you got the relation / inline list to work and from there it’s easy to add all the details as components. Are you able to get the clips within the specific episodes as well? Tough for me to tell from the video ---
**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:** [May 30, 2020, 2:56am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/6 "2020-05-30T02:56:51Z")
Sorry I’m on a call now, can you try previewing it themselves on my test app. Thank you. > **[Thinh Dinh's lab](https://tdslab.glideapp.io/)** > > Thinh Dinh's place to test out new concepts ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 3:02am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/7 "2020-05-30T03:02:07Z")
Of course! Just tested it and if you click on “This Week in Startups” and episodes 1018 and 1017, for example, the three 1018 clips should be part of that one 1018 tile. The two 1017 clips would be a part of one 1017 tile. After clicking on “E1018 #AskJason”, for example, we would want the 3 videos to show up in a list and then when one of those videos are clicked on, the components would be added to detail each of the videos. Same thing for the two videos relating to E1017 and so on. In other words, I think it needs an additional relation for each episode’s videos so people can navigate one step further. Does that make sense? ---
**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:** [May 30, 2020, 3:51am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/8 "2020-05-30T03:51:00Z")
Take a look at Multi-Level Select in [https://concepts.glideapp.io/](https://concepts.glideapp.io/). The key is to build templates for your relations if you need to go multiple levels deep. ---
**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:** [May 30, 2020, 4:27am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/9 "2020-05-30T04:27:37Z")
Can you check again? I have just added the episodes. ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 4:34am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/10 "2020-05-30T04:34:29Z")
Yep that’s it! Do you have a recommendation on how to approach it with relations that I wasn’t getting earlier? ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 4:35am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/11 "2020-05-30T04:35:44Z")
Hi @Jeff_Hager - didn’t realize there was a step for this one on the concepts glideapp. Will definitely have to check that one out and apply it to my glideapp. Thanks! ---
**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:** [May 30, 2020, 5:21am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/12 "2020-05-30T05:21:56Z")
Yeah try out Jeff’s concept, my solution is based on it as well. Sorry I’m not on the computer anymore, when I come back I will share the details of my solution and how to automatically get image thumbnails if you need them. ---
**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:** [May 30, 2020, 7:49am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/13 "2020-05-30T07:49:37Z")
Check out how I make three sheets here: Level 1: Category Level 2: Episodes Level 3: Videos In Level 1, I make a relation to the Episodes sheet. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3b1f2f16eab5a7705cb1100e24da462384bd4348.png) In Level 2, I make a template joining the Category and the Episodes value, then use that column to make a relation to the Videos sheet. Make sure you also create a same template column in Level 3 to make the relation work. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c6259c43ad3dcc5dfa1360f102c281211a88a4dd.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0fc5ac3e2f6c00d9bc554d68ba52782f0eb8309a.png) ---
**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:** [May 30, 2020, 7:50am UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/14 "2020-05-30T07:50:29Z")
In the Videos sheet, I used some arrayformulas to generate the videos’ ID and its thumbnail image. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a64ff3d2a9269a429f58ebdd55a10d9ef00e8dff.png) ---
**Author:** ![ClipIt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clipit/32/10012_2.png) [@ClipIt](https://community.glideapps.com/u/ClipIt)\ **Post date:** [May 30, 2020, 3:08pm UTC](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/15 "2020-05-30T15:08:05Z")
Hi ThinhDinh, this is incredibly helpful! Clarification question… When you say Levels 1, 2, & 3…are those different sheets? If possible, it would be super helpful if I could copy the test app so I can backtrack to what you’re doing with these individual sheets since I’m struggling with the Level 2 template + relation since I’m only able to grab one or the other (Episode or Category)