LiveDataset

1. Help Center
2. Using LiveDataset
3. • LiveDataset Overview
   • Advanced
4. Add or Change Columns

Add or Change Columns

updated 3 Sep 2018

First Column

If you just created a dataset you will start in design mode with a dataset that has one column “Column 1”.

Here can you can add and change columns.

Add or Change Columns

Most configuration options are reached the same way.

1. Starting at the grid press MORE
2. Then either:
   • Modify dataset for main structural configuration options, including columns, or
   • Modify view for view-specific configuration options, including access restrictions.

To add or change columns, choose Modify dataset . On the Columns tab, you will see a list of columns for this dataset. Every column must have a name and a type.

Name	Name is shown above the column in the data grid.
Type	Specifies that the column will hold text, date, numeric… data See Column Types for the full list.

Use Edit to see additional column settings and Show for even more.

 

Some column settings are specific to the column type e.g. a Number column can be set to display a number of decimal places.

These are some of the main column settings:

Must be unique	Each entry in the column must be unique. Duplicate values are not allowed.
Default Value	The default value will be used in new rows unless overwritten.
Required	Blank entries cannot be saved. A value must be entered.
Must be valid	This will only allow valid entries to be saved e.g. entries must be part of a list.
Width	Column width in pixels.

 

See using modify dataset for full information on how to configure a dataset.