Incorrect results from Multiple Select Controls and blank values for rows


I am using several Multiple Select Controls to “filter” and get a single list. In the included example, Students can have 0… Major, Sport, Club, and Instrument.

I have Multiple Select Controls for Major, Sport, Club, and Instrument.

Desired behavior:
If I select “All” for each control, I should get a list of all students. (Currently, it only returns “Agatha”, who has a value for Major, Sport, Club, and Instrument.)
If I select “Biology” in the Major select control and “All” for the other select controls, I should get “Agatha” and “David”. (Currently, it only returns “Agatha”.)

How can I fix this?

Thank you,

Dear @Patricia_Liu,

Would you mind to update the sharing setting to “everybody with a link”?

Also, @Patricia_Liu, it would be helpful to have edit access, otherwise we can’t see the underlying implementation.

Thank you!

Hi Jean Pierre - Where can I update the setting? I don’t see it under Share. Thank you.

Hi @Patricia_Liu,

Two things:

  1. [General] In the select controls, it’s usually easier to directly put the table itself: this way you avoid to check against one of their properties every time.
  2. It’s not clear how you want to treat the fact that a student has not any selected selection for some dimensions.
    I provided the four possible implementations. It’s up to you to find what you actually need

Let me know if this helps.

@Federico_Stefanato Thank you!!! The solutions are AWESOME! I appreciate the first tip, as well.

1 Like