Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Autofilter an Interface Page Based on the Current User

Topic Labels: Interface Designer
Solved
Jump to Solution
812 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Abbey_Matye
5 - Automation Enthusiast
5 - Automation Enthusiast

Hiya!

I'm trying to implement parts of Airtable's Project Management Template into a Project Management system for my organization. In the Getting Started section, it describes the "My Tasks" page as "a summary of the current user's work". I love that my team members will be able to quickly go to that page and see a summary detail of their current tasks. However - I can't figure out how to "auto-filter" the page.

In the template it's set up as a page/group filter: Where {Assignee} contains "Malik Johnson". I know this is just an example filter in the template, but if I were to type a specific name in that filter, it would only show that person's tasks, regardless of which person is on the My Tasks page. Am I missing something? Is there a way to set up the filter as "assignee matches current user"?

1 Solution

Accepted Solutions
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @Abbey_Matye!

I didn't go through the specifics of the template. However:

(a) If the Assignee field is a "user" type field, you would apply the filter as shown on the image below, where [assignee field] has any of current user.

(b) If the template has some sort of Staff/Users table, where each record (meaning each person) has a "user" type field, you can have a lookup at the tasks level (lookup from the assignee field which links to the Staff/User table), to bring the actual user of the Assignee, and apply the following pre-set filter. -see image, where [lookup field] has any of current user.

Mike_AutomaticN_0-1724180820775.png

Hope this helps! Otherwise, feel free to provide some screenshots.

Mike, Consultant @ Automatic Nation

See Solution in Thread

2 Replies 2
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @Abbey_Matye!

I didn't go through the specifics of the template. However:

(a) If the Assignee field is a "user" type field, you would apply the filter as shown on the image below, where [assignee field] has any of current user.

(b) If the template has some sort of Staff/Users table, where each record (meaning each person) has a "user" type field, you can have a lookup at the tasks level (lookup from the assignee field which links to the Staff/User table), to bring the actual user of the Assignee, and apply the following pre-set filter. -see image, where [lookup field] has any of current user.

Mike_AutomaticN_0-1724180820775.png

Hope this helps! Otherwise, feel free to provide some screenshots.

Mike, Consultant @ Automatic Nation

Ah, adding a user field was what was missing. Thank you!