Column Setting - Basic Property
In the “Basic Property” tab, you can change the basic properties for columns.
[A] Header Label – Set the label to be displayed in the column header
[B] Auto-Sync Label in Column Field - For columns tied to Salesforce fields (Field Columns), set the label displayed in the column header to synchronize with the field's label definition in Salesforce. If the synchronization setting is enabled, the header label becomes non-editable and automatically reflects the field's label definition on initial loading of the sheet.
[C] Allow Wrapping - Automatically wrap the text if the length of the header label is longer than the column width
[D] Use Vertical Writing Direction - Display the header label in vertical writing direction
[E] Kind of Column – Displays the kind of column you selected when adding a column (read only). The following types are available.
Field Column – A column that is tied to a specific field of Salesforce object.
Formula Column – A column that displays the calculated result of a formula defined in the sheet. Unlike formula fields in Salesforce, it is defined in the column setting.
Data Column – A column that contains data that is only available within the sheet; it is available separately from the fields defined in Salesforce.
Matrix Column – A column to display the time-series matrix transformed data. Displays data in nested columns.
Series Column – A column that displays a group of data corresponding to each series value inside a matrix column.
[F] Column Data Type – Displays the data type of the data referenced by the column (read only). If the kind of column is Field Column, displays the data type of referencing Salesforce field. If the kind of column is Formula Column or Data Column, displays the data type you selected when adding the column.
[G] Column Name – Displays the unique column name in the sheet (read only). Used to reference the column from formula columns, JavaScript API, etc.
[H] Reference Field – If the kind of column is Field Column, displays the name and API reference name of the field. If the field is accessed through relationships, displays the path to the field with the relationship names.
[I] Display Type – Select the display type of the data. Normally, the best display format is selected according to the data type of the column. You can choose from the following types:
Text – Displays data as it is without changing the format in particular.
Rich Text – Parses HTML-tagged text and displays it in rich text.
Number – Displays data converted to numeric format. In addition you can specify "Number Format", "Digits", and "Prefix Text" / "Suffix Text".
Date/Datetime – Displays data by converting it to date / date time format. You can set "Date/Datetime Format" additionally.
Check (TRUE/FALSE) – Converts the value to a boolean value and displays it as a checkmark when it is true.
[J] Text Align – Specify the horizontal alignment of the text to display in the cell.
[K] Text Wrapping – If the text to be displayed in a cell does not fit in the width of the column, it is displayed on multiple lines. If the text contains line feeds, they are also reflected in the display.
[L] Anchor Link (URL) – If you want to set an anchor link to a cell, enter the URL of the link destination. It can include references of field values by enclosing their API reference names with
${
and}
, such as${Id}
.
By inserting a <br>
character string in the the header label text, it is possible to forcely wrap the label in new line.
If the column's display type is Rich Text, the tags that can be parsed as HTML are those that can be expressed in Salesforce's standard rich text editor. If the HTML contains tags or attributes that contain any executable scripts, those tags and attributes will be disabled.
Custom Format of Date/Datetime
When "Date/Datetime" is selected in the display type, "Date/Datetime Format" can be set. Typical date/datetime formats can be selected from the selection list, but you can input any format string by selecting “Custom”.
The following tokens can be used in the format string.
Last updated