Change Entries with

Purpose:

The "Change Entries in Table" workflow card is used to update entries in a specified database table. It allows you to select a table and column, then perform mathematical operations (addition, subtraction, multiplication, or division) on the values in that column, using a specified value.

Components of the Card:

1. Table Name

   • Description: Specifies the table in which entries will be updated.

   • Detail: A dropdown list of available tables is provided, allowing you to select the target table for updating entries.

2. Column Name

   • Description: Specifies the column within the selected table to be updated.

   • Detail: A list of all available columns will be provided for selection.

3. Operation

   • Description: Defines the mathematical operation to be performed on the column values.

   • Options:

     • Add (+): Adds a specified value to the current value in the selected column.

     • Subtract (-): Subtracts a specified value from the current value in the selected column.

     • Multiply (*): Multiplies the current value in the selected column by a specified value.

     • Divide (/): Divides the current value in the selected column by a specified value.

4. Value

   • Description: Specifies the value to be used in the selected operation.

   • Detail: This is the number that will be added, subtracted, multiplied, or divided with the entries in the selected column.

Functionality:

• Condition Evaluation: The card only executes its action if both the "Where" and "And Sections" evaluate as true.

• Table Entry Update: The card performs the selected operation (+, -, *, or /) on the values in the chosen column of the selected table, using the specified value.

Setup and Configuration:

• Select Table: Choose the table where the changes will be applied.

• Choose Column: Select the column within the table that you want to update.

• Select Operation: Choose the mathematical operation (+, -, *, /) to be applied to the selected column's values.

• Enter Value: Provide the value to be used in the selected operation.

Conclusion:

The "Change Entries in Table" workflow card enables automated updates to database entries by selecting a table, column, and desired mathematical operation. This card is essential for performing bulk data modifications or calculations within your database.