Field Type Descriptions for Custom Fields

Check box

Record a true or false answer by placing a check mark in the custom field.

For example, you want to track orders by delivery. You create a check box custom field called Delivery that appears on sales transactions. If orders are for delivery, you check the Delivery box.

Currency

Enter currency amounts in a custom field (maximum 15 digits and 15 decimal points – 999,999,999,999,999.999999999999999)

A custom field of type currency behaves differently from standard NetSuite currency fields. That is, if you are not using the Multi-currency feature, the custom field will not be hidden like standard NetSuite currency fields.

For example, you want to track the spending limit of each employee in your company. You create a currency custom field that appears on employee records and enter the spending limit for each employee.

Date

Enter or select dates.

Note that changing Date fields to Date/Time fields will automatically convert Dates in existing records to Date/Times. The time value defaults to midnight of your company's time zone. All existing SuiteScript that referenced the Date field must manually updated.

For example, you want to record projected start dates on estimates. You create a date custom field called Projected Start Date. Dates entered must follow the date format selected at Setup > Company > General Preferences.

Date/Time

Combine date and time values in one field.

After you enter a date/time value, the data is rendered in the user’s preferred date and time format, as well as the user’s time zone.

Also note that time values are stored in NetSuite down to the second.

Optionally, you can also add Date/Time custom fields in SuiteScript using the form.addField(options) method. Important: If you use the addField method, for the type parameter, you must specify 'datetimetz'.

For example, you may want a single field to contain date and time timestamp data.

Decimal Number

Enter a decimal number in a custom field. The largest number you can input is 10,000,000,000,000,000,000 (maximum 20 digits). If you enter a number larger than this, it will be automatically rounded down to the maximum number permitted.

For example, you want to record the distance your customers are from your nearest retail outlet. You create a decimal number custom field to store the information in your employee records.

Document

Select a File Cabinet document to preview or download. The field is searchable and can be added to search results.

Note: The user of the document custom field must have File Cabinet access to view, select, or upload documents.

For example, you want employees to be able to search customer survey results.

Entity

You can create custom fields of type Entity. To create a custom entity field, set the field type to List/Record, and set the List/Record type to Entity. By doing so the new generic custom entity field will automatically include all records of type contact, customer, employee, group, other name, partner, and vendor.

You can then optionally use sourcing and filtering capabilities to limit the choices in the custom field's list to a subset of the supported entities.

For example, on the custom field's definition page, on the Sourcing & Filtering subtab, specify Type in the Filter Using column. In the Value Is column, specify customer, partner, and vendor names.

When the custom field of type Entity appears on your record, entities of only type customer, partner, and vendor will appear as available options in the field's list.

Email Address

Enter an email address in a custom field (maximum 254 characters). The email address field creates a link to open your default email client.

For example, you create a custom record type for intern records. You can include a field for their email addresses. You can send email to interns by clicking email addresses on their records.

Free-Form Text

Enter up to 300 characters of text in a custom field.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, you want to offer your customers monogramming on certain items. You can create a Free-Form Text field as an item option to record the monogram they want.

Help

Place helpful text on record pages where your users enter information (maximum 999 characters). The help that appears is for informational purposes only. It is not stored in your account.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

When you create a Help custom field, select Help in the Type field and enter your text in the Help field.

Hyperlink

Enter a URL in a custom field that links to another web page (maximum 999 characters, with a hyperlink text limit of 10 characters).

Hyperlink fields should begin with http://, https:// or ftp:// .

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, you want to link to a vendor's website. You create a hyperlink custom field called Website that appears on vendor records. First, you enter the company's URL. When you return to the vendor's record, you can click the URL to open the vendor's site in a new window. You can enter up to 999 characters in the field.

Image

Attach an image to a record. The image is rendered with a maximum width of 250 pixels in the form layout, and the image is resized proportionally.

Image custom fields support the following file formats:

• .bmp

• .gif

• .jpg

• .jpeg

• .pjpg

• .pjpeg

• .png

• .tiff

• .tif

For example, you can attach pictures of your employees to their records.

Inline HTML

Inline HTML can be used on all types of fields. Use HTML, for example, to define a custom field on a record form, or to define a custom field to be included on custom pages generated by Suitelets. For more information about using HTML with Suitelets, see SuiteScript 2.x Suitelet Script Type.

The field limit of the Inline HTML Field Type is 4000 bytes. In English, 4000 bytes is 4000 characters, but in other languages, the number of characters may be fewer.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, you could display to customers how many reward points they have earned.

Integer Number

Enter integers in a custom field. The maximum number is approximately 18000000000000000000 (20 digits). This maximum can be affected by automatic rounding and limitations of underlying technologies.

For example, you can record a special ID number on your company records.

List/Record

Attach lists and records to custom fields. In the List/Record field, select the list or record type you want to attach. You can also select from a list of public saved searches.

You can also use the list/record option to script a custom printing solution. For more information, see Scripting a Custom Printing Solution.

For example, you want to track orders by the employee who works on them. You create a custom body field for sales transactions. In the List/Record field, you attach your employee list. On sales transactions, you can then select the appropriate employee for the order.

Long Text

A text area that can hold up to 1,000,000 characters. Use Long Text custom fields where you need greater than 4,000 characters of text for a text area, and where you do not want the field to contain rich text formatting.

When you create a long text field type in the UI, the field character limit is 1,000,000. When you create a long text field type using SuiteScript, the field character limit is 100,000.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, use a Long Text custom field in a custom record to hold the text of an item Warranty. Or, add to an Online Form to hold the text of a End User License Agreement.

Multiple Select

Lets you create a field where you can make multiple selections from a list or list of records.

For example, you want to track how customers heard about your business. You create a multiple select custom field that appears on customer records and contains a list of possible sources. Sales representatives use the field to select the various places customers heard about your business.

Password

Lets you create a field that is encrypted in the database (maximum 15 characters). When you view the record it will always show a fixed number of characters regardless of how long the password is. When validating, you pull the encrypted password value into a hidden field and use custom code to encrypt the value the user typed and compare it with the real encrypted value. Ensure that customizations do not improperly use sensitive fields.

For example, you could add a password custom field to a web page.

Percent

Lets you create a field to store a percentage. The information entered in the field can be only an integer from 0 to 100.

For example, you want to track the test results of a training course taken by an employee, and have the result display as a percentage. The percent sign (%) is automatically added to the number.

Phone Number

Lets you create a field for a telephone number on records and transactions (maximum 32 characters).

If the phone number formatting feature is enabled in your account, phone numbers are localized. The Country field in the subsidiary of the user determines the localization applied.

For example, you can include a contact number on an event record using a CRM field.

Rich Text

Lets you enter and format up to 1,000,000 characters of text in a custom field.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, you can include a small biography of your employees with information like marital status, family members and other special information. You can also format the text to create lists, make text bold or italic, and change the font size and color.

Text Area

Lets you enter up to 4,000 characters of text in a custom field.

The field limit of the Text Area Field Type is 4000 bytes. In English, 4000 bytes is 4000 characters, but in other languages, the number of characters may be fewer.

URLs in custom fields should use your account-specific domain. For more information, see Using Account-Specific Domains.

For example, you want to record special information about how you closed a customer. You could enter it into a text area custom field that appears on customer records.

Time of Day

Lets you enter the time of day in a custom field.

For example, you create a Best Time To Call custom field for your sales representatives to enter the best time of day to call a prospect.

URL Fragment

Lets you enter the URL Fragment in a custom field.

For example, you use the URL Fragment custom filed to create an exact text reference across the web.