⟵ hearthere ⟶
  • Quick start
  • Install MIT
  • Install PRO
  • Updating
  • Optimization
  • Update v4-v6
  • Backups
  • Console utility bin/totum
  • Basics for users
  • Interface and Layout
  • Tables and their parameters
  • Prefilter
  • Fields and their parameters
  • Syntax
  • Code, actions, formatting
  • Relational relationships
  • Calculation order and calculation units
  • Auto-complete calculations and timing
  • Duplicate rows and cycles
  • Comparisons
  • Functions
  • Debugging
  • Print and CSV
  • API
  • Roles and users
  • Notifications
  • Scheduled Actions
  • System tables
  • Trees
  • Anonymous tables
  • External Forms
  • Exporting and importing tables
  • [PRO] MeiliSearch
  • [PRO] Databases
  • [PRO] Custom CSS
  • [PRO] Custom docs
  • [PRO] LDAP AD
  • [PRO] File versions
  • [PRO] List-unsubscribe
  • [PRO] Dynamic fields
  • [PRO] Only Office
  • [PRO] Auth Tokens
  • [PRO] 2FA
  • [PRO] Superlang
  • [PRO] Daemons
  • [PRO] Profiler
  • Connecting functions
  • [SRV] Installation and Connection
  • [SRV] Export, PDF, Upload, and Preview
  • [SRV] XLSX/DOCX Generators
  • Auto-Filling Tables

    Rows of tables with a tabular unit of recalculation can be filled automatically based on conditions.

    To do this, the first sort field of the row part should be set to the field with nameinsert.

    This field must contain any list. Rows will be created in the number of values in the list. Each row in the insert field will be populated with a value from the list. The values will be placed in the order they appear in the list.

    The list must contain only unique values, not containing null or "" (empty string).

    If, as a result of recalculation, the list in insert has changed and:

    • New values were added — rows will be added to the end of the table.

    • Values were removed:

      • If there were no changes in the removed row — the row will be deleted.
      • If there were changes in the removed row — the row will remain but will be marked with strikethrough.
    • Values were changed — in this case, the change is processed as a combination of deletion and addition.