Column Settings
This section of the configuration allows you to configure how to display, sort and process the columns in the FSDL.
Each column that is referenced from the data source can have its own configuration. Not every column from the data source needs a configuration, but creating a column configuration is required to do the following:
- Displaying the column in the data list.
- Filtering on the column, whether it is displayed or not. This does not include searching.
Columns will appear in the data list according to the order in which they are configured in Cascade, not the order in the data source (i.e. Google Sheets).
Columns
You can add settings for one or more columns in this section. To add more than one column, you need to click the green + icon next to the Columns heading.
Google Sheet Index
This number represents the columns index in the Google Spreadsheet. The first column is always index 0 and it counts up from there.
Example: Column A would be an index of 0, while Column B would be an index of 1, etc.
Field Type
NumericDefault Value
(Empty)Display Types Supported
Sortable
If set to Yes, a user will be able to sort the results within this column. After selecting Yes, additional sorting options will show in Cascade.
Field Type
Yes/No SelectorDefault Value
NoDisplay Types Supported
Sort Options
If a column is set to sortable, additional sort options will appear for that column.
Default Sort Column
If set to Yes, the results will be sorted by this column when the data list first loads on the page. If set to No, the results will not be sorted.
Field Type
Yes/No SelectorDefault Value
NoDisplay Types Supported
Default Sort Direction
If the Default Sort Column option is set to Yes, this field will appear. This sets the direction with which column will be sorted: ascending or descending,
Field Type
DropdownDefault Value
AscendingDisplay Types Supported
Data Value Type
This drop down indicates what kind of data the column contains. This value (and some of other values) determines how the column is displayed and sorted. The currently supported data types are:
| Data Type | How it is Displayed | How it is Sorted |
|---|---|---|
| Boolean | This will display specific text depending on whether the column value is True or False. The specific text that is displayed is configured in the Data Value Type Format. | If the column is sortable it will be sorted alphabetically by the displayed text. |
| Date / Date Range | This will display a date. The details of how the date is displayed are based on the value of the Data Value Type Format. | See the Data Value Type Format for details on how dates are sorted. |
| This creates a link to the email address. If there is a linked column it will use that columns value as the text for the link, otherwise it just uses the email address as the text. |
If the column is sortable it will be sorted by the displayed text of the link. | |
| Image | This will display an image. It creates an HTML image element with the src equal to the value in column of the data source. If the value has a pipe at the end followed by some text. The text after the pipe is taken as the alt text for the image. If no alt text is defined, then the alt text defaults to the column heading. | If the column is sortable it will be sorted alphabetically by the alt text. |
| Number / Number Range | This will display a formatted number. The specifics of how the number is displayed is based on the value of the Data Value Type Format. | If this column is sortable, it will be sorted numerically. |
| String | This will display the column value exactly as it appears in the data source. | If the column is sortable it will be sorted alphabetically by the displayed text. |
| URL | This will display a link. It creates an html link element where the href equals the value in the column of the data source. If there is a linked column, it will use that column's value as the display text for the link, otherwise it just uses the URL as the text. | If the column is sortable it will be sorted alphabetically by the text of the link. |
Field Type
DropdownDefault Value
StringDisplay Types Supported
Data Value Type Format
This field is used for specific Data Types to determine how to process that column's values in the data list. The Data Types that use this field are listed below:
| Data Type | What is Changed | How is it Sorted |
|---|---|---|
| Boolean | This type expects the data value type format field to be set as follows: True_Text|False_Text Where the True_Text is replaced with what you want displayed when the value is true, and the False_Text is what you want to display when the value is false. If no data type format is specified it will display the text True and False respectively. |
Sets the sort value to the all lowercase version of the display value. |
| Date / Date Range | Reads the data value type format field to determine how to format the date. If the parse value checkbox is checked, the column value is what is displayed. If the parse value checkbox is unchecked, then the column value is treated as the number of seconds since the epoch and uses the data type format field on how to format the date for display. Formatting rules can be found here: https://github.com/taylorhakes/fecha |
If the parse value checkbox is checked, the tool will attempt to sort the column based on the number of seconds since the epoch by using the data type format field. Otherwise, the raw column value is used. |
| Number / Number Range | Reads the data value type format field to determine how to format the number. The number formatting rules can be found here https://github.com/Mottie/javascript-number-formatter. If the number range type is chosen and there is a linked column. When displaying the tool will use a hyphen instead of a comma to indicate range rather than a list. Example 1 - 5 as opposed to 1, 5 |
Sets the sort value to the raw value parsed as a number. |
Field Type
TextboxDefault Value
(Empty)Display Types Supported
Parse Data Value
If checked, this column uses the data value type format fields text and parses the columns value into another value. If not checked, the data value type format fields text will be used to change how the columns value is displayed.
Field Type
checkboxDefault Value
Unchecked (False)Display Types Supported
Display Format
This options provides addition control over how column data is displayed in the data list. The field accepts HTML that you can place around tokens such as {SELF} or {0}. The {SELF} format token designates where the original column value will be placed in the formatted string. It also supports formatting tokens for any linked columns {#} where # is a positive number starting at 0. This corresponds to the linked column list where the first linked column is 0, the next 1 and so on.
Field Type
TextboxDefault Value
(Empty)Display Types Supported
Linked Colulmns
Linking columns allows you to connect data from other column configurations into a single column in the data list.
To link another column to this one, use the index of the other column configuration. The index of the first column configuration is 0. If more than one column is being linked separate them with commas.
Linked columns are displayed together in the order that they are linked. Linked values are comma separated when displaying, unless there is a Display Format set.