how to add the "amount" field to the filters of a ...
# ask-stanley-ai
m
how to add the "amount" field to the filters of a saved search, so we can enter a value directly instead of filtering through the column header dropdown?
c
AI generated answer (using internal Slack threads):
To add the "amount" field to the filters of a saved search in NetSuite, you can use a workaround by adding a Formula (text) criteria. Here are the steps: 1. Go to your saved search and navigate to the Criteria tab. 2. Click on the 'Add' button next to 'Formula (Text)'. 3. In the formula field, you can use a formula like
TO_CHAR({amount})
to convert the amount field to text. 4. Set the operator to 'contains'. 5. Leave the value field empty. This will allow you to enter a value when you run the search. 6. Save the search. Now, when you run the search, you should see a new filter field where you can enter an amount to filter by. Please note that this is a workaround and might not be perfect. Another solution might be to use a Dashboard 'Search Form' which works from the criteria from the Results columns instead in Criteria. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.868242085
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837414682
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834340513
Please provide your feedback on this answer.