Drive Values to NetSuite Forms and Other URL Tricks

This article is relevant if you need to automatically fill in values to NetSuite records or you need more flexibility for referencing custom scripts in URLs.

Background

In our NetSuite Systems Integration Practice, we see all kinds of situations which demand the use of the NetSuite platform to produce innovation. Along the way, we learn things that are not documented. I learn many things from our team members. Yet it is special when our client NetSuite Administrators share their discoveries.

This article is in gratitude to Sterling Rose, NetSuite Administrator and ERP Manager at one of our clients.  On two occasions, Sterling brought to our team NetSuite features that are indeed useful when working to drive an enhanced day-to-day user experience.  Accordingly, I would like to bring these to you below:

Automatically Fill NetSuite Body / Header Record Values

Sterling discovered that if you append the parameter value pattern “record.fieldName=value” to a URL, you can get NetSuite to prefill information on records. For example, consider the following URL:

https://system.netsuite.com/app/common/entity/contact.nl?record.email=wilda.beesting%40whereduhwildflowersis.com&record.lastname=Beesting&record.firstname=Wilda&record.comments=test%20hey%20how%20ya%20doing&whence=#

Here, we are driving four values:

  1. email = wilda.beesting@whereduhwildflowersis.com
  2. lastname = Beesting
  3. firstname = Wilda
  4. comments = test hey how ya doing

To get this to work, you need to URL encode the field values so they are parsed correctly by NetSuite.  Based on testing, it appears this trick works only for Body or Header values.

Flexible Script Deployment Referencing

When you want to deploy a script, such as a SuiteLet or a Restlet, NetSuite will offer a URL that will produce integer based internal IDs to reference the script definition and deployment. It’s not obvious, but you can instead reference the script and deployment by name. When doing so, you do not need to worry about the URL elements changing as you are working between environments (remember, the server name may change depending on the data center) or across account deployments. Consider the following URLs:

Provided by NetSuite
https://rest.netsuite.com/app/site/hosting/restlet.nl?script=646&deploy=1

Change the script reference
https://rest.netsuite.com/app/site/hosting/restlet.nl?script=customscript_auth_api_endpoint&deploy=1

Change the script deployment reference
https://rest.netsuite.com/app/site/hosting/restlet.nl?script=customscript_auth_api_endpoint&deploy=customdeploy_auth_api_endpoint

Drive a Better NetSuite Experience

We all gain a high degree of productivity in our customization enhancements since NetSuite is an application framework and not a general rudimentary programming/database language. Yet, as with all software constructs, this application framework has imposed constraints as published by NetSuite. Thus, anything we can do to invent and work with the imposed constraints helps us become better actors to deliver value to our community.

I appreciate Sterling and his contribution to our team and to the larger NetSuite community. If you would like to work with a team of passionate and creative NetSuite professionals, let’s have a conversation.

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to setup a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Category: NetSuite, Technical | 1 Comment

One Comment

  1. Posted July 4, 2018 at 1:27 am | Permalink

    Hi Marty

    Automatically fill Netsuite body values is indeed new discovery. For script deployment referencing it is similar that in saved search too one can replace the number with script internal id.

    Thanks.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>