Table of Contents

With the help of automations, you no longer have to manually lock rows in your tables, but can have rows perform the automatically. This is very useful if you always want to prevent a row from being processed further from a certain point in time (e.g. when a process has been completed).

Lock a row with an automation

  1. In the Base options, click and then click Automation Rules.
  2. Click Add Rule.
  3. Name the automation and specify the table and view in which it should act.
  4. Define a trigger event that triggers the automation.
  5. Click Add Action and select Lock Entry as the automated action.

Selection of the automated action: “Lock entry”.

  1. Confirm with Submit.

For example, if you want tolock any row in one of your tables where a certain entry reaches a specific value, define the event: Entries meet certain conditions after editing as the automation trigger.

Definition of the automation trigger event

Then set the value and the column in which it must be reached.

Definition of the automation trigger event

Finally, set Lock Entry as the automated action.

Definition of the automated action

From this moment on, the created automation will lock all rows where entries change in such a way that they fulfill the automation rule.

Defined automated action: “Lock entry”.

Automations are extremely useful if you want to lock several rows at the same time. To do this, select the Execute Periodically trigger for entries that meet the conditions and set the appropriate conditions. Instead of setting the execution frequency and time, click Execute Now below to immediately lock all the desired rows .

For more information on blocking rows , see the article Blocking a row.

Manage and edit automations Stop automations