Records - Home

Overview

Records are individual data entries in your tables. ERPLite provides intuitive interfaces for creating and viewing records, with the ability to customize layouts using sections and tabs.

Auto-Generated Forms

Forms are automatically created based on your column definitions

Custom Layouts

Arrange fields in sections and tabs for better organization

Comments & Collaboration

Add comments, tag users, and create discussion threads

Change History

Track all changes with a complete audit log

Record Create View

When you click Add Record or +, the record creation form opens. This form is automatically generated based on your table’s column definitions.

How It Works

Auto-Generated Fields: Each column in your table becomes a form field
Type-Specific Inputs: Fields render based on their column type (text input, date picker, dropdown, etc.)
Validation: Required fields and type validation are enforced automatically
Default Values: Fields with default values are pre-populated

Creating a Single Record

Open Create Form

Click the + Add Record button in the table toolbar

Fill in Fields

Enter values for each field. Required fields are marked with an asterisk (*)

Save

Click Create or Save to create the record

Customizing the Create Form Layout

You can organize fields into sections and tabs for better usability.

Adding Sections

Sections group related fields together with a header.

Open Layout Editor

Go to table settings or click Manage Layout (requires permission)

Add Section

Click + Add Section and provide a section name

Drag Fields

Drag fields into the section to group them

Save Layout

Click Save to apply the layout

Adding Tabs

Tabs allow you to organize fields across multiple pages within the form.

Open Layout Editor

Access the layout editor from table settings

Add Tab

Click + Add Tab and provide a tab name

Organize Fields

Drag fields and sections into tabs

Save Layout

Click Save to apply the layout

Hiding Fields from Create View

You can hide certain fields from the creation form while keeping them in the table.

Open Column Settings

Click on the column header menu and select Edit Column

Toggle Create Visibility

Uncheck Show on create form or similar option

Save

Save the column settings

Hidden fields can still have values set via API or automations. This is useful for system-managed fields like status or timestamps.

Bulk Record Creation

For creating multiple records at once:

Import Feature: Use CSV import for bulk creation (see Import & Export)
API: Use the bulk create API endpoint

POST /zorp-tables-service/table/records
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "tableType": "my_table",
  "records": [
    { "data": { "name": "Record 1", "status": "Active" } },
    { "data": { "name": "Record 2", "status": "Pending" } }
  ]
}

Record Details View

When you click on a record in the table, the record details view opens. This provides a comprehensive view of all record data with editing capabilities.

Features

Feature	Description
View Data	See all field values in a structured layout
Edit Inline	Modify values directly in the details view
Sections & Tabs	Fields organized based on your layout configuration
Comments	Add and view comments on the record
History/Logs	View complete audit trail of changes
Related Records	See linked records from relation fields

Viewing Record Details

Open Record

Click on any row in the table to open its details

Navigate Sections

Use tabs (if configured) to navigate between different sections

View Related Data

Scroll down to see related records, comments, and history

Editing a Record

Open Record

Click on the record to open details view

Edit Fields

Click on any field to edit its value, or click the Edit button

Save Changes

Click Save to commit your changes

Editing requires appropriate permissions. Users with view-only access cannot modify records.

Customizing the Details Layout

Just like the create view, you can customize the details view layout:

Arranging Fields in Sections

Enter Layout Mode

Click Manage Layout or the layout icon (requires manage_section permission)

Create Sections

Add sections to group related fields

Drag and Drop

Drag fields into sections, arrange them in columns (1, 2, or 3 column layouts)

Save

Click Save Layout

Arranging Buttons

Button fields (automations) can also be arranged in the layout:

Place buttons in specific sections
Group related action buttons together
Position buttons at the top for easy access

Comments

Add comments to records for collaboration and communication.

Adding a Comment

Open Record

Navigate to the record details view

Find Comments Section

Scroll to the Comments section (usually at the bottom)

Write Comment

Type your comment in the text box

Tag Users (Optional)

Type @ followed by the user’s name to tag them

Submit

Click Send or press Enter to post the comment

Comment Features

Feature	Description
@Mentions	Tag users with @ to notify them
Threads	Reply to comments to create threads (one level deep)
Timestamps	See when each comment was posted
Author Info	See who posted each comment

Comment Permissions

Add comments: Requires add_comment permission
View comments: Anyone with record view access can see comments
Delete comments: Users can delete their own comments

History & Logs

Track all changes made to a record with the audit log.

Viewing History

Open Record

Navigate to the record details view

Find History/Logs Tab

Click on the History or Logs tab

Review Changes

See a chronological list of all changes

What’s Tracked

Change Type	Information Logged
Create	Who created the record, when, initial values
Update	Who changed what, previous and new values, timestamp
Delete	Who deleted, when (if soft delete enabled)
Status Changes	Status transitions with timestamps
Comments	Comment additions (linked to comments section)

Log Entry Format

Each log entry includes:

Timestamp: When the change occurred
User: Who made the change
Action: What type of change (create, update, delete)
Field Changes: Which fields changed and their before/after values

For AI Agents

API: Create Single Record

