⟵ hearthere ⟶
  • Workshops
  • External connections
  • Tableau и PowerBI
  • Knowledge base
  • Reference to the data of a temporary table
  • Loss of connection to the database during high data traffic
  • Save file in the field by external url link
  • Generating a list of rows marked with checkboxes and sending it to print
  • Adding a loop to the cycle table using a button from the temporary table
  • The TryCatch function and data transfer after a rollback
  • Access error when navigating to the cycle if the first table is unavailable to the user
  • The architecture of a system calculating balances for a cash register or warehouse
  • Sorting during selection based on the display of the Select field rather than its underlying value
  • Blocking the entry of duplicate values
  • Tabular display in the contextual panel
  • Sorting rows in a table using a button
  • How to retrieve a value based on a condition from a list of nested arrays?
  • Reset the ID counter in the table
  • Hiding a field in the table based on a condition
  • Action confirmation when clicking a button in a contextual window
  • Recalculation of a large table
  • How to sum values in `rowList` by one of the keys (one of the columns)
  • Field sets based on conditions when opening via `linkToTable`
  • How to delay the execution of an action and perform it in the background
  • Creating and deleting rows when selecting values in a Select or Select-tree
  • `selectRowListForSelect` with a condition where the current value is displayed as strikethrough
  • Not all external requests to Remotes are executed, causing the ID counter to break
  • Sorting Calculated Tables in a Cycle
  • How to pass data as numbers when making a POST request to a third-party API (must be an "integer")
  • How to create a chart when there are multiple parameters
  • Saving the initial values in a field when the field is calculated by code
  • Auto-filling the values of subsequent fields based on the selection in the first field
  • How to use a button in a temporary table to write data into a field in a calculated table within a cycle?
  • Display values from two fields of another table in a single Select field
  • #$ndts does not add seconds to a field of type Date
  • Calculator button in a field
  • Export CSV without technical data
  • Send an HTML list of field values via email
  • How to send multiple files via email in a single message
  • Action triggered by clicking a button in a sent email
  • Quick form and passing information to it from the DOM
  • Retrieve the pinning (pin) or locking (hand) status for a cell
  • Columns are displayed with incorrect sizes
  • Rebuild a multidimensional array into a one-dimensional array
  • Configuring the system's global search to search by a part of the entered number, not just from the beginning
  • How to remove artifacts from the global search across the system
  • Is it possible to launch a temporary table from a tree?
  • Output the values of multiple fields as text separated by a "separator"
  • Filter a list by the key `value`
  • Select all values belonging to a category in a field of type Select-tree
  • Hide the "eye" and "print" icons for users
  • Line break in text when sending an email
  • Sending a file via email without saving it in the database
  • Transferring files from a temporary table to a regular table
  • Codes in fields only work in a specific order, but I need to move the field to the front
  • Data format in PostgreSQL when accessed from an external BI system
  • Composite conditions in `WHERE` parameters
  • Uniqueness check during addition plus removal of extra characters
  • Replacing empty values in dates within `rowList`
  • Blocking the update of calculations in fields based on a condition
  • An anonymous table calls remotes, but data is not returned to the anonymous table even when a hash is passed
  • Back button
  • Working with a value from a pre-filter in `linkToInputSelect`
  • The absence of the three-dot button in an iframe
  • Block file deletion in a field of type File
  • How to enable preview for PDF files
  • Changing the `name` of an already created table
  • Checking field relationships in a table within a project
  • User IDs considering their roles for `notificationSend`
  • Adjusting access settings for Meilisearch results based on roles
  • Personalized sorting in a table
  • Editing a field of type File
  • Send a file from the panel without saving
  • How to alternate colors for days of the week in a table
  • Client registration/authentication through a form
  • LDAP ("ERROR: Operations error")
  • selectRowList: How to collect all data from the list
  • How to add an image to a print template?
  • Is it possible to remove field header titles and the space they occupy?
  • How to pass a pre-filter parameter when creating a cycle?
  • Saving passwords from a form into the Users table
  • How to validate a login in a quick registration form?
  • Missing keys in the response from an external API
  • Restrict a specific user’s access to only the row in the table linked to them
  • How to make a user see only the table inside a cycle but not the cycle table itself?
  • Display only unique values in the selection list of a pre-filter with a select
  • How to restrict a user from changing their password?
  • How to enable navigation to different tables in a cycle based on roles during its creation?
  • Additional information in a cycle table field from inside the cycle
  • How to determine if a row is the last one in a column?
  • Return a list of only those values from the original list that are unique (appear only once)
  • Open a string as a link starting with `https://`
  • The `panelImg` function: How to set an image as a preview from another table?
  • The system slows down with more than 10 users online
  • Row numbering based on the date in the Date field
  • Send files from multiple table rows via email
  • How to display the name or order number in the Tree instead of the cycle ID when opening a cycle?
  • The order of tab display in a cycle
  • Strict filtering in a field of type Select when selecting a value
  • Getting the ordinal week number of a month for a given date
  • Tracking changes in multiple fields
  • Select based on data created in another field of the same table
  • Replacing values in a list with new composite ones
  • Optimization of calculations in a table when the computation is duplicated between code and formatting code
  • Do not execute action code if the change is triggered by a script
  • Do not change the value in a cell if the action is not completed

    • Replacing empty values in dates within `rowList`

    Question

    There is a cron job that sends a reminder in the form of a table via email every day.

    The code looks like this:

    =: if(condition: $sel != $#lc; then: $send)
    sel: selectList(table: 'requests'; field: 'id'; where: 'status' = "open")
    send: emailSend(to: $userssend; title: "Daily report on open requests"; body: $body)
        userssend: select(table: 'users'; field: 'email'; where: 'roles' = 4)
        body: textByTemplate(template: "template_name"; data: $data)
        data: rowCreate(field: "table" = $row)
            row: rowCreate(field: "template" = "inner_template_row"; field: "data" = $rowlist)
                rowlist: selectRowList(table: 'requests'; sfields: json`["customer","suppliers","offers"]`; field: 'number'; field: 'application_deadline'; field: 'request_sent'; field: 'proposal_client'; where: 'status' = "open"; order: 'number' asc)

    application_deadline, request_sent, proposal_client are fields of type "date" and if these fields contain null, it is necessary to substitute a value in the template in the cells as "Empty"/"No"/"---" (anything but "").

    Answer

    Since the fields application_deadline, request_sent, proposal_client are Date type fields and are stored in Totum in the Y-m-d format, it makes sense to format them into a human-readable format accepted in your region.

    This can be done using the dateFormat function:

    =: if(condition: $sel != $#lc; then: $send)
    sel: selectList(table: 'requests'; field: 'id'; where: 'status' = "open")
    send: emailSend(to: $userssend; title: "Daily report on open requests"; body: $body)
        userssend: select(table: 'users'; field: 'email'; where: 'roles' = 4)
        body: textByTemplate(template: "template_name"; data: $data)
        data: rowCreate(field: "table" = $row)
            row: rowCreate(field: "template" = "inner_template_row"; field: "data" = $dateformat)
                dateformat: dateFormat(date: $rowlist; format: "d.m.Y"; keys: json`["application_deadline","request_sent","proposal_client"]`; recursive: true; replace: "Empty")
                    rowlist: selectRowList(table: 'requests'; sfields: json`["customer","suppliers","offers"]`; field: 'number'; field: 'application_deadline'; field: 'request_sent'; field: 'proposal_client'; where: 'status' = "open"; order: 'number' asc)

    For the dateFormat function, you can specify a list of keys that need to be processed in the keys parameter, set the format, indicate that the entire array should be processed by passing recursive: true, and use the replace parameter to specify the value to replace "" and null.