LiveDataset

1. Help Center
2. Advanced
3. • LiveDataset Overview
   • Using LiveDataset
4. Use System Columns

Use System Columns

updated 11 Sep 2018

Every dataset includes additional columns with data automatically added by LiveDataset.

System Column Types

Unlike regular columns you cannot directly edit data in system columns. This data is metadata i.e. data LiveDataset keeps about each entry.

Column Type	Description
Sequence Number	A unique number for each dataset entry 1, 2, 3…
Create User	The email address for the person who first created this entry.
Create Date	The date this entry was created.
Update User	The email address for the person who last updated this entry.
Update Date	The date this entry was last updated.

This data can be useful for

• Creating unique reference IDs
• Views that only show entries created / updated by the current user
• Sorting entries to show most recent ones first

How to Add System Columns

The process of adding a system column is just like adding other columns. However, behind the scenes there is a difference. The data for system columns is always present, but not displayed by default. When you add system columns to any pre-existing dataset you will see old system data is already there for old dataset entries.

To add system columns you will need account admin access, so you use can design mode.

1. Press MORE then Modify dataset
2. Select the Columns tab
3. Below any columns already there, press Add column .
4. For column type, select a System Field from the bottom of the list.
5. Use Edit and Show for additional column settings.
6. Press Save to save your changes.