Scenario
- User needs to add a certain filter in the Available Filters tab of a Saved Search, but the field that they need is not available since the Show in Filter Region column is greyed out.
- User wants to be able to search for the values using a Text box, but the field added in the Available Filters tab is a Drop Down field.
Solution
1. Go to Lists > Search > Saved Searches
2. Look for the search that you need to apply the Text Box filter to, then click Edit
3. In the Criteria tab, add a Formula (Text) field:
- Formula: {item}
- Description: contains <5 spaces>
Note: You can use the field ID of the field you need, like {number} for Document Number. You can also use "starts with" instead of "contains".
4. In the Available Filters tab:
- Add Formula (Text) in the Filter column
- Mark the checkbox in the Show in Filter Region column
- Enter a Label
5. Click Save & Run
6. Enter a keyword in the Text Box, then press Tab
In this example, I typed in "Nikon", so the search pulled all item lines which contain the word "Nikon".
Limitations
- Only one (1) Formula (Text) can be added in the Available Filters tab of the Saved Search. Trying to add another Formula (Text) field will prompt a message: "Filter must be unique".
- This will not work if there is more than one (1) Formula (Text) field in the Criteria tab of the Saved Search.
- Users need to be very specific in the search keyword. For example, entering "100" will show all items (or field values) which contain "100" like "1000", 10100", or "21005".
-----
If you find this information useful, let us know by reacting or commenting on this post!