|
Compatibility
|
- Runs on any computer using one of the following Web browsers:
Internet Explorer 6 or higher, Firefox, Mozilla, Safari, Opera
- Support for Safari Mobile on iPhone/iPod Touch
|
|
Collaboration
|
Multiple users
- Separate login
- Simple administration
- Four levels of access (Read/write/build, Read/write, Read-only, Pages-only)
|
Public access
- Control public access to data exports
- Share data on web pages with permanent, bookmarkable URLs
- Build forms to collect data from the public
|
Tracking
- All changes tracked by user
- Add columns to show date last modified and user who last modified
- Master transaction log with subscription feed
|
|
|
Data types
|
Text
- Single- or multi-line
- Mailing address with map link
- Email address
- Web address, including inline images
- Phone numbers
|
Numeric
- Optional fixed decimal places
- Durations
- Monetary currency with dynamic exchange rates
|
Geographical location
- Regional and national grouping
- Color-coded maps based on numeric data
- Link to street maps
|
|
Date and time
- Understands informal language like “next Wednesday at 9” and “last month”
- Ranges over hours or days
|
Choice
- User-defined options
- Drop-down menu
- Radio buttons
- Check boxes
|
Link to other entries (relational joins)
- One-to-one, one-to-many and many-to-many
- Automatic inverse relationships
- No need for keys
|
|
Users
- Link users to entries in the database
- Track ownership
- Allow user to edit only his/her entries
|
Attachments
- Upload and store files like documents, PDFs, images, etc.
- Images are shown inline, and thumbnails are created automatically
|
|
|
Data structure
|
- Flexible category system which allows data to be organized freely
- Individual fields belong to category
- Entries can be in multiple categories
- Intelligent linking (relational joins) between tables and entries including automatic inverse relationships
|
|
Data conversion
|
- Intelligent conversion between data types at any time, including migration of text lists to separate entries
- Merge and split fields: text with text, links with links, and durations with durations and dates
|
|
Reports and views
|
Table
- Add/remove any column
- Sort by any column
- Multi-level grouping
- Subtotals (SUM, AVG, MED, MAX, MIN)
- Multi-column formulas (+ − × ÷)
- Derive data from linked entries (“portal” fields)
- Last modified (date/user)
- Edit data in columns
|
Compact
- Summarize grouped data
- Subtotals
- Pivot groups between horizontal and vertical
|
Chart and Map
- One-click to create
- Line charts, bar charts, pie charts
- Single and multi-series data
- Map numeric data by region, country or continent
|
Calendar
- Fully-integrated and generated from date and time data
- Daily, weekly or monthly views
- User-defined workday
|
|
|
Input and imports
|
- Comma (CSV) or tab-separated values
- Direct from web page or RSS feed
|
- Easy-to-use form-based editor
- Drag-and-drop form builder to collect data from others
|
|
|
Output and exports
|
Publish data
- Bookmarkable web page and PDF
|
Export data
|
Subscription and integration
- RSS
- JSON
- ICAL for calendar data
- KML for geographic data
|
|
|
Application integration
|
- JavaScript API based on JSON schema which allows external data output
- Embed dynamic pages with data views and/or forms into a web site
|
