Complete the following to set a database value in a workflow response:
- Navigate to Workflows in Business Central.
- Select New Workflow from Template / New.
- Input the following (modify as needed):
- Code
- Description
- Category
- Select the … button for the When Event field and set to any Quality Inspection Test-related event.
- Select OK.
- Modify the On Condition field as needed.
- Select the … button for the Then Response field and select “Set a database value”.
- 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.
- Select OK.
- 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 |
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.