This topic will walk you through how to use tables within your workflow configuration. This includes how to create tables, add columns, and incorporate formulas.
- A Products table in a sales Order Form, which tracks the number of products you are selling to your counterparty in that contract. You could be selling one product, or you could be selling 10 products.
- A Project Milestones table in a Statement of Work, which tracks each phase of the project.
- A Services table in a Statement of Work, which outlines the rate per each consultant.
- A Payment Schedule table in a Terms and Conditions contract, which tracks the invoice date for payment for each product you are selling. You could have annual, monthly, or quarterly payment terms.
Create a Table
1. Add Your Table and Column Properties
- In Ironclad, click the Workflow Designer tab and select the workflow configuration you want to edit.
- Click Add button on the Fields and Conditions panel, and select Table.
- Add a column for Product, Unit Price, Quantity, and Discount %. Each column field will generate a new question in your launch form.
2. Add Formula Columns
- Click f(x) to add a formula column.
- Add a formula column for Net Total. Formula columns will not generate a question in your launch form because they are calculated values.
- Set your Net Total column to be the product of the Unit Price, Quantity, and Discount columns. For each row in your table, this will calculate the net total using the unit price, quantity, and discount values in that row.
Additional Ways to Use Formulas in Tables
- Calculate the duration of each milestone in your project.
- Calculate the Product ID for products in your order form. In this example, if the Product Type is Consumer, concatenate the “CON” prefix, else, if the Product Type is Business, concatenate the”BUS” prefix.
- Example result:
- Example result:
3. Tag Your Table
- Add a table to your template using Microsoft Word. It is recommended to have a table with two rows, with the top row acting as the header and the second row where you will tag your table fields.
- Navigate to the leftmost cell of your table. A three-dot tag selector will appear. Click Open tag selector.
- Select the Products table you created. Table column fields will appear as grey tags in Workflow Designer.
- Note: If there are more columns in the table than there are columns in your document, Ironclad will tag up to the number of columns in your document.
4. Extract Table Data to Use in Conditions and More
- Create a formula: sum the subtotal of all the line items.
- Create a condition: if the sum is greater than or equal to one million dollars, include Finance as an Approver.
- Add the condition to the Finance approval role.
Additional Ways to Use Table Data
- Check if a certain product was purchased. If Special Product was purchased, include Legal as an Approver.
- Incorporate the products purchased in your document.
- Count the number of milestones in your project.
5. Test Your Table Configuration
- Click Preview at the top of the page.
- Simulate different contract scenarios using the launch form in the lefthand panel.
- Confirm your table is formatted correctly on the document in the Documents tab.
- Verify any roles configured based on table values are triggered correctly in the Roles tab.
- Confirm your table formulas are calculating correctly in the Data tab.
6. Enable Your Contract Requestors
Each column in your table, excluding formula columns, corresponds to a question in your launch form.
When a business user requests a contract, they will see the first set of questions related to your table.
To add another row, your contract requestor can click + Add . This will generate a new series of questions that correspond to a new row in your table. They can add as many rows as needed.