Hi, I have an inventory app. For adding a ne...

(Itay Golan) #1

Hi,

I have an inventory app. For adding a new item form:

ID[uniek]{text type} item name{text type} category{EnumList}

for example: ID- “XTY4421” Item name - “banana” Category - “fruits, yellow, happy” (I choose 3 categories)(3 values in one cell)

is it possible to use the Select function if only one of the categories is equals? In order to open a list that related to a category.

for example: I pick “yellow”, and the item list will “banana”. or if I pick “fruits” ill get “banana” also.

thanks in advance.

(Aleksi Alkio) #2

You can use syntax as… SELECT(TableName[Item Name],IN([Category],[_THISROW].[Category]))

(Itay Golan) #3

Thanks, but still not working. I don’t see the items that have several categories. only the item that has one category

(Itay Golan) #4

#ERROR!

(Aleksi Alkio) #5

Let me test this…

(Itay Golan) #6

OK now I manage to succeed!

=SELECT(Stock[items],and(in([_THISROW].[catgory],[category]),[in stock]=Y))

(Aleksi Alkio) #7

Okay good. I probably misunderstood you column structure slightly.