...
You can do the same thing with the status column
Depleted
Installed
Inventoried
...
Advanced search/AdHoc Queries
Can be used on Advanced Searches or AdHoc Queries but this works better as an advanced Search.
use includes any because the tags field is a multi list and you might not only have one tag on a particular form.
Form | Group | Field | Action | Value(s) |
|---|---|---|---|---|
Case & Form Information | Form Information | Agency | Exact Match | your agency |
ELCI Number Inventory Control | Form Information | Status | Exact Match | Inventoried |
...
ELCI Number Inventory Control | Transaction | transactionQuantity | Lass Than or Equals | 200 |
