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.

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

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

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.

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

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.

1. Add the connection information, schema, and table name for the table you want to update simultaneously. You can specify any conditions, such as updating only certain records in the table.

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

1. Click Save Changes after configuring the row values.

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.