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.

1

Create an entity

Describe it to the AI Builder (“track suppliers with contacts and ratings”) or add it by hand in the schema editor.

2

Add fields and relations

Pick from 25+ field types, link entities together, and add formulas or rollups for calculated values.

3

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.

entity-engine
Name ▲EmailStatusAmount ▼Created
Acme Corpjohn@acme.comActive$12,500Mar 15
Globex Incsarah@globex.comPending$8,200Mar 12
Initech LLCmike@initech.comActive$45,000Mar 8
Stark Industriespepper@stark.comInactive$3,200Mar 5
Wayne Enterprisesbruce@wayne.comActive$67,000Mar 1

The right field for every value

Pick a field type to see how it looks on a form.

Acme Corp

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

Acme Corp
VIP
$15,000
5
$3,000
$2,400,000

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.

See pricingBrowse use casesDevelopers