Entity Engine
Model any business data, without a database
Create the records your business runs on (customers, orders, assets, tickets), link them together and add rules. Built for teams who have outgrown spreadsheets but don't want a dev project.
Why it matters
Every app you build in Scratchboard starts with entities: the tables your records live in.
Your data, shaped like your business
Customers, policies, work orders, shipments: create the exact record types you track, not a generic spreadsheet.
Everything connected
Link orders to customers and invoices to orders, then roll totals up automatically. No more copy-paste between sheets.
Change it any time
Add a field or a rule on a Tuesday afternoon. Forms, views and reports pick it up straight away, no migration project.
How it works
From idea to a working data model in minutes.
Create an entity
Describe it to the AI Builder (“track suppliers with contacts and ratings”) or add it by hand in the schema editor.
Add fields and relations
Pick from 25+ field types, link entities together, and add formulas or rollups for calculated values.
Add rules and go
Show, hide, require or lock fields based on other values. Forms and views are ready for your team immediately.
One record, many views
Every entity gets table, board, list and detail views automatically. Try switching.
| Name ▲ | Status | Amount ▼ | Created | |
|---|---|---|---|---|
| Acme Corp | john@acme.com | Active | $12,500 | Mar 15 |
| Globex Inc | sarah@globex.com | Pending | $8,200 | Mar 12 |
| Initech LLC | mike@initech.com | Active | $45,000 | Mar 8 |
| Stark Industries | pepper@stark.com | Inactive | $3,200 | Mar 5 |
| Wayne Enterprises | bruce@wayne.com | Active | $67,000 | Mar 1 |
The right field for every value
Pick a field type to see how it looks on a form.
Forms that follow your rules
Show, require, calculate or lock fields based on other values. Toggle a rule to see the form react.
Dynamic Rules
Live Form Preview
Key capabilities
Everything you need to model real business data.
25+ field types
Text, numbers, currency, dates, picklists, files, users, teams and more.
Relations
One-to-many, many-to-many and lookups, with related lists on every record.
Formulas & rollups
Calculated fields and totals rolled up from related records.
Rules
Visibility, required, read-only, validation and calculated values, enforced on save.
Record types
Different forms and picklist values for different kinds of the same record.
Import & export
Bring data in from CSV, Excel or JSON, and export it back out.
Duplicates & merge
Find likely duplicates and merge two records into one.
Activity history
Every change, note and approval on a record's timeline.
Frequently asked questions
Short answers to common questions.
What is an entity?
An entity is a type of record your business tracks, like Customers, Orders or Tickets. Think of it as a table with fields (columns), forms and views built for you.
Do I need database or SQL knowledge?
No. You create entities and fields in a visual editor or by asking the AI Builder. Scratchboard handles storage, indexes and the API for you.
Can I import my existing spreadsheets?
Yes. Import CSV, Excel or JSON files into any entity, or sync from databases, APIs and Google Sheets with Integrations.
How many entities can I create?
Starter includes 25 entities and Pro includes 50. Enterprise limits are custom. See the pricing page for details.
Can I control who sees each field?
Yes. Roles set access per entity, per record scope (all, team, own) and per field. See the Permissions page for details.
Related features
These work hand in hand with this one.
Build your first app today.
Start your 7-day free trial, or talk to us about your use case.