Creating Tables

Tables are used to define the data that you would like to store in your Projects. You can create new Tables and amend existing Tables at any time.

Tables can be created in Gridfox using either the Screen Editor or the Explorer. Both methods are described below.

Once you have created a Table, you can add Fields to it.

Creating a Table using the Screen Editor

TIP

The Screen Editor allows you to make quick changes to your Project configuration and your Screen layouts.

To create a new Table using the Screen Editor, when you are viewing your Project, click Edit this Screen in the bottom left hand corner.

Click Add New Screen and select Table. For more information about the other options, see the Screens documentation.

Enter a name for your Table and click Add.

Create Table Screen Editor

Fields can be now be added to the newly created Table. Click into the Table to add a new Field.

Add in more Fields as you require. For more information on creating Fields, see the Creating Fields help documentation.

Once you are happy with the Table, click Save in the bottom right hand corner.

NOTE

If you haven’t specified one of the Fields in the Table to be the Reference Field then saving the new Table will prompt you to do this.

Adding Fields to Table Screen Editor

Users in your Project can now add Records to the Table. You can amend your Table further by renaming it, or adding and changing Fields.

Creating a Table using the Explorer

TIP

The Explorer allows you to see and manage all the Tables in your Project.

To create a new Table using the Explorer, start by clicking the Explorer tab in the top right hand corner of your Project.

Explorer Tab

Click Add Table, enter a name for the Table, and then click the Next Arrow.

TIP

Alternatively, you can use the Add New Table button in the left hand sidebar.

Add New Table in Explorer

Fields can now be added to the newly created Table. Click the plus icon in the Table header to add new Fields. For more information on creating Fields, see the Creating Fields help documentation.

Once you are happy with the Table, click Save in the top right hand corner..

NOTE

If you haven’t specified one of the Fields in the Table to be the Reference Field then saving the new Table will prompt you to do this.

Create Table with Fields

Users in your Project can now add Records to the Table. You can amend your Table further by renaming it, or adding and changing Fields.