Demo on Setting up AutoAction to Automate Data Management
Demo on Setting up AutoAction to Automate Data Management

Demo on Setting up AutoAction to Automate Data Management

When it is necessary to maintain data consistency across different datasets, we need a mechanism - AutoAction - to automate data management e.g. when adding a record in a table, any related records from another table also needs to be updated

In accounting systems like ourBook, which can be activated and run after signing in ourDB, the double-entry principle is fundamental. This principle dictates that every transaction involves an equal credit to one account and a debit to another.

Manually maintaining double-entry requires users to enter two separate, but identically valued, transactions. This manual process is prone to human error, which can lead to data inconsistencies if the amounts don't match.

To address these challenges, an automation mechanism is essential. Our AutoAction feature in ourDB provides this by:

  1. Speeding up data entry: A single transaction entry now automatically handles both the debit and credit, streamlining the process.
  2. Eliminating human error: AutoAction guarantees that the debited and credited amounts are always identical, preventing discrepancies.
  3. Ensuring business logic implementation: Data is consistently maintained as logical units, regardless of who performs the entry, upholding the integrity of your accounting principles.

The demos below illustrate how to configure AutoAction in ourDB to efficiently maintain business logics such as double-entry.

  1. Deleting records demo -
  2. Adding records demo +
  3. Editing records demo +

Published/Reviewed: 2025/06/18