Mashup Builder > Widgets > Standard Widgets > Grid Widget > Grid Column Renderers and Formats
Grid Column Renderers and Formats
Renderers allow you to format specific data types that are supported by the grid. By default, each data type is displayed according to a default configuration. To customize how data is displayed at run time, you can choose and configure a specific renderer for the chart. Renderers are available as a column configuration in the widget configuration dialog box. The following topic lists the available renderers for ThingWorx.
DEFAULT
Automatically detects the data type and formats it according to the default formatting options.
BOOLEAN
Formats true or false Boolean values. You can display Boolean data as a check box element, or plain text.
Checkbox—Displays the Boolean value using a check box.
Text—Displays the value using True or False text.
Show no text—Hides the value text.
DATETIME
Formats date and time values based on a defined format. You can select a dateTime localization token, or type a format manually.
HTML
Renders HTML code and displays it using one of the following options:
Raw (no formatting)—Displays the HTML as plain text and without any formatting.
With Formatting—Formats the HTML code using the browser.
With Formatting, Unsanitized—Formats the HTML code without any sanitization rules. Make sure HTML content that you load into the Grid is safe when you select this option.
HYPERLINK
Formats hyperlinks to URLs and Media entities. You can choose one of the following options to control how the linked URL opens:
Choose how the linked pages open.
New Page—A new browser tab.
Replace—Replaces the current page.
Within Frame—Within a contained mashup frame.
Within Window Within Frame—Within the frame of the top-level contained mashup.
Route links using an event—Triggers a LinkClicked event instead of opening the URL when a hyperlink is clicked. You can use the ClickedLinkedData infotable to pass the URL values to widgets, functions, or services in the mashup.
* 
This option is available in ThingWorx 9.3.6 or later.
Specify the text to display for links using one of following options:
Fixed—A static text that displays for all links in the column. You can define a string value or select a localization token.
Dynamic—Displays a drop-down list that enables you to select a dependent infotable field with the strings to display for each link.
IMAGE
Formats images displayed within each cell. You can control how image are scaled using the following options:
Fit the image within the cell.
Display the image using its original size.
Scale the image horizontally to cover the cell width.
Scale the image vertically to cover the cell height.
Cover the cell width.
IMAGELINK
Formats links to images displayed within each cell. In addition to options that are available for the IMAGE renderer, you display a link to the image.
INFOTABLE
Formats the data as a ThingWorx data structure used to store results of a service or a set of properties for a Thing.
INTEGER
Formats integer values according to a format string. You can type 0 to display the number without any formatting, or 0,0 to show a thousandth separator.
JSON
Formats JSON (JavaScript Object Notation) data.
LOCATION
Formats data containing latitude, longitude, and elevation coordinates using a numeric pattern. By default, a 0.0000 pattern is applied.
LONG
Formats long values according to a format string. Valid formats are: 0 and 0,0
MASHUPS
Formats references to a ThingWorx mashup.
Column Format
Select how to format the entity reference. You can show plain text or a link.
NUMBER
Formats number values, including fractions according to a format string, with optional rounding. Valid Formats Are: 0, 0.0, 0.00, and 0,000.0
PASSWORD
Applies a mask to hide the data values. Use this renderer to hide sensitive information such as passwords.
STRING
Formats text as a series of alphanumeric characters. You can:
Disable truncations.
Hide the text.
Set a display limit for 10, 20, 40, 80, 128, or 256 characters.
* 
You cannot view hidden characters at run time when you set display limits.
TAGS
Formats tags of model entities.
THINGCODE
Formats a numeric representation of a Thing, containing a Domain ID and an Instance ID.
THINGNAME, THINGSHAPENAME, and THINGTEMPLATENAME
Formats references to entity names. You can display the entity name as a plain text or a link.
USERNAME
Formats references to a ThingWorx user. Select how to format the entity reference. You can display the name as a plain text or as a link.
VALUES
Values formatter
VEC2, VEC3, and VEC4
VEC2—Formats a vector of two decimal values modeled with x and y.
VEC3—Formats a vector of three decimal values modeled with x, y, and z.
VEC4—Formats a vector of four decimal values modeled with x, y, z, and w.
XML
Displays XML data.
Was this helpful?