Check if Multiple Reference Field Contains Value

Hi All,

I have to admit i’m new the “WIX scene” but so far it has been treating me quite well. I however seem to have stumbled upon something which cannot be solved with a day of googling so let’s give it a try here.

I’m actually creating a member page where members can also create groups and can subscribe to each others groups… With multiple reference fields this works actually quite well. Within the “groups” table i have fields for “active” members, “pending” members and “owners”. So far so good.
But in a lightbox which shows the current members I want to create the buttons based on the fact if the current logged in member is either already in the active, pending or owner category, or of course non of these.

I tried to do it with adding additional datasets for each category and trying to find out if they return as “0” when using “GetTotalCount”. This however doesn’t do the job it seems, and i also think it is silly to add 3 datasets only for this purpose.

So is there a way to use something like “if [field_pending] contains [paul123445 / MemberId] then PendingVar=1” etc?

If there would be some reference document i’m happy to continue searching.

Thanks up front

Someone wants to give it a go?