⟵ 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

    • Restrict a specific user’s access to only the row in the table linked to them

    Question

    There is a table for registering users' personal data. After initially entering a user (login/password) into the system table "users", the created user should be given access only to their own row in the registration data table for independently entering the remaining personal data. How can this be done?

    Answer

    Restricting user access to specific rows in a table is achieved using Prefilters. If a prefilter field is linked to a row part field and is not editable (visibility does not matter in this case) for the user, then this prefilter field acts as an access limiter on the server side.

    In the row part of the table, there should be a field where, for example, user IDs are stored, and this field is linked to the prefilter field. In the prefilter field, the code calculates the ID of the current user who opened the table:

    Prefilter field defining the current user's ID:

    =: $#nu

    This code can be refined to provide more convenience for users who need to see the entire table:

    =: if(condition: $#nr = json`[1,5]`; then: ""; else: $#nu)

    In this code, we check the current user's roles, and if role 1 or 5 is among them, we set an empty value in the prefilter field, which is equivalent to disabling it if this field is of type String or Number. If the user does not have these roles, the code returns the current user's ID.

    If the prefilter limiter field is of type Select or Select-tree, instead of "", you need to pass "*ALL*":

    =: if(condition: $#nr = json`[1,5]`; then: "*ALL*"; else: $#nu)

    For the Cycles table, this approach does not work, as in Cycles, it is necessary to restrict access not only to rows in the Cycles table but also to tables within the cycle. This is done using the table settings parameter: Access type to cycles. In conjunction with the technical field creator_id in the cycles table and settings in the users table: boss_id, add_users, and all_connected_users.