neatComponents: docs - Creating and modifying Tables


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