1. Navigate to Lists > Search > Saved Searches > New
2. Choose Item
3. Under the Criteria subtab > Standard subtab > Add Filter
Type = Inventory Item
Formula (Numeric) > Click the Set Description Icon
Formula: CASE WHEN translate({name},'abcdefghijklmnopqrtsuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*()_+=-','*') = {name} THEN 1 else 0 END
Formula (Numeric) = equal to
Value = 1
4.On the Results tab > Columns subtab > Add Fields of your preference
5. Name your Saved Search.
6. Click Save & Run Button.
No comments:
Post a Comment