# Creating filter **URL:** \ **Category:** Ask for Help\ **Created:** [August 28, 2023, 11:49am UTC](https://community.glideapps.com/t/creating-filter/65485 "2023-08-28T11:49:37Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![lakwan00](https://avatars.discourse-cdn.com/v4/letter/l/c4cdca/32.png) [@lakwan00](https://community.glideapps.com/u/lakwan00)\ **Post date:** [August 28, 2023, 11:49am UTC](https://community.glideapps.com/t/creating-filter/65485/1 "2023-08-28T11:49:38Z")
I am in the process of building a job hunting tracking tool/app. The first tab is jobs and the second tabs are interviews. I have multiple jobs that I have applied and each is at different stages with multiple interviews. On the first tab, I have created the below columns in my google sheet; Company, Company background, Hiring Manager, Role, Job Description, First Interaction, Referral Contact, Interviews, Feedbacks, Linkedin post, Job Posting post. On the second tab for interviews, I have created Selected company, date, hiring manager, title, email, feedbacks, my notes. I want to link tab 1 and 2, but clicking on the job in tab 1 that will take me to tab 2 and list all the relevant interviews I have with the company that I applied. I have created a Button that will Go to Tab Interviews but how do i filter to just that company? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [August 28, 2023, 12:01pm UTC](https://community.glideapps.com/t/creating-filter/65485/2 "2023-08-28T12:01:03Z")
You’ll also need to set a value somewhere before navigating (typically in the user profile table or in a working table using a [single value → whole row](https://community.glideapps.com/t/mastering-the-mighty-single-value-whole-row/57071)). Then, filter that list by the value that was set. ---
**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:** [August 29, 2023, 1:22am UTC](https://community.glideapps.com/t/creating-filter/65485/3 "2023-08-29T01:22:03Z")
Wouldn’t you want to see those interviews through a relation when you click on a company? Or using 2 tabs is more convenient to you? ---
**Author:** ![lakwan00](https://avatars.discourse-cdn.com/v4/letter/l/c4cdca/32.png) [@lakwan00](https://community.glideapps.com/u/lakwan00)\ **Post date:** [August 29, 2023, 2:42am UTC](https://community.glideapps.com/t/creating-filter/65485/4 "2023-08-29T02:42:57Z")
I will like to use two tabs, so when i click a job/role, it will take me to the interviews I had in the past with the company. Also on my interview tabs, I can filter by date (last one month), by company as well. ---
**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:** [August 30, 2023, 12:46am UTC](https://community.glideapps.com/t/creating-filter/65485/5 "2023-08-30T00:46:54Z")
> [@lakwan00](#): > > I will like to use two tabs, so when i click a job/role, it will take me to the interviews I had in the past with the company. Just to be clear, you don’t need 2 tabs to achieve that. You can just use a show details screen action on the Job/Role list, and show a collection of the related interviews in the details screen. ---
**Author:** ![lakwan00](https://avatars.discourse-cdn.com/v4/letter/l/c4cdca/32.png) [@lakwan00](https://community.glideapps.com/u/lakwan00)\ **Post date:** [August 31, 2023, 1:37am UTC](https://community.glideapps.com/t/creating-filter/65485/6 "2023-08-31T01:37:03Z")
how can I do that pls? ---
**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:** [August 31, 2023, 1:38am UTC](https://community.glideapps.com/t/creating-filter/65485/7 "2023-08-31T01:38:28Z")
Create a relation from the Job/Role table to the Interviews table using the Company field (if you have that available in both tables, and ideally as an ID instead of a name). Then in the details view of the Job/Role table, show that relation using a collection component. ---
**Author:** ![lakwan00](https://avatars.discourse-cdn.com/v4/letter/l/c4cdca/32.png) [@lakwan00](https://community.glideapps.com/u/lakwan00)\ **Post date:** [September 1, 2023, 10:09am UTC](https://community.glideapps.com/t/creating-filter/65485/8 "2023-09-01T10:09:54Z")
what is a collection component? ---
**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 1, 2023, 10:19am UTC](https://community.glideapps.com/t/creating-filter/65485/9 "2023-09-01T10:19:48Z")
> **[Collections](https://www.glideapps.com/docs/essentials/components/collection-components)** > > Show lists of items from your tables in different layouts. ---
**Author:** ![lakwan00](https://avatars.discourse-cdn.com/v4/letter/l/c4cdca/32.png) [@lakwan00](https://community.glideapps.com/u/lakwan00)\ **Post date:** [September 1, 2023, 10:25am UTC](https://community.glideapps.com/t/creating-filter/65485/10 "2023-09-01T10:25:57Z")
Thanks, and how do I create a relation between two tabs in my google sheet? ---
**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 1, 2023, 10:36am UTC](https://community.glideapps.com/t/creating-filter/65485/11 "2023-09-01T10:36:09Z")
> **[Relations](https://www.glideapps.com/docs/automation/computed-columns/relations)** > > Create relationships and link rows together. I’d recommend spending a bit of time at [Learn Glide](https://glide-university.glide.page/dl/home) just to get to understand some of the basics.