How do I run a saved search employees with give ac...
# ask-stanley-ai
a
How do I run a saved search employees with give access checked? It doesn't seem to be a field I can use in my employee search
c
AI generated answer (using internal Slack threads):
To run a saved search for employees with 'Give Access' checked, you would need to create a new Employee Search in NetSuite. Unfortunately, the 'Give Access' field is not directly available in the standard Employee Search fields. However, you can use a workaround by using a formula field. Here are the steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Employee. 3. In the Criteria subtab, select 'Formula (Numeric)' from the drop-down list. 4. In the Formula field, enter the following formula:
CASE WHEN {giveaccess} = 'T' THEN 1 ELSE 0 END
5. Set the formula to equal 1. 6. In the Results subtab, add the fields you want to display in your search results. 7. Save and run the search. This will return a list of employees who have 'Give Access' checked. The formula checks if the 'Give Access' field is true (checked) for each employee, and if it is, it returns 1, otherwise it returns 0. By setting the formula to equal 1, you're effectively filtering for employees who have 'Give Access' checked. ****** 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.831970215
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831176758
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828979552
Please provide your feedback on this answer.