Skip to main content
Solved

Single Select Field not giving filter options for "Is Any"

  • January 10, 2023
  • 2 replies
  • 47 views

matt_stewart1
Forum|alt.badge.img+17

I changed a text field to a single select field.

This field has many options (maybe 100+), but I wanted to ensure that similar entries are same spelling and that when creating filters in views we can select multiple options (using "is any of") instead of making several different filter conditions (using "contains").

After making the update, the primary table that holds this field allows for the filter to work properly, as attached.

However on the secondary tables that hold the lookup field, I'm not seeing the filter options change. Creating a new view/filter presents as if it were still a text field, with no options for "is any" or "is none of".

 

Best answer by matt_stewart1

I had to change the lookup field to a different type, then save, then change again to lookup field, and save. then it worked. 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Weird, I just converted a text field into a single select and added a lookup for the single select like you mentioned and it works fine for me; I have a "has any of" etc option for the filter on the secondary table

Might want to open a support ticket! 


matt_stewart1
Forum|alt.badge.img+17
  • Author
  • Inspiring
  • Answer
  • January 12, 2023

I had to change the lookup field to a different type, then save, then change again to lookup field, and save. then it worked.