Skip to content

Quality Inspector · Set up

Set a Database Value in a Workflow Response

Last updated September 22, 2025

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

View this article as Markdown

Still need help?

Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.