Enumlist of not registered items

[snerdya]

Hi. I want to know if there are ways to show only unregistered items in enumlist in another table. I have 2 tables. One is for registering the products. Another one is solely for the product details. 

For example:

Table 1

• Planner
• Markers
• Pencil case
• Box

In Table 2, details on planner and markers are already available. In the form list, i want to show only pencil case and box. Is this possible?

[Aurelien]

Hi @snerdya 

yes, you need to set type EnumList, base type Ref, and then go a little below and set a filter expression in the Valid_If field.

Something like:

FILTER("itemTable",
  [status]="not available"
)

[snerdya]

How about if i want to eliminate available item from the list?

[Aurelien]

Did you try my suggestion ?

Here is the documentation for the FILTER() expression: FILTER() - AppSheet Help

[snerdya]

Yes I have tried your suggestion but there is error. What i wanted to do is filtering items that is not yet existed in the current table and comparing items that has been registered in the current table and the master table. but i'll try again your suggestion 

[Aurelien · Accepted solution]

Ok, then you may want to combine the FILTER with NOT(), IN() and AND(). 

For reference:

NOT() - AppSheet Help

IN() - AppSheet Help

AND() - AppSheet Help

Something like:

FILTER("itemTable",
  AND(
    [status]="not available",
    NOT(
      IN([keyColumnItemTable],yourCurrentTable[RefColumnToItemTable])
    )
  )
)