Datastores & Data Management

Design the tables your application runs on — datastores, fifty-plus field types, custom fields and data importing.

• Datastores — Create and manage the tables your application stores data in — rows, fields, imports, soft delete and field permissions.
• Datastore Field Types — Every field type the platform offers, what each one stores, when to reach for it and when not to.
• Custom Fields — Extend a datastore with additional fields after it is built, including fields that appear only under certain conditions.
• Data Extraction — Take structured data arriving by API, e-mail or file upload, map it field by field into a destination datastore, transform it and log every run.
• External Data Sources — Connect to nine kinds of external system, map their objects onto datastores, and choose between reading live and syncing on a schedule.
• Record Links — A general relationship between any two records in any two datastores, typed and attributed, used by conversions and by anything that needs provenance.
• Record Numbering — Human-readable references built from a token format, with counters held per entity and per period so sequences reset without anybody resetting them.
• Activity Stream — A single timeline per record carrying system events, status changes, notes, calls and emails, with visibility deciding what a customer sees.
• Trash & Test Data — Recover records somebody deleted, and generate realistic sample data — with the reset that takes it away again.