TITAN CMS - Add Data Table & Columns

The Table will consist of the Columns and Lookups configured in this section.  Version 6.5 and prior use these column names.

The Table will consist of the Columns and Lookups configured in this section.  After adding your Table, expand the Table on right and start adding columns.  

Hints for your Table Columns:

The Data Table and the data file must be configured with a column for the primary Name of the data record. We recommend using a column that is linked to either the "Workstation Name" or "Page Name" property. If not linking to an existing property, any column with a Data Upload Heading - Data Upload Heading containing the word "Name" will suffice.

 

Please wait while we gather your results.

Working with Columns & Lookups & Templates & Relationships.....

Basic text input (1 line) Column

The Basic text input (1 line) column type may be used for names, short description, etc.

Read More...

Input for Decimal/Currency Column

The Input for Decimal/Currency column type may be used to implement cost, price, amounts, etc.

Read More...

Basic text input (large) Column

The Basic text input (large) column type may be used as a larger input field, descriptions, etc.

Read More...

Add Templates

Templates are used with the Data Detail, Data List, Data Editor and Data Filter type in the Segmented Search block.

Read More...

External Data Source Key Column

The External Data Source Key column type may be used for matching another external source data input from another system. This column type will default the column linking to Own Column.

Read More...

Input for raw XML Column

The Input for raw XML column type may be used to implement xml.

Read More...

File (single selection) Column

The File (single selection) column type may be used for a single image display

Read More...

Input for Whole Numbers

The Input for Whole Numbers column type may be used to implement quantity, whole number cost, etc.

Read More...

Files (multiple related) Column

The Files (multiple related) column type may be used for multiple files and images.

Read More...

Add Relationships

v6.8 Relationship able to be defined with one table or between two tables. v6.6 & v6.7 Relationships allow you to define how content from two Data Tables under 1 Schema are related. Content is related by establishing links, correlating data values, or using Tags and Lookups. Relationships are used by the Data Detail block to combine content from the related Tables and display it on a single page.

Read More...

Freeform Editor Column

The Freeform Editor column type may be used as a larger input field that uses wysiwyg options, etc.

Read More...

Links (related content) Column

The Links (related content) column type may be used to link to internal, external, email or files.

Read More...

Geographic Coordinate Column

The Geographic Coordinate column type may be used to implement Latitude and Longitude inputs which may be used with the Proximity Filter in the Data List block.

Read More...

Lookup Column

The Lookup column type may be used for a list of options.

Read More...

Input for a Date Column

The Input for a Date column type may be used to implement to a date field.

Read More...

One Checkbox

The One Checkbox column type may be used for gathering information, or as a preselected option already checked, etc.

Read More...

Input for a Date and Time Column

The Input for a Date and Time column type may be used to implement a date and time.

Read More...

Radio buttons Column

The Radio buttons column type may be used to provide a rating option & offer options to select from, etc.

Read More...

Input for a Date and Time with Recurrence Column

The Input for a Date and Time with Recurrence column type may be used to implement a date and time and recurrence of dates - Daily, Weekly, Monthly and Yearly and display through the Data List's Calendar Filter .

Read More...

Quick Data Columns Chart

Details for buidling Data Schema, Table and Column linking to property recommendations.

Read More...

Sample XML of Recurrence

This is a sample of XML of Recurrence entry from the Input from Date and Time with Recurrence column.

Read More...

Details:

Type
Maximum  Input
Minimum Input
Data Schema 99 1
Table Name 50 1
Table Description 255  
Data Control Type Name 50 1
Data Control Type Description 255  
Control Type Data Upload Heading Unlimited  
Control Type Label Unlimited  
Control Type Title Unlimited  
Lookup Name 99 1
Lookup Help Text 500  
Parameter Name 50  
Parameter Default Value Unlimited  
Parameter Value Choices: (separated with a comma) Unlimited  
Parameter Help Text 500  

 

Recommendations for Property to Column Linking:

*Property Type
Column
Page Name Basic text input (1 line)
Page URL Basic text input (1 line)
Start Date Input for a Date
End Date *v6.3 Input for a Date
Page Title Basic text input (1 line)
Metatag Keywords Basic text input (1 line) & Basic text input (large)
Metadata Description Basic text input (large) or Freeform
Short Teaser Basic text input (large) or Freeform
Long Teaser Basic text input (large) or Freeform
Teaser Image File (single selection)
Teaser Image Alt Text *v6.3 Basic text input (1 line)
Show in What's New *v6.3 One Checkbox
What's New End Date *v6.3 Input for a Date
Workstation Name Basic text input (1 line)
Credited Author Basic text input (1 line)
Display Order Basic text input (1 line) & Add Validation Data Titan Field
Custom Nav Data 1 - 3 *Any control should work
Custom Data 1 - 5 *Any control should work

