Skip to main content

Several Key Numbers

I. SaaS Edition​

1. Worksheet​

  • Add up to 200 fields in the worksheet.

    • Excluding 4 system fields: creator, owner, date created, date updated.

  • Add up to 200 rows of records in sub-form.

  • For associated fields, get up to 1000 rows of records, e.g:

    • If it is a rollup field, up to 1000 rows of associated records can only be summed up (click the refresh button to sum up all).

    • For the node [Get multiple data], get up to 1000 rows of associated records.

      If you need to get more than 1000 rows of data, please select [Get records from worksheet] when configuring workflow.

    • For a foreign field, only 1000 rows of records are synchronized.

      Example: Record a in worksheet A is associated with 2000 rows of records in worksheet B. There is a foreign field in worksheet B that references fields in worksheet A. When the field in record a is modified, only 1000 rows in worksheet B are synchronized to the foreign field. The remaining records are not synchronized.

  • Recycle Bin

    • Deleted applications are retained for up to 7 days.
    • Deleted worksheets, custom pages, fields, and records are retained for up to 60 days.

  • For single and multi-choice fields, the field cannot have more than 50 options when importeing, but there is no restriction if the option sets are referenced.

2. View and Custom Page​

  • Display up to 50 columns in the grid view.

    • Including 4 system fields.

  • In the grid view, select up to 1000 rows of records at a time for batch operation.

    • The view can be updated by importing.
    • You can rely on the filter to keep the data in the list to 1000 rows or less for batch operation.

  • Charts in custom pages are automatically refreshed every 15 minutes.

  • Up to 20 components (charts, embedded pages, etc.) can be added to custom pages.

3. Workflow​

  • The node [Update record] processes up to 100 rows of data when updating or deleting in bulk.

  • Sub-flow can process up to 10,000 rows of data.

  • The request time of the node [Send API Request] cannot exceed 10 seconds.

  • The execution time of the code block cannot exceed 8 seconds, if exceeding, it times out directly.

4. API​

  • API Call

    • Interface to add record interface (addRow), up to 20 calls/sec for the same IP

    • Interface to batch add records interface (addRows), up to 20 calls/sec from the same IP

    • Interface to edit record interface (editRow), up to 20 calls/sec from the same IP

    • Interface to batch edit records interface (editRows), up to 20 calls/sec from the same IP

    • Interface to get list of records (getFilterRows), up to 50 calls/sec from the same IP

    • No restrictions on the frequency of calls to other interfaces

      In Private Deployment Edition, there is no restrictions on the frequency of calls to interfaces.

  • Get up to 1000 rows of records via API.

  • If bulk adding or deleting records via API, it supports up to 1000 records.

  • If writing attachment (Base64) via API, it supports up to 7M.

II. Private Deployment Edition​

1. Worksheet​

  • Add up to 2000 fields in the worksheet.

    • Excluding 6 system fields, creator, date created, last modifior, last modification time, owner, record ID.

  • Add up to 200 rows of records in sub-form.

  • If it is a rollup field, up to 1000 rows of associated records can only be summed up.

    • Click the refresh button to sum up all.

  • For a foreign field, only 1000 rows of records are synchronized.

    • Example: Record a in worksheet A is associated with 2000 rows of records in worksheet B. There is a foreign field in worksheet B that references fields in worksheet A. When the field in record a is modified, only 1000 rows in worksheet B are synchronized to the foreign field. The remaining records are not synchronized.

  • For single and multi-choice fields, the field cannot have more than 50 options when importeing, but there is no restriction if the option sets are referenced.

2. View and Custom Page​

  • In the grid view, 1000 rows of records are selected by default for batch operation (which can be customized).

    • You can also update the view by importing.
    • You can rely on the filter to keep the data in the list to X rows or less for batch operation.

  • Charts in custom pages are automatically refreshed every 15 minutes by default (which can be customized).

3. Workflow​

  • Up to 100 records by default for batch updating, deleting and adding (which can be customized).

  • Sub-flow can process up to 10,000 rows of data by default (which can be customized).

  • The request time of the node [Send API Request] cannot exceed 10 seconds (which can be customized).

  • The execution time of the code block cannot exceed 10 seconds by default (which can be customized).

  • Delay for workflows triggered by events from worksheet defaults to 5 seconds (which can be customized).

Custom settings:

Have questions about this article？ Send us feedback