# Portal Custom View | Filter by a common linked record between the record and the user table **URL:** \ **Category:** Feature Requests\ **Created:** [March 12, 2023, 7:26pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78 "2023-03-12T19:26:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JamieZ](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/jamiez/32/17_2.png) [@JamieZ](https://community.miniextensions.com/u/JamieZ)\ **Post date:** [March 12, 2023, 7:26pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/1 "2023-03-12T19:26:06Z")
Hi Mini Extensions Team, I have seen other Airtable platforms providing this type of filtering / conditioning and I find it really powerful. Putting this idea down for our reference. **The format of the filter is based on a condition that must match between the record and a user’s record. ( via a linked field )** **The use case is good for Groups / Teams - when certain record needs to be shown to a group of logged in users instead of an individual user.** In this example - the user’s table and the record table will have the linked record “Teams” - If a record has the linked record (Team) as “HR” and the logged in user has the linked Record (Team) as “HR”. The record will show based on this condition. ![Snag_89ec78](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/3ac63c3cdf80c9af434fda761b38c12bfcd6952d.png) Currently when we use ( Only show records linked to the logged in user ) this is good, but have it’s limitations. - We may need to add users individually to the record - if there are 100 users, its not easy to manage. - (This context can also be used for display invoice / to groups of customers / company.) ![Snag_8a96b2](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/4203aa772f9c13180de67a7d33e4f0756c9a2149.png) Proposed to have an option to select “show records linked to logged in user” OR "show records that has the same linked records as the logged in user. ![Snag_8da886](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/2ddafa0f7b7c77809416152283d24c4600f4090d.png) Understand that this may require some re-work and may be abit of a complex condition. But **this will save us from creating multiple portals - Example for HR, for Finance etc. - Instead, it filters dynamically to show records based on the user’s Team / department. while still allowing individual user logins** 😃 - Just some thoughts - Feel free to share if there are any ways to go about this or if this can be the way to go? ---
**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\ **Post date:** [March 12, 2023, 7:43pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/2 "2023-03-12T19:43:04Z")
We are working on the ability to add lookup fields that are linked records as a portal field. I think this might be possible with that feature? I recorded a video to explain more here: [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/700d1bcc33c04e6384825230e0ca5cb1) Sorry if I’m misunderstanding this. ---
**Author:** ![JamieZ](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/jamiez/32/17_2.png) [@JamieZ](https://community.miniextensions.com/u/JamieZ)\ **Post date:** [March 12, 2023, 7:59pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/3 "2023-03-12T19:59:15Z")
@Abdul - Thanks you explained this perfectly. - Yes - If we could use lookup fields that would be great! One Question is that could this lookup field be used to show as a portal table? As the main reason to use this is to be able to dynamically filter out records to show based on logged in user’s \> linked record “Team” ![Snag_b15045](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/2e5289d02f0bf8389806740996c9a6c72c8be2cc.png) The ability to use lookup field is great! - Not sure if I am overthinking this too - if it can be achieved by the upcoming lookup feature 😁 ---
**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\ **Post date:** [March 12, 2023, 8:03pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/4 "2023-03-12T20:03:05Z")
Yes, that’s how the feature that we plan on rolling out soon works. You would have that lookup field be one of the tabs in your portal (you can configure it just like the other fields that you have now). We will post here when we have updates about this feature. ---
**Author:** ![JamieZ](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.miniextensions.com/jamiez/32/17_2.png) [@JamieZ](https://community.miniextensions.com/u/JamieZ)\ **Post date:** [March 12, 2023, 8:05pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/5 "2023-03-12T20:05:24Z")
WOW - you guys are amazing! - Read our minds even before we can request it 💖 - This would be really powerful!! Thank you Abdul for the clarifications on this ! - looking forward to lookup field features 💪 ---
**Author:** ![jamesodo](https://avatars.discourse-cdn.com/v4/letter/j/bcef8e/32.png) [@jamesodo](https://community.miniextensions.com/u/jamesodo)\ **Post date:** [June 2, 2023, 4:10pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/6 "2023-06-02T16:10:09Z")
Hi there. Is there any timeline for when this will be implemented? I need it for my summer roll out of a new portal for incident reporting. It has the structure of: Incident Reports Table - Linked to user creating the report - Linked to department (which department did the incident physically occur in) - Lookup field containing the department’s users Departments Table - Linked to individual incident reports (which incidents physically occurred in this department) - Linked to indivdual staff members (which department are they employed in) Staff Table - Linked to incidents they have created - Linked to department they work in - Lookup field containing all of their department’s incidents Current structure only allows me to limit a portal view by incidents they have created personally. I need to be able to have a page - even if a wholly separate portal - that allows them to see ALL reports for their department as well. EDIT: I’m thinking this can be accomplished by way of view filter if MiniExtensions allows the use of a tag in the filter. Are there tags/variables that can be used in filters? See below for what I’m thinking. ![image](https://canada1.discourse-cdn.com/flex035/uploads/miniextensions/original/1X/d84ba05ec2d0b2dcb6cc52a5d9592c61a863da9b.png) ---
**Author:** ![Abdul](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abdul](https://community.miniextensions.com/u/Abdul)\ **Post date:** [October 24, 2023, 12:39pm UTC](https://community.miniextensions.com/t/portal-custom-view-filter-by-a-common-linked-record-between-the-record-and-the-user-table/78/7 "2023-10-24T12:39:59Z")
Hi @jamieZ. It seems we missed to update you with the progress on your request. Using lookup field as a portal table is now available. For more information, you can check this posting. > [@Portal: Lookup Field to a Linked Record Field](https://community.miniextensions.com/t/portal-lookup-field-to-a-linked-record-field/404): > > We are pleased to announce that we have supported a lookup field that displays a linked record field as a valid portal table. For more information about this feature, please visit this article: [How to have multiple tables in a portal? | miniExtensions for Airtable](https://docs.miniextensions.com/en/articles/4876518) Your feedback is valuable to us, and we would love to hear any comments or suggestions you may have. Please do not hesitate to share your thoughts with us by leaving a comment below or by contacting us via chat.