Truth tables are used to provide a visual organization of information when looking into all of the possible outcomes and scenarios from the provided premises. Though most common in mathematics, truth tables have also been used in computer science, electrical engineering, and even philosophy. Given the wide range of uses for truth tables, it should be no surprise to see them applied to business workflows and processes as well.
In the business world, a truth table is a rule represented as a table that compares the possible outcomes of different inputs in your business process automation solution and kicks off workflows based on the output.
Here’s a simple example: A customer inputs an order for 1,000 red mugs. A truth table would dissect the inputs mug, red, and 1,000 to see if there was enough of this particular item in stock. The workflow may then come from your truth table requiring orders of more than 1,000 pieces to have approval from someone in your organization or require a PO or partial payment. The workflow is then forwarded to the appropriate approver for further action.
Why Use an External Truth Table?
When using an external truth table, the rows or values come from a report outside of your business process automation software. This report can come from an Excel file, a .csv file, a database, or even a web service or message queue. Because this type of truth table is built outside of your business process automation solution, you cannot edit it in your business automation platform. In order to make any changes, you would have to edit the source of the input data and then bring it back in as a report.
So why would you use external data from a truth table that you did not build yourself when automating a business process? There are actually quite a few reasons why.
For starters, you may be working with a large set of rules. You may have a database with thousands of records that you need to work with. In this case, rebuilding this truth table on your own would be a tedious effort. You could save quite a bit of time by using an external truth table from the database report.
Another reason why you may want to rely on an external truth table is if you are working with data that is growing or changing in other ways. For example, if you are working with data from your customer relationship management (CRM) solution, you may wish to produce reports to use as truth tables. CRM solutions are consistently growing and changing based on customer outreach and campaigns. To build a new truth table from scratch would waste valuable time you could spend analyzing this data. Anytime you know the number of rules will change or grow, you will want to rely on data sourced from reports you consistently run to get the latest data.
