⟵ hearthere ⟶
  • Training course
  • Creating simple tables and fields
  • Codes base level
  • Selects and links between tables
  • Table settings basic level
  • Prefilters base level
  • Conditional formatting basic level
  • Highlighting the field in bold, text color and background color
  • Several formatting conditions
  • Locking and highlighting the whole row by conditions
  • Blocking changes in the field by conditions
  • What are text and comment in field formatting
  • Whole table formatting
  • Action codes base level
  • Using pop-up windows
  • Cycles base level
  • Roles and users on the web
  • Codes advanced level
  • Action codes advanced level
  • Prefilters advanced level
  • Field and table settings advanced level
  • Cycles advanced level
  • Formatting advanced level
  • Select-Tree
  • Executing a scheduled action code
  • Printing and emailing
  • Notifications
  • API interaction
  • Adaptivity and Sections
  • Whole table formatting

    formatting

    Where is the table formatting code?

    Table parameters — Table formatting.

    What function is used in the table formatting block?

    setTableFormat

    Does row and field formatting override table formatting?

    Yes — priority in this order:

    • table formatting

    • row formatting

    • field formatting

    That is, the field overrides everything. The row overrides the table.

    What parameters are responsible for blocking insertion, deletion and duplication?

    In setTableFormat, most parameters are applied specifically to the table:

    • blockdelete — blocking the deletion of rows.

    • blockduplicate — blocking duplication.

    • blockorder — blocking sorting by n.

    • blockadd — blocking the addition of rows to the table.

    For example, you can block the addition of rows if there are more than 5:


    f1=:
    setTableFormat(condition: $calc >= 5; blockadd: true) calc: listCount(list: $list) list: selectList(table: $#ntn; field: 'id')

    Is it possible to change the header of the table by condition?

    This is handled by the tabletitle parameter, and for the row part by rowstitle:

    For example, changing the table title depending on the prefilter values:


    f1=:
    setTableFormat(tabletitle: str`"Indicators for" ++ $dateform`) dateform: dateFormat(date: #fl_date; format: "F"; lang: "ru")

    How do I change the header of a field by condition?

    This is handled by the fieldtitle parameter, for example:


    f1=:
    setTableFormat(fieldtitle: 'field_name' = $title) title: if(condition: #type = 2; then: "Marginal Income"; else: "Net Profit")