POST /zorp-tables-service/table/record
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "tableType": "my_table",
  "data": {
    "name": "New Record",
    "status": "Active",
    "priority": "High",
    "due_date": "2024-03-15"
  },
  "teamIds": ["team_123"]
}

Response:

{
  "code": "200",
  "message": "Record created successfully",
  "data": {
    "recordId": "rec_abc123",
    "tableType": "my_table",
    "data": {...},
    "createdOn": "2024-01-15T10:30:00Z"
  }
}

API: Get Record Details

GET /zorp-tables-service/table/:tableType/record/:recordId
Authorization: Bearer {secretKey}

Response:

{
  "code": "200",
  "data": {
    "recordId": "rec_abc123",
    "tableType": "my_table",
    "data": {
      "name": "Record Name",
      "status": "Active"
    },
    "createdOn": "2024-01-15T10:30:00Z",
    "updatedOn": "2024-01-16T14:20:00Z",
    "version": 3
  }
}

API: Update Record

PATCH /zorp-tables-service/table/:tableType/record/:recordId
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "data": {
    "status": "Completed",
    "completed_date": "2024-01-20"
  }
}

API: Delete Record

DELETE /zorp-tables-service/table/:tableType/record/:recordId
Authorization: Bearer {secretKey}

API: Get Record History

POST /zorp-tables-service/table/record/:recordId/logs
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "page": 0,
  "size": 50
}

API: Add Comment

PATCH /zorp-tables-service/table/:tableType/record/:recordId/comment
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "comment": "This is a comment with @user_123 mention",
  "mentions": ["user_123"]
}

Render Configuration APIs

Get the auto-generated form configuration:

# Create form configuration
GET /zorp-tables-service/table/web/create/renderConfig/tableType/:tableType

# Details view configuration
GET /zorp-tables-service/table/:tableType/web/renderConfig/:recordId

# Mobile app configuration
GET /zorp-tables-service/table/app/renderConfig/tableType/:tableType

UI Components

Component	Location	Purpose
CreateTask	`/src/render-engine/CreateTask.tsx`	Record creation form
ShowTask	`/src/render-engine/ShowTask.tsx`	Record details view
ShowPageTabs	`/src/render-engine/ShowPageTabs.tsx`	Tab navigation
Comments	`/src/components/Comments/`	Comments section

Event Tracking

// Record creation
TableRSEvents.ADD_NEW_RECORD_BUTTON_CLICKED
TableRSEvents.ADD_NEW_RECORD_MODAL_SUBMIT
TableRSEvents.CREATE_NEW_RECORD_SUCCESS
TableRSEvents.CREATE_NEW_RECORD_FAILURE

// Record editing
TableRSEvents.EDIT_SINGLE_RECORD_BUTTON_CLICKED
TableRSEvents.EDIT_SINGLE_RECORD_SUCCESS
TableRSEvents.EDIT_SINGLE_RECORD_FAILURE

// Record deletion
TableRSEvents.DELETE_SINGLE_RECORD_BUTTON_CLICKED
TableRSEvents.DELETE_SINGLE_RECORD_SUCCESS
TableRSEvents.DELETE_SINGLE_RECORD_FAILURE

// Comments
TableRSEvents.ADD_COMMENT_SUBMITTED
TableRSEvents.ADD_COMMENT_SUCCESS

Layout Structure

interface RecordLayout {
  tabs: {
    id: string;
    name: string;
    sections: Section[];
  }[];
}

interface Section {
  id: string;
  name: string;
  columns: 1 | 2 | 3;
  fields: {
    fieldName: string;
    width: 'full' | 'half' | 'third';
  }[];
}

Getting Started

Working with Data

Access Control

Automations

​Overview

Auto-Generated Forms

Custom Layouts

Comments & Collaboration

Change History

​Record Create View

​How It Works

​Creating a Single Record

​Customizing the Create Form Layout

​Adding Sections

​Adding Tabs

​Hiding Fields from Create View

​Bulk Record Creation

​Record Details View

​Features

​Viewing Record Details

​Editing a Record

​Customizing the Details Layout

​Arranging Fields in Sections

​Arranging Buttons

​Comments

​Adding a Comment

​Comment Features

​Comment Permissions

​History & Logs

​Viewing History

​What’s Tracked

​Log Entry Format

​For AI Agents

​API: Create Single Record

​API: Get Record Details

​API: Update Record

​API: Delete Record

​API: Get Record History

​API: Add Comment

​Render Configuration APIs

​UI Components

​Event Tracking

​Layout Structure

Overview

Record Create View

How It Works

Creating a Single Record

Customizing the Create Form Layout

Adding Sections

Adding Tabs

Hiding Fields from Create View

Bulk Record Creation

Record Details View

Features

Viewing Record Details

Editing a Record

Customizing the Details Layout

Arranging Fields in Sections

Arranging Buttons

Comments

Adding a Comment

Comment Features

Comment Permissions

History & Logs

Viewing History

What’s Tracked

Log Entry Format

For AI Agents

API: Create Single Record

API: Get Record Details

API: Update Record

API: Delete Record

API: Get Record History

API: Add Comment

Render Configuration APIs

UI Components

Event Tracking

Layout Structure