I have a relation/lookup combo that outputs all users that have a particular value in my table. I’d like visibility to be dependent on whether that “cell” in the lookup contains the signed in user. I can’t use IS signed in user because there are more than 1 user in the field:
It should work like that. Your lookup column is an array, so the the visibility should be comparing each individual user in the array to the signed in user. Try changing the email using the Preview As button to see how it reacts.
It works. I’m dense. I was looking at THE ONE item that wasn’t assigned to my user.
ANYWAYS…this now opens up new doors I think for several other apps of mine!
I want to do something similar to this except it’s a conditional column where there a list of items that has multiple owners. I want to show an image if the it’s the owner, and another image if they’re not the owner.