I’m trying to set a valid if constraint for a session to be created. I want the session that is to be booked to validate whether the parent table (Client Case) has a column (Status) value as active.
I have this at present:
IFS(SELECT(Client Case[Status], [_THISROW].[Ref] = [Ref]) = Active, True, False)
Problem is that my Status column is a list, so Im getting the Cannot compare list with text. After doing a little research I found that I should more than likely use the IN() function, but I cant seem to figure out how to fit it in to make it work.
Could someone please offer some advice.