Set a Database Value in a Workflow Response

Skip to main content

Set a Database Value in a Workflow Response

You are here:

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
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?
Tags:

Leave A Comment

Table of Contents
Go to Top