⟵ 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
  • Action codes base level
  • Using pop-up windows
  • Cycles base level
  • Roles and users on the web
  • Codes advanced level
  • How do comparisons work in codes?
  • How do I check if one list contains another?
  • How to turn off where by the conditions
  • The insert line has no id
  • How to create lists fast
  • How do I take a row from a table and then get data from it?
  • What are associated array lists?
  • Specifying a field name by code, specifying a line of code by code?
  • A list of lists and turning it into a list
  • How do I sequentially go through the list and complete it or overwrite the values?
  • How do I filter and sort a list or a list of associated arrays?
  • Getting information about manual values, tree level, selects
  • How do while and var work? Replacing with listReplace
  • How to optimize the execution of the same code with variables passed to it?
  • How to use cond for condition?
  • How do I use the value of the previous row to calculate the current one?
  • Why do I need a column-by-column recalculation in the calculated and temporal tables?
  • How do I use the previous value in codes and combine manual input and code?
  • Row and rowList operations
  • 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

    • What are associated array lists?

    What does selectRowList take and what is its result?

    If selectRow takes several columns from one row, then selectRowList takes several rows and several columns.

    Several rows list + several columns row = rowlist

    id field_1 field_2
    0 100 a
    1 200 b
    2 300 c

    First, you refer to the row, and then to the column. If we want to take the value 200 from this rowlist, then:


    =:     $rowlist[1][field_1]

rowlist

    How do I refer to a specific row and what will be the result?

    If we refer only to the rowlist string, we get row:

    id field_1 field_2
    0 100 a
    1 200 b
    2 300 c 

    =:     if(condition: $row[field_1] = 200; then: true; else: false)

    row: $rowlist[1]

        rowlist: "..."

// Result true

    How do I take a column from a list of rows?

    If we want to get a column, we need to use [[]].

    The result of such an access will be a list of all values in the column:

    id field_1 field_2
    0 100 a
    1 200 b
    2 300 c 

    =:     $rowlist[[field_2]]

        rowlist: "..."

// Result ["a","b","c"]