Jan 10, 202306:07 AM - edited Jan 10, 202306:07 AM
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".
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