In addition to importing data from an existing Data Table, you can also start with a blank Data Table and configure it from scratch, writing the required data manually.

Step 1: Click “New Data Table”

Step 2: Specify the group and name

Give your table a name describing the information that it contains, for example, 2016 Global Sales, and enter the group name, if your table belongs to a group. For example, the Northwind group can contain such tables as NorthwindCustomers, NorthwindOrders, etc.

Step 3: Define table fields

Next, fill in your field names. These are your column headers.

You then need to select which data types the fields will contain, for Worksheet Systems to understand how to manipulate the data. You can choose from the following data types:

  • Short Text: Text up to 250 characters.
  • Auto Number: This data type is reserved for Key Fields. With each new row, a number is automatically generated in this field. A Key Field is a column where each entry is unique. This ensures that each single row in your data table is unique, and that the data is not repeated.
  • Long Text: Text up to 4,000 characters
  • Float Number: e.g. 1,234.21
  • Whole Number: e.g. 123
  • True/False
  • Date Time

You also need to select a key field by using the checkboxes to the left of your field information. This is a unique field – a column where every entry is unique. Having a unique field ensures that every single row in your data table is unique, and the data is not repeated.

If needed, double-click a blank row at the bottom to add more rows to your table structure and fill them with data.

Step 4: Save your data table

When you are ready with the settings, click Save. As a result, a link to your table will appear under Data Tables in the panel on the left. Click this link to view and modify your table.