* When connected to a Titan Property, editing this field through Data List or Data Detail with Data Editor, will then edit the property it is linked to.  Four properties added in v6.3 to link to.  If field will be used to allow Range Filtering, do not link to a property, use Own Column. 

Column Types and default configuration options:

*The Sort needs to be checked if this field is desired to be sortable through the Data List block on website display.  *Exception v6.5, when the Geographic Coordinate column is built, the Distance sort automatically is listed in Data List block.

*Compare is coming in a FUTURE ENHANCEMENT.

*The Keyword Filter needs to be checked in order for that column field's input text to be searchable through Data List block on website display.

*The Category Filter Lookup needs to be checked in order to use for filtering tag/lookup through Data List block on website display.

*The Range Filter & Input for Whole Number are new for v6.3 *Column type field has to be Own Column, NOT Linked to property!

*The Range Filter (Calendar Filter) & Input for Date and Time with Recurrence new for v6.4 *Column type field is defaulted or has to be Own Column, NOT Linked to property!

*The Range Filter (User Value Filter) new for v6.7 *Column type field is defaulted or has to be Own Column, NOT Linked to property!

*The Data List & Data Detail blocks are new for v6.1

*The Proximity Filter & Geogrpahic Coordinate  are new for v6.5 *Column type field has to be Own Column, NOT Linked to property!

*The Edit/Upload is new for v6.2

*The Public Submit (Data Editor) is new in v6.3  *Column types with pop up dialogs are not supported.

*The Relationships configuration is new in v6.6 *Certain column types may be configured to be related.

*The Relationships configuration from same table is new in v6.8 *Certain column types may be configured to be related.  Lookups column type is good example.

Column Type
Sort
Compare *future
Relationships
v6.6
Keyword Filter
Category Filter Lookup
Range Filter
*v6.3, *v6.7 Own Column only
Range Filter (Calendar Filter )
*v6.4 Own Column only
List
*v6.1
Detail
*v6.1
Edit/Upload *v6.2
Public Submit *v6.3
Basic text input (1 line) Yes Yes (future) Yes Yes N/A Yes *Textual N/A Yes Yes Yes Yes
Basic text input (large) N/A N/A No Yes N/A N/A N/A Yes Yes Yes Yes
External Data Source Key N/A N/A Yes Yes N/A N/A N/A Yes Yes Yes Yes
File (single selection) N/A N/A No N/A N/A N/A N/A Yes Yes Yes N/A
Files (multiple related) N/A N/A No N/A N/A N/A N/A Yes Yes Yes N/A
Freeform Editor Yes N/A No N/A N/A N/A N/A Yes Yes Yes N/A
Geographic Coordinate *v6.5 *N/A N/A No N/A N/A N/A N/A Yes Yes Yes Yes
Input for a Date Yes Yes (future) No N/A N/A Yes  Yes Yes Yes Yes Yes
Input for a Date and Time Yes Yes (future) No N/A N/A Yes  Yes Yes Yes Yes Yes
Input for a Date and Time with Recurrence *V6.4 Yes Yes (future) No N/A N/A *Calendar Range type filter Yes Yes Yes Yes N/A
Input for Decimal / Currency Yes Yes (future) No N/A N/A Yes  *Numerical  N/A Yes Yes Yes Yes
Input for Raw XML *custom display N/A N/A No N/A N/A N/A N/A Yes Yes Yes Yes *Dropdown or Custom
Links (related content) *custom display N/A N/A Yes N/A N/A N/A N/A Yes Yes Yes N/A
Lookup N/A N/A Yes N/A Yes N/A N/A Yes Yes Yes Yes
One Checkbox *custom display Yes Yes (future) No N/A N/A N/A N/A Yes Yes Yes Yes *Custom
Radio buttons *custom display Yes Yes (future) Yes N/A N/A Yes *Textual custom N/A Yes Yes Yes

Yes *Custom

Input for Whole Number *v6.3 Yes Yes (future) Yes N/A N/A Yes *Numerical N/A Yes Yes Yes Yes

 

Titan CMS Training

Check out upcoming Titan CMS Training Classes
 

Learn at Northwoods 

Workshops
 

Titan CMS Support

(414) 914-9200
Submit Questions
 

Northwoods Web Solutions

p: (414) 914-9100