Sort a database using a reference column

I’m allowing users to search through my database using a combination of a search bar for a project name and a dropdown list to selct a city. Much like wix did in their youtube video:

The only difference is my drop down list comes from a reference column, whose value is actually a long string of letters and numbers, so my comparison does not work. Is there a way around this?

Thanks!

1 Like