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
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?
Solved! Go to Solution.
Ok, then you may want to combine the FILTER with NOT(), IN() and AND().
For reference:
Something like:
FILTER("itemTable",
AND(
[status]="not available",
NOT(
IN([keyColumnItemTable],yourCurrentTable[RefColumnToItemTable])
)
)
)
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"
)
How about if i want to eliminate available item from the list?
Did you try my suggestion ?
Here is the documentation for the FILTER() expression: FILTER() - AppSheet Help
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
Ok, then you may want to combine the FILTER with NOT(), IN() and AND().
For reference:
Something like:
FILTER("itemTable",
AND(
[status]="not available",
NOT(
IN([keyColumnItemTable],yourCurrentTable[RefColumnToItemTable])
)
)
)
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |