I have an Order which lists Ordered Kits and Ordered Products. A kit contains a pre-defined list of parts derived from products. A Kit is ordered at the Kit level and when saved, a workflow populates the list of parts into the Order Products table. It may be that not all parts need to be ordered so they can be removed from the Order Products list. AND it may be that other parts are ordered and included in the Ordered Products list.
On the invoice I want to show:
- a table with the Ordered Kit level details
- A table beneath the Kit details with the list of ordered parts from the kit
- Repeat 1) and 2) for each additional Kit
- Finally a table with Other Products
This means I need to split the Related Ordered Products by each Kit ID and then where ISBLANK(Kit ID)
In example template expression excerpt below, is there a way that [Kit] can be referenced from the outer Start row within the inner Start expression? The text is red obviously doesn’t work since it references the Order row used to generate the invoice.