Cascade Updates

When updating a database, it is essential to also update all related and dependent records to maintain data consistency, accuracy, and integrity.

PowerTable allows you to automatically cascade updates across all related tables using an automation workflow.

1. Select Setup > Automations.

Setup automation

1. Create a new automation workflow by clicking on Create.

Create Automation

1. Click Add Trigger or directly select any of the suggested triggers to configure the triggering event.

Add Trigger

1. Let us assume you need to update relevant records in another table whenever a new record is created. In this case, you can select the trigger, 'When a record is created'. A trigger event is added.

Trigger event added

1. You can define additional properties and add conditions to further customize your trigger and make it more specific.

You can add multiple conditions and combine them using AND/OR, for an event to initiate the action.

1. Click Add action and then choose the required database action that you want to perform. Let's update a record in another table whenever a new record is created in the current table.

Update record in another table

1. Add the connection details, schema, and table name. You can specify any conditions, such as updating only certain records in the table.

Update table details and conditions to update

1. Add the required row values to be updated in the table.

Add row values

1. Click Save Changes after configuring the row values.

Save configuration

1. The automation workflow is now set up successfully. You can use the pencil icon to name this workflow for easier identification. You can also add more actions to this cascading update event, such as sending an email or a Microsoft Teams message.

Workflow automated

Pause automation

Use the toggle button beside the required automation to pause or resume it. To remove an automation, pause it and then click the '...' icon and delete it.