Admin - Add Column

Modules>Admin>Column>Add Column

You can add a Column to an existing database table in netFORUM provided the following conditions are met:

• If the main table is baseline, then you must add a column to an extender table.
• If the main table is custom, then you can add a column to either the main table or the extender table.
• You must use the following column naming conventions:

  • the column name must start with the table’s defined three-letter prefix, followed by an underscore.

  • if you are naming a column in the extender table, the column name must end with _ext.

 

Important! Filling out this page and clicking Save, only creates a metadata description of the new column. You must finish adding the column by going to the Edit Column page. See the full steps on this topic and the Edit Column topic for the complete set of steps.

To start the process of adding a Column, use the following steps:

1. Go to Modules>Admin>Column>Add Column. The Add - Column page opens.
2. Use the descriptions in the table below to enter information:

   Fields	Required	Description
   column name	Required	Enter the actual name of the column in the database table.
   table name	Required	Enter the virtual name of the Table this column is linked to. Columns in an Extender Table will link to the main table here.
   actual table name	Required	Enter the true name of the database table this column exists in. Example, co_individual_ext for an individual extender column.
   column description	Optional	Enter the friendly column name. Defaults from SQL column description. If you want to change the description, you may edit this in netFORUM and netFORUM will update the SQL column definition in the database. The converse is not true - if you update the column definition in SQL, it will not update the description in netFORUM. Also, if you have added this column as a Form Control on any Forms, the description will not update on the control labels -- you must manually do this one by one
   list header	Optional	Enter a different description to override List Result headers.
   control class	Optional	Select the visual depiction of the column from the drop down list.
   input mask	Optional	TBD
   data type	Optional	Select the SQL Data Type from the drop down list. Most netFORUM columns are a user-defined datatype.
   display width	Required	Enter the column display width. This value can be shorter than maximum length.
   maximum length	Required	Enter the actual column width. A nvarchar(40) column will hold 40 in this field.
   order	Optional	Enter the number for the sort order when columns appear in a DropDownList, e.g. in the Query page.
   default value	Required	Enter a default value. You can use Parsed Values. If you create a non-nullable column, then the default value is required.

   Column Properties	Optional	Use the checkboxes to apply column properties.
   DropDownList Configuration	Optional	For columns with the control class set to DropDownList, use the fields in this section to enter configuration information.

3. Note the actual table name for future reference.
4. Click Save to save the new column and go to the page you were on previously. Click Cancel to return to the previous page without saving your changes.
5. To complete adding a table, you must go to the Edit Column page.
6. Go to Admin > Find Column, type the actual table name in the field, and click Go. The Edit Column page for the newly added column opens.
7. See the Edit Column topic, step six, for the details on adding a physical column.