How to add an address lookup feature on a customer record.

Using Dynamic Hyperlinks facilitates Google Map integration in NetSuite. For hyperlink fields, you can establish a link to a website by setting dynamic defaults. Dynamic defaults prove beneficial when the exact URL is unknown until information is collected for the record. You may also wish to incorporate information specific to the current logged-in session as a URL parameter. When configuring a dynamic hyperlink, input the http address in the Default Value field, followed by ?= and the necessary NetSuite tags enclosed in curly braces.

As an illustration, let’s consider implementing an address lookup feature on a customer form. Create a custom Entity field with the following specifications:

  • Label: Map
  • ID: _map
  • Type: Hyperlink
  • Store Value: Not checked
  • Applies To: Customer
  • Display / Subtab: Main
  • Display / Link Text: Click Here for Google Map
  • Validation & Defaulting / Default Value:
http://maps.google.com/maps?q={billaddr1}%20{billcity}%20{billstate}%20{billzip}

Ensure that Validation & Defaulting / Formula is unchecked (after saving the field, revisit the custom field configuration page and confirm that Formula is cleared).

The default value incorporates NetSuite tags identifying the specific address of the current customer. These tags resolve when the page loads, directing the user to the customer’s address as defined in the current customer record.

Note: When creating dynamic hyperlinks, ensure that NetSuite tags embedded in the default value definition represent required fields. If the fields are not required and the associated form lacks a value for the tag, the resulting URL will be invalid.

Leave a comment

Your email address will not be published. Required fields are marked *