TITAN CMS - Add Data Table & Columns

The Table will consist of the Columns and Lookups configured in this section.  Version 6.6 column names were updated. 

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.  With the Relationship enhancement, any valid column that you desire to use in relationship should have checkbox checked.   When making any changes to columns and tables, add new template that is used through blocks to present your information.  Contact your account director/design team for custom display.

 

Please wait while we gather your results.

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

Text (1 line) Column

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

Read More...

Number (Decimal/Currency) Column

The Number (Decimal/Currency) column type may be used to implement cost, price, amounts, etc.

Read More...

Text (Area) Column

The Text (Area) 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 Key Column

The External 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...

Raw XML Column

The Raw XML column type may be used to implement xml.

Read More...

File (single) Column

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

Read More...

Number (Integer)

The Number (Integer) column type may be used to implement quantity, whole number cost, etc.

Read More...

File (multiple) Column

The File (multiple) 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 Column

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

Read More...

Links Column

The Links 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...

How Proximity Filter Works

Information discussed with a client on how the Proximity Filter works.

Read More...

Checkbox

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

Read More...

Date Column

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

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...

Date and Time Column

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

Read More...

Quick Data Columns Chart

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

Read More...

Date and Time with Recurrence Column

The 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...

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 Text (1 line)
Page URL Text (1 line)
Start Date Date
End Date *v6.3 Date
Page Title Text (1 line)
Metatag Keywords Text (1 line) & Text (Area)
Metadata Description Text (Area) or Freeform
Short Teaser Text (Area) or Freeform
Long Teaser Text (Area) or Freeform
Teaser Image File (single)
Teaser Image Alt Text *v6.3 Text (1 line)
Show in What's New *v6.3 Checkbox
What's New End Date *v6.3 Date
Workstation Name Text (1 line)
Credited Author Text (1 line)
Display Order Text (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 titles changed in the v6.6 release.

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
Text (1 line) Yes Yes (future) Yes Yes N/A Yes *Textual N/A Yes Yes Yes Yes
Text (Area) N/A N/A No Yes N/A N/A N/A Yes Yes Yes Yes
External Key N/A N/A Yes Yes N/A N/A N/A Yes Yes Yes Yes
File (single) N/A N/A No N/A N/A N/A N/A Yes Yes Yes N/A
Files (multiple) N/A N/A No N/A N/A N/A N/A Yes Yes Yes N/A
Freeform 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
Date Yes Yes (future) No N/A N/A Yes  Yes Yes Yes Yes Yes
Date and Time Yes Yes (future) No N/A N/A Yes  Yes Yes Yes Yes Yes
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
Number (Decimal/ Currency) Yes Yes (future) No N/A N/A Yes  *Numerical  N/A Yes Yes Yes Yes
 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 *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
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

Number (Integer) *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