Filter by “current user”

The new Interface feature allows you to filter a collaborator field by “current user” which is a great time saver. Anyone know if they will make this available in regular AirTable views? I really need it.

It would be really great for them to bring over features from their “new stuff” (such as Timeline view and Interfaces) into their “old product”. Only time will tell. I would recommend sending an email to support@airtable.com to let them know that this is important to you.

I think adding “filter by current user” to Views as we know them would break more things than it would solve. Anything that relies on a View having a list of records (i.e. Zapier/Integromat, Automations, Scripts, API integrations, publicly shared Views) would be wildly inconsistent depending on who is looking at the View, and would be useless if 2+ users were looking at the View at once or if no one was looking at the View.

If they add the functionality it would suggest an implementation that creates two types of filters available to Views (and consequently, probably rollups/lookups/counts as well):

  1. Global Filters: which control which records exist in a View. This behavior is unchanged from the filters as we know them.
  2. Session Filters: which controls which records are shown to the current user but does not affect the list of records shown to anyone/anything/anywhere else.
    • This could be implemented in a few ways, but if used in conjunction with permissions it could be implemented as Creators being the only ones who can control this setting to say: if enabled, only show Editors/Commenters/Read Only users records where {Collaborator Field(s)} matches/includes their name.

Example Use Case
With that implementation you could set up one View that has Global Filters set to only show Projects where the {Status} field = “active”, and a Session Filter set to only show records where the {Assignee} field = “Current User”. This would mean you wouldn’t need a separate personal View for each collaborator.


@Bill.French curious what you’re take on a “Current User” filter for Views

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.