Skip to main content

Dynamic filter based on collaborator field ("Me" view)

  • March 22, 2017
  • 51 replies
  • 249 views

Forum|alt.badge.img+4

The collaborator field is great. Is there any plan to allow dynamic filtering based on this column? E.g. when collaborator contains [me]?

Use case: I’ve got a team issues register using SharePoint. The default view shows the user only those records where their name (based on authenticated user account) is contained in a collaborator column.

I’d like to transition to Airtable, but would need to give users a “My Items” view where they can see only records which contain them as a collaborator, without the user being required to apply a filter themselves.

51 replies

Forum|alt.badge.img+16
  • Known Participant
  • March 30, 2017

This would be super useful as it avoids the need to create a view for every team member. Our team has some long term members but also a few changing staff.

It’d be great to have this “Me” view ready to go for existing team members and as new staff join.


  • New Participant
  • March 31, 2017

+1 @Vernon_Fowler and @Adam_Dowsett that’s excatly my urgent needs thanks for this


Forum|alt.badge.img+4
  • Known Participant
  • April 28, 2017

+1 This would be SO useful for medium and large teams.


  • Participating Frequently
  • May 18, 2017

Obviously a must have for us too :slightly_smiling_face: Would be cool to also have this in forms (pre-filling inputs is already possible, but with static values, like “?fieldname=collaborator” --> “?fieldname=ME”


Just spent 10 mins trying to figure out if there was a way to do this, I think this would be a great addition


Forum|alt.badge.img+13
  • Known Participant
  • September 8, 2017

+1

Let’s call it “filter by currently logged-in collaborator” … is a must-have feature.


Forum|alt.badge.img+4

This is essential - I’m doing work for clients where I’m having to build multiple copies of views (as I’m sure everyone is).


Forum|alt.badge.img+10
  • Known Participant
  • January 22, 2018

It would be great if this filter could be locked, so that collaborators can only see their own records (depending on their role). This significantly expands the market for Airtable to uses like helpdesk/issue reporting, employee expense submission, and any other case where people should be able to add, edit, and view only their records.


Forum|alt.badge.img+13
  • Inspiring
  • February 8, 2018

It would be great if this filter could be locked, so that collaborators can only see their own records (depending on their role). This significantly expands the market for Airtable to uses like helpdesk/issue reporting, employee expense submission, and any other case where people should be able to add, edit, and view only their records.


Yes! This!

This would make the collaborator field really useful.


+1 for this it would be great for teams.

Mehdi


Any news on this? We’d love to see this feature as well!


  • New Participant
  • September 11, 2019

Has there been any movement on this at all? I’d really like to know if its even being considered as a future capability (or if a workaround has been discovered)?
Thanks
Andy


Forum|alt.badge.img+5
  • Inspiring
  • September 12, 2019

Also see this as being a pretty core feature.


Jean-Philippe_E
Forum|alt.badge.img+12
  • Known Participant
  • September 18, 2019

How would you handle whishlist ?

For instance,

  • I have a table with products
  • I have a table with whished items

So I’d like to filter on {colaborator} whished items and if possible don’t let see others whishes
(I’m looking for a small hack to avoid a custom whishlist app with AirTable as a backend)


Forum|alt.badge.img+16
  • Known Participant
  • September 27, 2019

How would you handle whishlist ?

For instance,

  • I have a table with products
  • I have a table with whished items

So I’d like to filter on {colaborator} whished items and if possible don’t let see others whishes
(I’m looking for a small hack to avoid a custom whishlist app with AirTable as a backend)


One way to handle a wish list:

If a dynamic filter based on logged in user (collaborator) is implemented, you could couple this with a locked view grid. That way users could see a wish list table filtered to only show records with them as (one of?) the wisher(s) - aka the logged in user.

Consider whether the collaborator field should allow multiples or be restricted to a single collaborator.


Jean-Philippe_E
Forum|alt.badge.img+12
  • Known Participant
  • September 27, 2019

Thanks,
My idea was to be able to let collaborators to add new whish (not only a view)
The AirTable mobile app is really clean and could be reuse for that kind of use instead of building a new app


I am also creating multiple views with different filters based on a collaborator field. It’s very frustrating, as it seems like filtering by current viewer is such an obvious use of this field type!


  • New Participant
  • October 18, 2019

This would be amazing as it avoids the need to create a view for every team member, who is using exactly the same view, with the only difference being that the filter is adjusted to them as collaborator, so only their items visible.

We end up with:
Tracker (John)
Tracker (Tony)
Tracker (Joan)

When it should be just one tracker with a dynamic collaborator filter.

We are continually upgrading our workflow so having to change every single view for every member every time is a bit of a blocker for us.


  • New Participant
  • December 11, 2019

+1

We would also really like to see this. Having the same view for different people is a very common use-case


Forum|alt.badge.img+16
  • Known Participant
  • January 10, 2020

+1

We would also really like to see this. Having the same view for different people is a very common use-case


Welcome to the community @Mayhul_Arora :slightly_smiling_face:

Thanks for your +1 vote for this product suggestion.

Views filtered to the logged in user seem even more relevant now that the Web Clipper block has been updated with the option to choose a default value of the Clip action user for collaborator fields.


  • New Participant
  • January 19, 2020

1+ this. This will help reduce the number of views in a base which I know is a main complaint with the lack of cross base linking. I’m currently running 30 views in a base and could reduce these by about 12 if I could filter based on user.


Forum|alt.badge.img
  • Participating Frequently
  • March 20, 2020

1+ this. This will help reduce the number of views in a base which I know is a main complaint with the lack of cross base linking. I’m currently running 30 views in a base and could reduce these by about 12 if I could filter based on user.


Agreed to all. +1 on feature add. I’ve built a custom ‘user dashboard’ but it has to be shared with each user manually and doesn’t allow for widescale distribution or edits.


  • New Participant
  • April 27, 2020

+1 want this feature


  • New Participant
  • June 6, 2020

+1. Would love users to not have to create their own views - that we then can’t keep up to date when things change.


Forum|alt.badge.img+2

Very much missing to create views that are relevant to the current user.