Hi, it is possible to filter products in inline list? with a same category or same color, or by the same serie (like show me only the rows inside “Serie” that contains “Nike Jordan”)? that is possible??
Im trying to show variations of a products by a inline list.
thanks!
It is possible go to feautures in your inline list comopnent you should see filter
thanks for answer, I know that exist, but it doesn’t work for me, I don’t know if Im doing something wrong or is a bug…
the thing is, I have a product (Nike Jordan Retro), inside that product I have the details of the product and a inline list, but that inline list can’t be filtered by (Nike Jordan) to show me just Nike Jordan shoes and not the others shoes…
I have in the sheet
Product name | Serial
Nike Jordan Retro | Nike Jordan
Nike Xt. | Nike
Adidas 33. | Adidas
Nike Jordan Evol. | Nike Jordan
I’m trying to filter this way but nothing happens: filter when [Product Name] “contains” [Serial]
Create a column in your sheet for each property type you want to filter by: name, brand, etc. Fill these columns with the unique values.
Also create a column for each type of property in the user sheet (again name, brand etc.) so that user’s filters do override each other.
Above your inline list create a choice component for each category of filter (again: name, brand etc) the choices come out of the columns created in step 1 and feed into the columns created in step 2.
Create a column in the editor in the sheet that contains all your items that is an if/else column and only returns true if each of the choices in step 3 are present in the items list.
Filter the inline list based on true of the column in step 3
Let me know if all that makes sense!
More relevant details could also be found here on a previous post I answered a similar question.
thanks Cmstewart42, I think this way don’t work for me, because I don’t have a user sheet, but looks good your solution. thanks!
You can still do it, but then it won’t be user specific so then there is only one filter for everyone and yes then it would not work when there is more than one person using it.
I’m not sure what the deal is with the Contains not showing anything, but that’s not the way you want to do this because that would only filter the same row to the same row. Not to the other rows that contain the same value. In your Shoes sheet, create a multiple relation column that links the Serial column back to the same Serial column in the same sheet. Then use this relation for your inline list. It will only show the items in the list that contain the same Serial.
Thank you so much that really work for me 