Forum Stats

  • 3,686,723 Users
  • 61,101 Discussions


Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out:
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

EMPLOYEE SAVED SEARCH | Exposing First and Last Name / Employee ID using a Formula

edited Feb 16, 2022 9:11PM in Search / Reporting

When creating an Employee Saved Search, you'll notice that when we add the Name Field on the Results tab, the Employee ID will show on the search instead of the first and last name.

So here's what we can do.

In the results tab, lets use the Formula Text field to expose the first and last name.

REGEXP_SUBSTR({firstname},'[^ ]+') ||' ' || {lastname}

and it will look like this:

On the other hand, if you want both the Employee ID and the name to be in just one column -- we use this formula:

{entityid} ||' ' || REGEXP_SUBSTR({firstname},'[^ ]+') ||' ' || {lastname}

Refer a Member | Answer Accepter

Micah Timbol | Basic and Advanced Accounting Guru

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!


This Week's Leaders

This Month's Leaders

All Time Leaders