Define the Fields in your Online Database

Creating a Custom Database

Defining your Custom Web Database

  1. Design the database 'table'
  2. Create the fields to be used in the table
  3. Define what will be included in the summary view
  4. Define what will be included in the expanded view
  5. Define other custom views as desired

User Guide for the Full Custom Database Editor

PDFDatabase Editor GuideAPRIL.pdf

Design the Database

A database is made up of one or more 'data tables.' The first thing you should do is layout the primary database table -- fields, field types, column labels and so forth -- on paper to be sure you understand how the database will look and work. Deciding on paper what the Add/Edit pop up will look like, as well as, the Summary, Expanded and Custom views makes it easier to build the final database table definition. This step will save a lot of time later on.

Create the Fields in a Database

The next step is to list all the fields that will be included in this database table. These fields will show on the Entry/Edit pop up. The labels you provide will be visible on the Entry/Edit pop up. It is recommended that you enter the fields in the order you want them to appear.

Each field must be given a 'label' and the attributes defined. For example, you may have a field called Order Date. The field name in the table will be orderdate, the label will then be Order Date. You will then define the attributes. For example is this a required field; is this field a Date, Alpha or Numeric; and where will this field show on the pop up used to add a new record to the database.

Once you have defined all the fields and how they look to the end users, you then define the different views: Summary, Expanded, and any Custom views.

Define the Summary View

Not every field needs to be visible on the Summary View. Click on the Summary View link. Reference your 'Design' paper. Click on any field you don't want to show in the Summary View and click on the Delete From View button. You will do this for all the fields you want to delete from the Summary View.

All the fields you want visible on the Summary View must then be given a Label (yes again); and identified as a Link field, or not. Link fields allow the end user to open the record by clicking on the field name (only required fields can be Link Fields). Then Save the field information by click on Save Field Options.

Then position the field in the order you want to see in the Summary View by clicking the the radio button next to the field and moving it up or down. You will need to Save the field and then again at the View level.

Next you will define the Expanded View fields.

Define the Expanded View

The Expanded View will most likely have all the fields visible. You will need to give each field a label (yes again) and decide if the field is a Edit Link; the order they are displayed and if they are indented. Fields that are indented will display under the record, not on the top line.

The process is the same as you did in the Summary: field by field. Remember to save the Field Options and save the View.

Define additional custom views as desired

With GroveSite, you can define an unlimited number of Custom views as well. For example, you may have defined a table layout to track products that are in development. The first 10 fields are related to Product Design, the next 8 fields are related to Sample Requests and Status, and the final 15 fields have Shipping informatons such as carton size, container quantities and so forth. You might want to define 3 custom views: Design, Sampling, and Shipping.

Table Options

The last thing you want to do is set the Table Options. Please refer to the Custom Table Documentation PDF to understand what these options do.

Add your new database table as a page in your site

Picture DB Fields Add Page
  • Login to your site.
  • Click Turn on Edit
  • Click [new page]. The Add Page Wizard will appear. Select My Custom Database Pages and pull down the menu of database tables that have been created. Select the table you just created.