Skip to main content Enter
Proto Workflows Headless SaaS
Enterprise
Enterprise Identity, access, deployment, and support controls for contracted environments. Version control Branches, releases, snapshots, and history in the per-app Command Centre.
Enterprise Talk to sales. Deployment, support, security, procurement and commercial terms. Contact sales
Pricing
Search apps — ⌘K / Ctrl K Sign Up
Proto Workflows Headless SaaS
Enterprise
Enterprise home Version control Contact sales
Pricing
Sign Up
  1. Home
  2. Help
  3. ERP•AI guide
  4. Quick start: build your first app in 10 minutes

Quick start: build your first app in 10 minutes

In this guide you’ll build a small sales-tracking app with two linked tables, Customers and Orders. Along the way you’ll use the core ERP•AI features: tables, field types, links between tables, calculated fields, records, layouts, and views.

ERP•AI guide 4 min read Article 3 of 7 in Getting started

On this page

  1. Step 1: Create the app
  2. Step 2: Create your first table (Customers)
  3. Step 3: Add fields to Customers
  4. Step 4: Create a second table (Orders) and link it to Customers
  5. Step 5: Add a rollup to Customers
  6. Step 6: Add records
  7. Step 7: Try a different layout
  8. Step 8: Create a view
  9. You’re done! What’s next?

Getting started

  1. What is ERP•AI?
  2. Sign up and sign in
  3. Quick start: build your first app in 10 minutes
  4. Key concepts and glossary
  5. Finding your way around ERP•AI
  6. Organizations (workspaces) and switching between them
  7. Use ERP•AI on your phone or tablet

Time: about 10 minutes
You need: an ERP•AI account and a role that can create apps (for example App Creator or Super Admin).

Step 1: Create the app

  1. Sign in at apps.erp.ai. No account yet? See Sign up and sign in.
  2. Click Apps in the left sidebar.
  3. Click + New App (top right).
  4. In Create a new app, click Create manually instead.
  5. Enter an App name (for example Sales Tracker) and an optional Description.
  6. Click Create app.

The app opens, and ERP•AI asks you to Add your first table.

Create a new app, after Create manually instead: name the app and click Create app
Create a new app, after Create manually instead: name the app and click Create app

Step 2: Create your first table (Customers)

In the Add your first table dialog:

  1. Table Name: type Customers. Click the icon button next to the name to choose an icon.
  2. Category/Section: leave it as Masters. Categories are the groups you see in the app’s left sidebar.
  3. Primary Column: leave it as Id with data type Auto Sequence, so every customer gets a number automatically (0000001, 0000002…).
  4. Include Name Column: leave it on. This adds a Name text field.
  5. Enable Draft: leave it on. This lets people save incomplete records as drafts.
  6. Click Create table.
Setting up a table: name, section, primary column, and drafts
Setting up a table: name, section, primary column, and drafts

Step 3: Add fields to Customers

Click + Column above the table and pick a field type:

Field nameTypeHow to set it up
StatusSelectReplace Option 1 / Option 2 with Lead, Active, Churned
EmailEmailType the name only
Customer SinceDateLeave Display Time off
Account ManagerUserLeave Allow Multiple Users off

For each field, type the name in Property name (ERP•AI calls fields properties or columns in some places; they’re the same thing) and click Save.

Tip

Type in the search box at the top of the New Property list to find a field type quickly.

Step 4: Create a second table (Orders) and link it to Customers

  1. Click the + button next to Search in the left sidebar, then click New Table.
  2. Name it Orders. Open Category/Section, click +, type Transactions, and press Enter.
  3. Click Save.
  4. Add these fields with + Column:
Field nameTypeSetup
CustomerReferenceSource Table: Customers. Column to Show: Name
QuantityNumberFormatting: Integer
Unit PriceNumberTurn on Is Currency. Formatting: Decimal. Precision: 2
TotalFormulaOutput Type: Number. Formula: Quantity * Unit Price

Tip

In the Formula editor, open Available columns and click a column name to insert it. Names with spaces, like Unit Price, work as they are.

Step 5: Add a rollup to Customers

  1. Open Customers and click + Column → Rollup.
  2. Name it Total Sales.
  3. Source Table: Orders. Target Column: Total. Aggregate Function: SUM.
  4. Click Save.

Each customer now shows the total value of all their orders.

Step 6: Add records

  1. In Customers, click + New Customers. Fill in Name (Acme Corp), Status (Active), and Email, then click Save.
  2. In Orders, click + New Orders. Enter a Name (Office chairs), pick Acme Corp under Customer, then enter Quantity 3 and Unit Price 250. Total fills in automatically as 750. Click Save.
  3. Go back to Customers. Total Sales for Acme Corp now shows 750.
The Orders table. Total is calculated automatically by the formula
The Orders table. Total is calculated automatically by the formula

Step 7: Try a different layout

In Orders, click ⋯ (More options) → Layout → Board. Orders are now grouped into columns by Customer. Try Calendar, Gallery, Timeline, and Ledger too, then switch back to Table.

Step 8: Create a view

  1. Click + in the sidebar. Under Create a view from a table, click Customers.
  2. View name: Active Customers.
  3. Add/remove columns: choose Select all.
  4. Filter Data By → Add condition: Status is Active.
  5. Click Save.

Active Customers now appears in the sidebar and shows only active customers.

You’re done! What’s next?

  • Automate something: Build your first workflow
  • Invite your team: first add people to the organization (Members), then give them the app (App access and permissions)
  • Customize the entry form: Form Layout Editor
  • Skip the manual work next time: Ask Proto to build the app
PreviousSign up and sign in Next Key concepts and glossary

Get help from the team.

In ERP•AI, open the organization or app menu and choose Report an issue. For deployment, billing or contract questions, write to the team.

Contact the team Open ERP•AI
ERP.AI

Business apps and Proto, a personal agent for your business.

Products

  • Business Apps
  • Proto
  • Workflows
  • Headless SaaS
  • Platform

Company

  • Company
  • Enterprise
  • Pricing
  • Contact
  • Partners

Resources

  • Resources
  • Documentation
  • Help Center
  • Security
  • Legal
  • Photo credits
© 2026 ERP•AI. All rights reserved. · Built with Proto
System status

Your Privacy, Your Choice

We use essential cookies to run the site and optional cookies for features, analytics, and relevant content. See Cookie policy

Manage Your Cookie Preferences

We use cookies to enhance your experience, analyze site traffic, and serve relevant content. By clicking "Accept All," you agree to our use of cookies. You can customize your preferences at any time.

Your browser's Global Privacy Control signal is honored: advertising cookies are off.

Learn more about how we use cookies

These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.

These cookies enable additional features that enhance your experience, such as live chat, video playback, personalized content recommendations, and remembering user preferences.

These cookies help us understand how visitors interact with our site by collecting anonymous usage data. This allows us to measure performance, detect issues, and continuously improve the user experience.

These cookies allow us and advertising partners, including X, to deliver ads tailored to your interests. They track browsing habits across sites to provide relevant advertising and measure ad effectiveness.

Meet Proto.Free to use.

A personal agent for your business.

Brief Proto. It works across your files and tools, then brings the results back.

89.5% of attempts accepted on BusinessBench.

Download Proto

Also for macOS Windows Linux

Your own model provider may charge for usage.