# Columns

## Column Class

| Property | Type               | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| -------- | ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DataType | string             | The data type for the column.  Standard values include `string`, `number`, `boolean`, `guid`, `html`.  Depending on the data service, this may also be a custom value.                                                                                                                                                                                                                                                                                                      |
| Format   | string \| function | The formatting to be used for values in the column.  Valid values are *C\[N]*, *P\[N]*, *N\[N]* where *\[N]* is the number of decimal places. Use `C` for currency, `P` for percentage, and `N` to use numeric thousands separators.  A custom function can also be used to format values.  Visit [Working with DataTables Select and Calculate](https://docs.wirebootstrap.com/wirebootstrap/working-with-datatables/select-and-calculate#number-formatting) for examples. |
| Name     | string             | The system name of the column.  This is often times the name of the source field used in the data service.                                                                                                                                                                                                                                                                                                                                                                  |
| Title    | string             | The descriptive name of the column.  This will often times be used as the label for values in UI components.                                                                                                                                                                                                                                                                                                                                                                |

## Column Methods

| Name                           | Description                                                                                                                                        |
| ------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| columnNameArray                | Returns an array of the `Name` for each column in a data table.                                                                                    |
| columnTitleArray               | Returns an array of the `Title` for each column in a data table.                                                                                   |
| getColumn(name)                | Returns the column with the column `name`.                                                                                                         |
| removeColumn(name)             | Removes the column `name` from a data table.                                                                                                       |
| renameColumn(oldName, newName) | Changes the name of the column from  `oldName` to `newName`.  This will also change the property with the same name on all rows in the data table. |

## AddColumn Methods

Use the following methods with the `addColumn` method to create a new column.

| Name            | Description                                                                                                                                                                                                                                                                                                                |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| addColumn(name) | Adds a new column with the `Name` property set to `name`.                                                                                                                                                                                                                                                                  |
| calc            | Creates the new column as a calculated column.  Note, as new rows are added or removed, this calculation will be dynamically re-applied.  Visit [Working with DataTables Select and Calculate](https://docs.wirebootstrap.com/wirebootstrap/working-with-datatables/select-and-calculate#calculated-columns) for examples. |
| format(format)  | Format the new column using the specification in `format`.  This can also be a custom function.  See the [Format](#column-class) property of the Column class above for details.                                                                                                                                           |
| index           | Creates a calculated column that sets each row to the index position of the row within all rows in the data table.  Note, as new rows are added or removed, this calculation will be dynamically re-applied.                                                                                                               |
| title(title)    | Sets the `Title` property of the new column.                                                                                                                                                                                                                                                                               |
| type(type)      | Sets the `DataType` property of the new column.                                                                                                                                                                                                                                                                            |
| value(value)    | Sets the value for all rows in the data table to  `value` for the new column.                                                                                                                                                                                                                                              |

The following creates a new column on a data table called`emp_position` with a display title of `Position`.

```javascript
...

table.addColumn("emp_position").title("Position");
```

Visit [Working with DataTables Columns](https://docs.wirebootstrap.com/wirebootstrap/working-with-datatables/columns) for detailed examples of using column data table methods.