One option might be to Disable/Hide a field depending on the user's role using a script. An example is provided in SuiteAnswers Answer Id: 31253.

We are tracking this functionality in Enhancement 115393 Saved Reports > Allow Users to Categorize Saved Reports > Assign to Existing Categories/Folders and/or create new Categories/Folders.

There are a few things to consider when creating a search for use in a group - i.e. you cannot define a dynamic group using a summary search. See SuiteAnswers Answer Id: 14455 for more information.

Try setting the option to Run Unrestricted = T under the Results tab of the search. This should make the search results available to users who normally do not have permissions to see the underlying records.

We are tracking this in Enhancement 239129 - Ability to enter formula in the Available Filters tab of saved searches.

The formatting requirements are: The name must be enclosed in double quotes. The email address must be enclosed in carets. There must be a space between the quoted name and the email address. See SuiteAnswers Answer Id: 19150 for examples.

Try changing this preference at: Home > Set Preferences > Reporting/Search tab > Show List When Only One Result = T.

Even though the formula is the same, the field {custitem_pr_factorial} is likely a text field and needed quotes.

i dont know. what do you mean set when ordered by? is that a sql formula? The When Ordered By Field is available when you select a Summary Type of either Minimum or Maximum, on the Results subtab of a search record. [ATTACH=CONFIG]n286986[/ATTACH]

The invalid expression happens with {systemnotes.field.id} - try {systemnotes.field} instead.

The formula would differ a bit on a customer search. Try using {call.startdate} instead of {startdate}.

You can create a saved search for existing searches: 1. Navigate to Lists > Search > Saved Searches > New. 2. Click on Saved Search. See SuiteAnswers Answer Id: 31529 for more information.

Matt, thanks for the update. I assume the custom record uses permissions and roles are listed under the Permissions tab. Have you tried adding the Administrator role to the list? Thanks,

Hi Matt, are you the owner of the mass update? The failure may occur if the owner of the update doesn't have the related permission. Thanks,

Try enclosing the search string in quotation marks, or follow it with a backslash, to search for records containing only exact matches. Enter cu: “ max” or cu:max\ to search for customers with a name of Max. Customers with names containing the letters max, like Maxam, Lomax, or Maximum Tires, are not returned. Quotation…

You could set criteria using formula(numeric): CASE WHEN to_char({datecreated},'HH24') < 12 THEN 1 ELSE 0 END

listagg(x,’,’) is not yet supported . Please contact Support and reference Defect 294790. Your case should get attached so you can receive notification when it becomes available.

Hi Jim, The permission which controls the Public checkbox is the Publish Search permission. 1. Navigate to Setup > Users/Roles > Manage Roles. 2. Edit the custom role. 3. Click the Permissions subtab. 4. Click the Lists subtab. 5. On a new permission line, select Publish Search. 6. Select Full access level. 7. Click Add.…

A script may be the way to go in this case. We are tracking this functionality in Enhancement 155770: Reports > Saved Searches > All Saved Searches > To be able to specify the file name of the results attached to the email.

The Lists permission named "Perform Search" controls the Customize View button. Try setting the permission level to View to remove the button. Thanks,

Hello Nathalie, An Enhancement Request has been created for this and you can vote for this in your NetSuite Account Center. Enhancement 109703 - Setup > Customization > Lists > click one of lists: Be able to export list values as CSV export. Thanks,

Try CASE WHEN to_char({item.custitem_refurbished}) = 'T' THEN 'Refurbished' ELSE 'New' END Thanks,

Enhancement 213878 should address this: Saved Searches > Execution Log tab : Ability to create and run a saved search that captures information from the Execution Log tab of the search.

This goes back a while but I tried the same formula Concat('"', Concat({comments}, '"')) as well as '"' || {comments} || '"' and both exported to csv as expected using Excel 2010.

To resolve this, perform the following steps: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Customer. 3. In the Criteria tab > Standard subtab, select Formula (Text). 4. In the Customer Search popup window, set the following: •Field: Choose Alt. Email, Mobile Phone, Home Phone, Subscription Category or…

Does the search return dupes when the script has been disabled? Thanks,

I would check with Support. They may be able to point you in the right direction. Thanks,

You use expressions to specify the OR condition in your criteria. Check the Use Expressions checkbox under the Criteria tab. The last column allows you to set the AND/OR condition. Thanks,

Here's a similar thread that includes examples: https://usergroup.netsuite.com/users/showthread.php?t=31596&highlight=matrix+item+child Thanks,

An example of a workflow might be to automate a drip marketing campaign or automate an approval routing process. Saved search results provide reporting and tracking and can serve as the basis for business analysis and strategic decision-making. A saved search can have many advanced search filters and display options which…