A database that follows your structure
Grids instead of scattered spreadsheets: you decide which fields exist, what type they are and how entries relate. No database knowledge, no programming.
The right type for every column
A grid is a table whose columns know what they hold. A date field knows it is a date, a select field knows its options, a file field takes photos straight from a phone. That is what makes data filterable, sortable, mappable and ready for automation.
- Type-safe — input is checked instead of landing as arbitrary text
- Automatic fields — “created by” and “created at” keep the record without anyone remembering to
- Evidence included — files, photos and signatures hang off the entry, not in a folder beside it
- Changeable any time — fields come and go without needing a developer
What belongs together stays connected
Customers and orders, vehicles and inspections, employees and training: instead of copying values, entries point at each other. That keeps the data consistent and turns separate lists into one coherent system.
- Link entry — an order points at exactly one customer
- Link multiple entries — a project points at everyone involved
- Visible from both sides — see a customer’s orders from the customer, and the customer from the order
- One change is enough — correct an address once and it is right everywhere
Link entries — one customer, many orders
Numbers that maintain themselves
Three column types do the arithmetic for you: “formula” computes a value from an expression, “calculate sum” adds up across all linked entries, “take value” pulls a single value from a linked entry. All three are read-only and update as soon as their basis changes.
- Formula — a net total from quantity and unit price, a remaining term from two dates
- Calculate sum — a customer’s revenue across all of their orders
- Take value — show the customer number on the order without maintaining it twice
- Always current — no forgotten formula, no stale intermediate figure
Computed fields update themselves — no maintenance by hand
All 26 column types
Every column gets the type that fits its content — the basis for views, forms and automations.
Text & numbers
- Text
- Single-line text for names, subjects and short notes.
- Formatted text
- Multi-line text with bold, lists and headings.
- Number
- Whole numbers for quantities, counts and positions.
- Decimal
- Numbers with decimal places.
- Currency
- Amounts of money with a currency and a defined precision.
Choice & status
- Checkbox
- Yes or no — done or open.
- Single select
- Exactly one option from a predefined list.
- Multiple select
- Several options from a list at once.
Time & place
- Date
- A day without a time, such as a deadline.
- Date and time
- An exact point in time.
- Address
- A structured postal address.
- Geolocation
- A pair of coordinates — the basis for the map view.
Contact & evidence
- An email address.
- Phone
- A phone number.
- Web link
- A web address.
- Files
- File and image attachments, such as photos from a phone.
- Signature
- A handwritten signature captured on the device.
People & audit trail
- User
- A reference to a person.
- Created by
- Who created the entry — set automatically.
- Created at
- When the entry was created — set automatically.
Linked & computed
- Link entry
- A reference to exactly one entry in another grid.
- Link multiple entries
- References to several entries at once.
- Take value
- Shows a value from the linked entry — read-only.
- Calculate sum
- Sums across all linked entries — read-only.
- Formula
- Calculates a value from an expression.
- Internal link
- A reference to a grid, a form, a page or a link.
Working on the same data together
A space bundles the grids, forms, pages and flows that belong together. Roles decide who gets access and what they may do.
Roles instead of round-robin email
Read, edit or administrate — set per space, rather than mailing spreadsheets around.
Changes in real time
Several people work in the same grid at once. There is no second version for someone to forget.
Hosted in Germany
ApptiveGrid is built and operated in Germany, with a data processing agreement on request.
Questions about the database
How many column types are there?
26. They range from simple types such as text, number and date through files, address, geolocation and signature to linked entries and computed fields such as formula, calculate sum and take value.
Can I bring data over from an existing spreadsheet?
Yes. Existing tables can be imported as CSV — including automatically, as a step in a flow, when new files arrive regularly.
How are two grids connected?
Through the column types “link entry” and “link multiple entries”. Instead of copying a customer name into every order, the order points at the customer entry. Change the customer once and it is right everywhere.
Does ApptiveGrid calculate across linked entries?
Yes. “Calculate sum” adds up across all linked entries, “take value” pulls a single value from the linked entry, and “formula” computes a value from an expression.
Can several people work on the same data at once?
Yes. A space is shared and roles decide who may read, edit or administrate. Changes are visible to everyone immediately.
How many rows fit into a grid?
That depends on the plan: 500 rows per grid on the free Starter plan, 5,000 on Plus, 50,000 on Pro and 250,000 on Enterprise.
Create your first grid
Start for free, add fields, capture data. No credit card required.