--- schema_version: "1" id: 43ca5bddab75be060d3964db88588f686d570afd4ad5015a2821bc1b59b01524 title: Edit Columns in a Data Table collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/siteforce_data_table_column.md canonical_url: https://help.salesforce.com/s/articleView?id=platform.siteforce_data_table_column.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 8bb76f12f4d696a605d2c77a43ee189b807b9fd9c6507c34561ba38cdeaa1229 description: 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. products: - Salesforce Platform - Security release: "264" --- # Edit Columns in a Data Table 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](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_repeater_examples.htm&release=264.0.0&type=5 "When working with data repeaters, data tables, and data functions, you can filter the data you retrieve in many ways. In this topic, we explore two options— fixed values and URL query strings—to illustrate some common filtering techniques."). To edit a column: 1. Double-click the column cell in the data table. 2. Select the field to display. To [customize how the field's data is displayed](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_merge_fields.htm&release=264.0.0&type=5 "Site.com uses expression language to display data dynamically. Expressions serve as placeholders for data that is replaced with information when the page loads. When working with data-bound page elements or custom widget properties, you can use expressions to customize how data is displayed on the page."), click **Customize**. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png) Note The object's fields are listed first, followed by the fields of all [parent objects](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_nested_overview.htm&release=264.0.0&type=5 "Standard and custom objects have relationships that define how records in one object relate to records in another. For example, the Accounts object has a one-to-many relationship with the Contacts object—that is, each account can have one or more contacts associated with it. This relationship is also known as a parent-to-child or a master-detail relationship."), which use the format parent\_object\_name.field\_name. 3. 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.
4. To create a hyperlink, select Add a hyperlink. Otherwise, go to step 8. 5. 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.
6. 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. 7. 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. | 8. Click **Save**. The column is displayed on the page as an expression. To test the output, [preview the page](https://help.salesforce.com/s/articleView?id=platform.siteforce_preview.htm&release=264.0.0&type=5 "Contributors, designers, and site administrators can preview site pages to see how they look when rendered in a browser window. It's always a good idea to make sure your changes are displayed correctly, as this preview is how the pages appear on the live site."). To change the name of a column, select the column cell and update the name in the Column Heading field of the Properties pane. #### See Also - [Dynamically Retrieve Data with Data Tables](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_table.htm&release=264.0.0&type=5 "Use a data table to connect to a standard or custom Salesforce object, retrieve a dataset based on the filter criteria that you specify, and display one or more record as rows in the table.") - [Site.com Data Services Overview](https://help.salesforce.com/s/articleView?id=platform.siteforce_data_overview.htm&release=264.0.0&type=5 "Site.com data services combine many features that let you connect to standard and custom Salesforce objects. Retrieve data from your organization's objects and dynamically display it on your site pages, or alternatively, gather and submit data from your customers. And when you update data in your Salesforce object, the changes are reflected automatically on the live site—no site updates required!")