In a Base that assigns tasks to collaborators, I would like to show each collaborator what tasks they themselves are assigned to.
I’d like to have a view with a filter something like ‘Collaborator assigned’ is equal to ‘Current collaborator’ where ‘Current collaborator’ would be the value of the currently signed in collaborator.
If I was doing this inside a script I could use “session.currentUser.name” to get the current collaborator. Is there an equivalent way to get the current user from a formula?
The closest solution I’ve been able to think of so far is to just create a separate View for each user and hard code the collaborator (or another unique field) into the filter. I’d have a set of views like this:
See Jane’s Tasks
See Joe’s Tasks
See Jack’s Tasks
Is there a way that I could implement just one View, “My Tasks”, that would show just the tasks of the currently logged in collaborator?