Skip to content

Informat AI Low-Code Docs

Main Navigation Website Docs Tutorial Showcase Videos

English

English

Appearance

Sidebar Navigation

Introduction

Introduction to informat

System Architecture

Feature List

Metadata

Introduction

Define

AiAgentDefine

ApiDefine

AppListenerDefine

AppPermissionDefine

ApplicationCustomLoadResourceDefine

ApplicationDefine

ApplicationOptionDefine

AutomaticDefine

BpmnProcessDefine

DashboardCardDefine

DesignerAiAgentDefine

ModuleDefine

PageDesignerDefine

RoleDefine

ScheduleDefine

ScriptDefine

SurveyItemDefine

TableFieldDefine

TableFieldGroupDefine

TableIndexDefine

TableSearchFilterDefine

TextindexTableDefine

VersionDefine

Object

AggregationQuery

ApplicationResource

Button

CardStyle

ComponentDetailSetting

DataAutomaticVar

DefaultValue

DefineObject

DefineObjectFieldValue

DefineObjectSimple

DeleteDraftItem

DesignerPublishResult

FieldWidth

FilterCondition

FormStyle

Note

ObjectRef

TableViewFilter

TableViewSetting

TagStyle

WebsiteSetting

Version History

Quick Start

Basic

In-depth

Advanced

AI

SKILL.md

AI Agent Chat Development

AI Smart Designer

AI Assistant

Designer Agent

Table Agent

Script Agent

Dashboard Agent

Data Agent

Workflow Agent

Automatic Agent

API Agent

Website Agent

Schedule Agent

I18n Agent

Survey Agent

Listener Agent

AI Assistant Agent

App Config Agent

AI Assistant

AI Assistant Configuration

AI Smart Report

AI Send Email

AI Parse PDF File

More AI Usage Scenarios

ApiKey

Openclaw Usage

Claude Code Usage

VSCode AI Usage

Integrate informat MCP Server

Application Configuration

Overview

Basic Information

Role Permissions

Login Settings

Scheduled Tasks

API

Listeners

Option Value Dictionary

Theme Styles

Scripts

Application Dependencies

Environment Variables

Extension Libraries

Internationalization

Installation and Upgrade

Users and Organization Structure

Shared Storage

Error Codes

Rich Text

System Icons

Run Log

Data Tables

Overview

Form Settings

Data Filters

Record Permissions

Listeners

Data Sources

Default Data Source

Data Tables from Other Applications

Data Source from Database View

Get Data via Script

Data Source from External Database

Workflow Settings

Other Applications Access

Field Index

Data Table Partitioning

Appendix

Data Storage Structure

Record Type Transformation

Field Type Transformation

Field to Database Storage Structure

Data Table Record Sorting

Data Table Fields

Basic Settings

Single Line Text

Multi Line Text

Rich Text

Integer

Decimal

Date

Time

Rating

List Select

Tree Select

Cascader Select

Attachment

Checkbox or Switch

User Select

Department Select

Color

Signature

Functions

Custom Components

Related Lists

Related Records

Related Record Fields

Lookup Lists

Child Objects

Related Lists Rollup

Lookup Rollup

ID

Child Object ID

Create Time

Last Modify Time

Create User

Last Modify User

Static Text and Controls

Data Table Views

Introduction and Basic Configuration

Views

Grid View

Gantt Chart

Kanban View

Calendar View

Card View

Tree View

Timeline View

Resource Calendar View

Map View

Folder View

Custom View

Typical Scenarios

Left Tree Right Table Linkage

Dashboards

Overview

Charts

Overview

Line Chart

Bar Chart

Pie Chart

Scatter Chart

Radar Chart

Boxplot Chart

Candlestick Chart

Funnel Chart

Map Chart

Heatmap Chart

Gauge Chart

Customize Chart

Excel Chart

Gantt Chart

Table Chart

Pivot Chart

Number Chart

Rich Text Chart

Countdown Chart

Time Line Chart

Website

Button

Calendar

Image

Divider

Label

Collapse

Table

Form

Flexbox

Expressions

Overview

Functions

Array

Date

Math

String

User

Record

Context

Miscellaneous

Encode

Controls

Overview

Table

Open Record Create Page

Add Row to Table

Add Row to Table at Row

Delete Row from Table

Delete Rows from Table

Add Rows to Table via Import

Add Rows to Table via Select Record Page

Open Record Form

Import Data

Import Data Update

Call Automatic after Import Data

Open Export Dialog

Export Excel

Delete Record

Open Batch Edit Record Page

Update Record Field Value

Print Record Grid

Print Record Form

Validate Current Form

Relation Table

Open Create Children Record Page

Move Multiple Records to Parent

Open Create Relation Record Page

Add Records to Relation List

Remove Records from Relation List

Workflow

Open Create Process Instance Page

Create Process Instance with Record

Delete Process Instance

Open Process Instance Form

Revoke Process Instance

Urge Process Instance

ReSubmit Process Instance

Process Run Status

Save Process Instance

Workflow Task

Save Task Form

Complete Task

Transfer Task to Another User

Delegate Task to Another User

Jump to Another Activity

Jump to End Activity

Other

Call Automatic

Open URL

Show Toast

Copy to Clipboard

Set App Clipboard Data

Open Dashboard Card

