---
title: "Set a Database Value in a Workflow Response"
app: "Quality Inspector"
section: "Set up"
last_updated: "2025-09-22"
url: "https://insight-works.com/kb/quality-inspector/set-a-database-value-in-a-workflow-response/"
---

# Set a Database Value in a Workflow Response

Note: Ensure you have workflows enabled on the Quality Inspector Setup.

1. Navigate to _Quality Inspector Setup_ in Business Central.
2. Set _Workflow Integration_to “Enable Workflow Integration”.

Complete the following to set a database value in a workflow response:

1. Navigate to _Workflows_ in Business Central.
2. Select **New Workflow from Template** / **New**.
3. Input the following (modify as needed):

   - Code
   - Description
   - Category
4. Select the **…** button for the _When Event_ field and set to any Quality Inspection Test-related event.
5. Select **OK**.
6. Modify the _On Condition_ field as needed.
7. Select the **…** button for the _Then Response_ field and select “Set a database value”.
8. Set the values for the following fields:

   - Table: The table in Business Central to set.
   - Filter: The filters required to find the appropriate record in Table.
   - Field: The field that you want to change from Table.
   - Value to Set: The value that you want to set in Field in the record’s Table filtered by Filter.
9. Select **OK**.
10. Select the **Enabled**

You can now run a test to test out the workflow response.

### Examples

#### Block purchase of an item

| **Field** | **Value** |
| --- | --- |
| Table | Item |
| Filter | WHERE(No.=FILTER([Item:No.])) |
| Field | Purchasing Blocked |
| Value to Set | All |

#### Block vendor

| **Field** | **Value** |
| --- | --- |
| Table | Vendor |
| Filter | WHERE(No.=FILTER([Vendor:No.])) |
| Field | Blocked |
| Value to Set | true |

#### Flag BOM as under development

| **Field** | **Value** |
| --- | --- |
| Table | Production BOM Header |
| Filter | WHERE(No.=FILTER([BOM:No.])) |
| Field | Status |
| Value to Set | Under Development |
