Build an Inline view with the values from an EnumList self refferenced

I have two tables: bloodtypes and donors
bloodtypes:
key = number (1 to 8 representing A+,A-,B+,B-,O+,O-,AB+,AB-)
donors =Enum List type ref to bloodtypes table (Example; A+,A-,O+,O-)
recepients = Enum List type ref to bloodtypes table (Example: A+,AB+)

donors:
name,phone,bloodtype

For each blood type I have the lists of recepients alredy and I have another table called donors that have the name, phone and blood type of the donor

I’m looking to build an inline view of donors displayed in the detail view of a row in bloodtypes so that when I select for example row A+ it will show me all the donors compatible with A+ filtered with the EnumList of referenced from the column [donors]

Like this?

FILTER(
  "donors",
  IN([bloodtype], [_THISROW].[donors])
)
4 Likes

Perfect!

3 Likes