Open Search Dialog

Open Website Page

Automatic

Overview

Data Table

Query Record List

Query Record Count

Query Record

Query Record Relation List

Query Record Relation Count

Insert Record

Update Record

Delete Record

Update Lookup Rollup Field

Control and Variables

For Each Loop

While Loop

If Statement

Set Variable

Update Variable

Abort Execution

Code Snippet

Call Script Function

Print Log

Call Automatic

Set Automatic Return Value

Set Automatic Run Progress

Functions

HTTP Request

Execute Command via SSH

Wait for Specific Time

Send Notification

Set App Badge

Publish App Event

Push Event to Client

Set Module Alert

AI

Call ChatGPT

Workflow

Example Workflow

Set Workflow Variable

Get Workflow Variable

Create Workflow Instance

Query Workflow Instance

Query Workflow Task

Set Task Assignee

Jump Task to Target Activity

Revoke Workflow Instance

Delete Workflow Instance

Delete Workflow Task

Complete Workflow Task

Send Workflow Signal

Send Workflow Message

Trigger Waiting Task to Continue Execution

UI Interaction - Input/Output

Show Prompt Dialog

Show Rich Text Dialog

Show Toast

Open Confirm Dialog

Show Notification

Open Custom Form

Open Custom Table

Scan QR Code

Download Excel

Upload Excel

Upload File

Download File

Copy Text to Clipboard

Open Form Designer Form

UI Interaction - UI Features

Open URL

Open Split Drawer or Dialog

Open Website Page

Open Record Create Page

Open Form Page

Open Workflow Create Page

Open Workflow Task Info Page

Open Workflow Instance Info Page

Play Audio

Preview Image

Open Search Engine Dialog

Close Current Dialog

Preview Shared Storage File

Open Print Template

Validate Current Form

UI Interaction - Forms/Tables

Set Form Field Value

Set Form Table Selection

Open Record Select Dialog

Set Table View Filter

Set Table View Data

Set Table View Root Record ID

Set Table View Selection

Set Table View Active Records

Set Table View Expand State

Print Table Record

Print Table Record List

Refresh Table View Column State

UI Interaction - Push Events

Table Change Event

Workflow Change Event

Refresh Module

Refresh Record Form

Send Website Page Message

Set App Clipboard

Get App Clipboard

Set External System Page URL

Set Dashboard Filter

Refresh Dashboard Card

Execute Script on Client

Script

Overview

Model Definition

AI Script Agent

Functions

aiagent

app

bpmn

codec

company

console

csv

datasource

date

dept

designer

email

excel

pdf

file

ftp

http

jdbc

ldap

mpp

mq

notification

redis

sftp

storage

survey

system

table

textindex

transaction

user

utils

website

word

xml

Expressions

Client Script

Overview

Functions

system

http

app

notification

Workflow

Overview

BPMN2.0 Specification

BPMN Elements

Global Settings

Tasks

Variables

Intermediate Events

Subprocesses

Multiple Instances

Multiple Versions Management

Typical Scenarios

Counter Sign

Or Sign

Add Sign

Parallel Gateway

Auto Complete

Set Auditor

Use Form Designer as Approval Form

Leave Process

Interview and Onboarding Process

How to Query Approval Comments

Component Designer

Overview

Introduction

Base Usage

Resource Dependencies

Component Communication

Component Libraries

Overview

Third-party Component Libraries

Informat Component Libraries

Scenarios

Custom Field in Table

Custom View

Control

Dashboard Card

AI Component

Form Designer

Overview

Introduction

Fields

Script

Overview

Properties

Data

Computed Properties and Watchers

Methods

Stylesheet

Typical Scenarios

Example Form Design

Automatic Invocation

Referencing Table Fields

Setting Field Values with Script

Workflow Invocation

URL Invocation

Message Queue

Overview

Consume Model

Multi-thread Consume

Background Management

Survey

Overview

Typical Scenarios

Resource and Component Designers

Overview

Server-Side Rendering

Website Services

Introduction

Event Services

System Services

Table Services

Custom Field Services

Custom View Services

Typical Scenarios

Search Engine

Overview

Typical Scenarios

Grid Layout

Overview

Mobile Access

Overview

Print Template

Overview

Typical Scenarios

Fixed Layout

Streaming Layout

Recycle Bin

Overview

Application Operation Records

Overview

Application Member Management

Overview

Application Role Management

Overview

Department Management

Overview

Enterprise-level Background

Overview

Setting

Company

User

Import User

Monitor

Install Deployment

Prepare Steps

Install

Operating System ISO

Web Install

Web Upgrade

Command Line Install

Command Line Upgrade

Docker Single Container Install

Docker Single Container Upgrade

Offline Install Docker

Custom Install

Manual Upgrade

Multi Container Deploy

Cluster Deploy

Backup Scheme

Move Data

OnlyOffice Install and Common Issues

Typical Scenarios

AI Create Table

Custom Login

Custom Register

SAP Integrate

Other

Open Content

WebAPI

Common Issues

On this page

AggregationQuery

Field Definitions

Field	Type	Default	Description
func	String	-	Aggregation function
fieldId	String	-	Aggregation field
distinct	boolean	-	Whether to deduplicate

Last updated:

Pager

PreviousVersionDefine

NextApplicationResource