S
earch:
Getting Started
Video Tutorial
Text Tutorial: Step-by-Step
Quick-start Videos
On Premises Installation
Documentation
clearString Documentation: The neatComponents Guide
Key Concepts
Less expensive than Free
Application Development
Building & Styling Applications & Sites
Data Integration
Process Management
Site security - users and permissions
FREE Application Downloads
How-to Resources
How-To Resources
Techniques & KB Articles
E-commerce
Advertising
Voting System
Profiles
Search Engine Optimisation
Making sites Accessible
Managing discussions
Mobile Sites
Reselling sites (SaaS)
Reference
Papers and Presentations
Components Reference
Datatypes
Documentation Tree
Site Search
Upgrading
Upgrading
Upgrade Protection
Release notes
Support Services
Product Support
System Analysis & Design
Onboarding
Previous page
Data Integration
Next page
Creating and modifying Tables
For a worked example of how to create and modify a Table see a First Site:
Introduction to Tables
Managing data
Managing data
Feeds: What are Tables and Fields?
What are Queries and Views?
Data types
Primary keys
Relationships
Designing your database
Tables, Queries & Views - a simple example
Why structure data? a case study
Data Integration Overview
Tables
Tables
Data Entry mode and Edit mode
Creating and modifying Tables
Useful naming conventions
Field Editor
Data types
Record locking
Adding fields
Editing existing fields
Default values
Moderator-only fields
Security options for files and images
Referential Integrity
Field Validation
Using the contents of a field as a DirectURL
Customizing the text areas
Events - triggering emails
Specifying email criteria
Selecting recipients
Providing a valid return address
Automatic vs Custom layout
Save and Save As
Entering some initial data
Queries
Queries and Views
Selecting tables and Fields
Joining multiple tables
Designing Joins
Combining resultsets (Union queries)
Query-based Navigation
Expressions
Expressions
Expression Builder
Working with Expressions
Expressions - Function Reference
Expressions - Operators Reference
Expressions - Date Format
Views
Custom View
Field Usage options
Formatting Text fields
Formatting Image fields
Sorting results
Defining Links in fields
Ajax transitions
Paging controls
Displaying text if records exist
Regular Expressions
Embedding Views within the navigation links
Calendar View
News Tickers
External Lookup Data Feed
Data Import - XML & CSV
External Lookup Data Feed
Triggering Lookups
General Settings
Request URLs
XPath Namespaces
Fixed Request Parameters
Cache Table Field Mappings
Response Errors
Data Import component
Data Import component
Configuring the Data Import
Bulk Import
Bulk importing from CSV files
Bulk Import - Example
