How to Fix Filter with Multiple "Yes" Options in Glide

I’m working on an app where I’m using a filter for safety labels on mushrooms. The labels I’m using are:

Yes (with caution)
No

yes

Yes

Yes (with caution)

What’s your ideal outcome?

Hi Thinh,

Thank you for responding to my post. I’m currently developing an app that helps users identify mushrooms using AI and provides emergency support if they encounter toxic varieties.

I’ve encountered an issue in Glide where I see duplicate Filter entries for “Yes” (okay to eat) and “Yes (with caution)” in my data. I would like to delete these duplicate entries, but I’m unsure how to do this within Glide. My data sheet looks fine, but the filter is showing duplicates. Could you please guide me through the correct process to resolve this?

Thank you for your assistance.

Do you have a screenshot of what you see? Just want to make sure I understand. If you see values in the filter that appear to be duplicates, then that could be that the column with the Yes/No values may have extra spaces, or something to cause the values in different rows to be slightly different, but unnoticeable to the naked eye.

Thanks Jeff,


This is my data

Well for starters I see yes and Yes which are different because one has a capital letter and one doesn’t. The filter is showing all non duplicate values from your data. For the Yes, it needs to be consistent if you only want to see it once in the filter.

1 Like

Jeff, thanks for pointing it out, I got it.

1 Like