What I’m trying to achieve is to show a profile of a user the current user is matched with
Who this user is, is decided as follows:
In type ‘Matches’ there are two columns representing users, user1 and user2. Both have ‘Users’ as their field type as you can see in the screenshot
One of these is the current user, it can be any of the two
I found this topic to be quite similar
In which @NigelG provides a great solution
However, what’s different in my situation, is that I don’t know in what column the current user can be found, so I also don’t know what label the other column has
I can imagine ‘Any field’ and ‘last item’ can help find find the needed row with the current user, but how do I then find out who the other user is?
The reason a user can be in both columns, is because every week users are matched. So, one week user1 can be matched with user2 (and user2 will be in the second column) and the next week user2 can be matched with user3 (and user2 will be in the first column).