# Blog
Covering NetSuite Administration, Development and anything I find interesting or useful!
Saved Search Link Behavior
In my last post, I discussed how to create dynamic links in Saved Searches to drill-down to related saved searches. In this post I will add to that example by showing how to have the drill-down searches open in another tab or pop-up window. This will allow your users to not lose their place in when opening the dynamic links you have created.
Dynamic Links in Saved Searches
Saved Searches allow for some native options for drilling down into results data through grouping fields. If you summarize fields by group and then click the field link, you should be redirected to a summarized view of your saved search. But what if you want more unique data in your drill-down? What if you don't want to lose your current search your are viewing? There are some formulaic answers to these questions that I will explore in this post.
Keyboard Shortcuts
Did you know that there are a variety of simple keyboard shortcuts for data entry and NetSuite Navigation?
Matching Field Strings using CASE Formula
Have you ever had to compare string data from 2 different fields or across joined records? It is very easy to match the string of two free form text fields using a CASE WHEN formula
SuiteAnalytics Workbook (Beta)
Have you ever wanted to be able to do more with your saved searches and reporting in NetSuite? Are you tired of edit/saving to test criteria or results changes? Have you ever wished you could create pivot tables in NetSuite?
NetSuite Certified Admin / SuiteFoundation Study Guide
Are you a user or consultant with some level of administrator privilege over a NetSuite account? Do you know your stuff and want to be able to test your knowledge? NetSuite certification might be right for you.
Default Shipping Address in a Custom Field
Recently, a user asked me if they could view the Default Shipping Address for a Customer Record as a field on the Main subtab. The issue they were reporting was the ADDRESS field on the Customer Record always shows the Default Billing Address.
Anatomy of a Saved Search - Criteria
The “Criteria” section of the saved search editor allows you to narrow down your results to see only the data that is useful or relevant to you. The criteria subtab is simple to grasp but can become as complex as you need it to be to retrieve the specific dataset you are search for.
Create a link to another record in a Saved Search
Sometimes, you may find yourself in a situation where you want to link out to another connected record in a Saved Search without having to drill down to the record and then to the Related Record. Thankfully, NetSuite makes this pretty easy with a Formula(text) field. The trick lies in getting the formatting of the formula correct to make this work.
Creating Custom Center Tabs
A follower of this blog reached out to ask for help on how to set up a Custom Center Tab, so I thought I would write up a brief how-to on Custom Center Tabs, Categories and Links. Center tabs can be created to add a permanent navigation bar tab to the NetSuite interface. These tabs can be added to Centers and limited by Audience (roles, people, departments, groups, customers, vendors, partners)
Anatomy of a Saved Search - Definitions
When creating or updating a Saved Search in NetSuite, there are a lot of options and features to consider. In most cases, you can get by with many of the basic features, but it is useful to know how all the different options affect your search.
Highlighting Saved Searches
NetSuite has a number of useful highlighting tools for saved searches. These tools can be used to call out important data in a saved search, and generally highlight at the line level. You can highlight a lines in saved searches by condition and highlight by...
Welcome
Recently, I found myself looking for a good place to document some of the things I have learned over the years as a NetSuite Functional Administrator, Business Analyst, Project Manager & amateur coding enthusiast. I started recording some notes in OneNote and then Workflowy, but I thought I should be more public about it so I've decided to periodically post this kind of information to this blog.