Add a new field to a table

Administrators can add new fields to a table to store and display data.

Before you begin

Role required: admin

About this task

Warning: Do not add more than 10 medium-length or longer String fields to a single table. Attempting to save a large number of characters in 11 or more String fields can result in the following error: Syntax Error or Access Rule Violation detected by database (Row size too large (> 8126).

Procedure

  1. Navigate to any form.
  2. Right-click the form header and select Configure > Form Layout.
  3. In the Create new field section, fill in the following fields:
    OptionDescription
    Name Enter the name of the field as you want it to appear on forms and lists.
    Database column name Enter the database name for the field.
    Type Select a field type.
    Field length Select a field length. This field is visible only for certain field types.
  4. Click Add.
  5. Use the slushbucket to place the field in the desired location on the form.
  6. Click Save.
    The field now appears on the form in the designated location.