Enumlist of not registered items

AppSheet AppSheet Q&A
,
1

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?

2

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.

Aurelien_1-1662536105565.png
Aurelien_1-1662536105565.png307×548 23.6 KB

Something like:

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

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

4

Did you try my suggestion ?

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

1 Like
5

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

1 Like
6

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])
    )
  )
)
1 Like