Hi Brett, that is correct. Currently all scheduled saved searches run at 2 a.m. Pacific Time. You may want to vote for Enhancement Request 208791 - Saved Searches: Allow the ability to email saved searches at a scheduled time(start time). Thanks,

You can use a Formula (Text) field with a formula like: to_char({date}, 'YYYY'). This will only show the year of the date field. Thanks,

Try adding the Publish Search permission with Level = Full to the role. Thanks,

The Help topic titled, SQL Expressions outlines the SQL functions that can be used in NetSuite search formulas and custom formula fields. Thanks,

You could group each of the columns under the results tab. Thanks,

thanks can you give me an example? Or where can I read more to learn how to use the formulas? The Help topic titled, Search Formula Examples and Tips is a good place to start. You can also try searching this UserGroup for the thread titled, 100 Ways to Use Formula Fields. Thanks,

You should be able to use something like: {today} Thanks,

A Formula (Text) in your results with CASE WHEN {datefield} IS NULL THEN 'WORD' ELSE '0' END should work. Thanks,

Hi Kevin, You can remove the New column by turning off Inline Editing. Thanks,

You can extract the month using a Formula (Text) Field on the Results tab: TO_CHAR({datecreated},'Month') Thanks,

Try a customer search using the 'summary' filter option and add a summary filter for "maximum" of "activity : date" is not after x days ago. You also need to group the results by customer name/id or some other field. Thanks,

Hi Natalie, You could first determine the internal id's of the companies, then add them in the case search using the internal id field. The internal id field will allow you to select multiple id's. Thanks,

You can also include the Internal ID field by default on search results by enabling the preference at: Home > Set Preferences > General tab > Show Internal IDs = T. Thanks,

If this is in a portlet, click Set Up and make sure Allow Inline Editing = T. Thanks,

Try adding criteria for Main Line = T as well. Thanks,

You might have the user preference for internal id enabled. Go to Home > Set Preferences > General tab, and make sure Show Internal IDs = F. Thanks,

The search results should not display the internal id when Show Internal IDs = F. Thanks,

Visit the SuiteAnswers Learning Center: Training Videos section for Self-Paced Training Videos. Click the Support tab > Visit the SuiteAnswers Site > Learning Center. Thanks,

List edit capability for the Task Title is not exposed to searches, but we are tracking the request through Enhancement 96215. WORKAROUND: Direct List Edit from Activities > Scheduling > Tasks. Thanks,

Hi Natalie, You are able to customize reports only if you have the Report Customization permission. Without this permission, no Customize links appear on reports that you view. If you want to restrict access to specific reports by role, click the More Options link when customizing a report, and highlight the Roles to grant…

Hi Natalie, Try a customer search and use Name/ID for criteria. i.e. Name is Baker. Then add the Address fields under the Results tab.

Try a formula (text) field using rtrim(regexp_substr({itemid},'[^:]*$')). This should return the child item only. Alternatively, you can use ltrim to return parent items. Thanks, Rob

You could use the Date Created filter as criteria and specify 'On Today'. Then add a Formula(Text) to your Results with formula 'Label'. Thanks, Rob

Try a formula (text) field using rtrim(regexp_substr({itemid},'[^:]*$')). This should return the child item only. Alternatively, you can use ltrim to return parent items. Thanks, Rob

It's not required but I use the ltrim, rtrim functions for quick removal of characters from the left/right of a string, including spaces. Thanks, Rob

This is not currently available but may be part of a future release. Enhancement 22611 tracks this request. Thanks, Rob

Defect 180803 has been filed for this and has our highest priority. No eta is available at this time. Thanks, Rob

Currently you cannot schedule the time that saved searches are run. All scheduled saved searches run at 2 a.m. Pacific Time. You can vote for Enhancement 144975 Saved Searches: Schedule Email > Ability to set frequency or number of times per day for Daily recurrence. Thanks, Rob

Re: Defect 172618: Can't use formula for Name fields on Custom Record Mass Updates. For others experiencing the same problem, try the following workaround: Click Mass Update Fields Tab > Name Field Apply Check Box = F, Name Field Formula: (Remove the Formula). Click the Preview Button. Click the Return To Criteria Button.…

Hi Bushra, You can group the results for Display name and Date viewed using the Group summary type, then use Count on the # Times viewed column. Under the Results tab of the search, click the Summary Type column and select Group for Display name and Date viewed. Choose Count for # Times viewed. This should remove the…