A data table's columns bind to the fields of the object it's connected to. Each column cell acts as a placeholder that is replaced with the field's data when the page loads.
Required Editions
| Available in: Salesforce Classic |
|
Available for purchase in: Enterprise, Performance, and Unlimited Editions Available (with limitations) in: Developer Edition |
| User Permissions Needed | |
|---|---|
| To build, edit, and manage Site.com sites: |
Site.com Publisher User field enabled on the user detail page AND Site administrator or designer role assigned at the site level |
You can display plain text, formatted text (for dates and numbers), or images in the column cells. You can also add hyperlinks to column cells to allow site visitors to navigate to another page, such as a detailed description, or to refresh the data displayed in the data table based on their selection. See Data Filtering Examples.
To edit a column:
- Double-click the column cell in the data table.
-
Select the field to display. To customize how the field's data is displayed, click
Customize.
Note The object's fields are listed first, followed by the fields of all parent objects, which use the format parent_object_name.field_name. -
Select the display type.
Option Description Text Lets you display the field's data as plain text. Formatted text If you're working with dates, times, or currency, lets you choose from several text display formats. Image If the field contains an image URL, lets you display the field's data as an image. The URL can be absolute or relative to the site.
You can also select a field to use for the alternative text or enter custom text.
- To create a hyperlink, select Add a hyperlink. Otherwise, go to step 8.
-
Select the link type.
Option Description A URL Lets you link to a Web page by:
- Choosing a field that you want to reference, such as a field that stores the relative URLs of PDFs you uploaded to your site.
- Choosing a field that you want to reference and clicking Customize to add an absolute URL or to create a custom link, such as a URL query string.
An item in your site Lets you link to a page, image, or file in the site by selecting the item type and then selecting the item. (If you can't see the list of items, place your cursor in the URL field and press the DOWN key on your keyboard.)
You can also customize the URL—for example, by creating a URL query string.
An email Lets you link to an email message by entering the recipient's address, and the message subject and body.
You can use merge fields to access the object's fields. For example, if an object has an Email field, enter the merge field, such as {!email}, in the Email address text box.
When the link is clicked, it opens a new message window in the user's email client and adds the appropriate email address to the To: field.
-
Optionally, enter a tooltip by selecting the required field or clicking
Customize to add custom text.
The tooltip displays as a pop-up when the user hovers over the link.
-
If you're linking to a URL or an item in your site, specify where the item
opens.
Option Description Popup window Loads the item into a window. When you select this option, you can set the title for the popup and control its appearance and size with the options that appear. New window (_blank) Loads the item into a new, unnamed browser window. Same window (_self) Loads the item into the same frame or window as the link. This setting is the default. Topmost window (_top) Loads the item into the topmost parent frameset or window of the frame that contains the link. Parent window (_parent) Loads the item into the parent frameset or window of the frame that contains the link. - Click Save.
The column is displayed on the page as an expression. To test the output, preview the page.
To change the name of a column, select the column cell and update the name in the Column Heading field of the Properties pane.