find value by another value

[JGL]

Hello!

Before writing, look for my problem and I see that someone already had it and there is no solution,
It is about using the native search, in my table, column "size" for example, if I search for "S" I would like it to show me only "S" and not "XS" and "XXS", etc.

I thought of creating a helper column where to replace the size (XXS,XS,S,M) by numbers,
But I would like that when using the search, to continue putting "XS", "S", "M", and for the program to interpret it as a number...
Any suggestions are welcome, thanks!

[Marc_Dillon · Accepted solution]

You can set the [size] column as an Enum, then use the filter option from the search box.

[JGL]

yes it is a solution, although I wanted to search directly from the search engine😁

[Kabuliño]

You can also achieve that functionality with an Enhanced Dashboard

check out this channel and this specific video
https://www.youtube.com/watch?v=HWhtlzxtPss&t=516s&ab_channel=MultiTechVisions