Nintex Forms provides many ways for users to collect information using various basic controls such as short and long text, number, date/time, images, and even file attachments. However, there is one control that Nintex Forms needs to collect more complex data: the repeating section control.
The power of repeating sections
The repeating sections in Nintex Workflow Cloud® allows you to collect information in multiple instances, or rows, in a specific section of a form. It’s a useful tool, but did you know that it can also perform row-based calculations on the data that is entered into each form?
With this functionality, users can build complex form solutions, such as inventory management forms and expense reimbursement forms, or even a simple menu ordering form.
Speaking of a simple menu ordering form, this exact form is readily available to you to use in the Nintex Solutions Accelerator Gallery.
Let’s look at how the Food Order Menu form is designed.
Repeating sections in action
This repeating section example utilizes three main portions of the Nintex Forms Designer in Nintex Workflow Cloud:
Controls are as follows:
- Choice – Single
- Menu Item
- Per Item Cost (read-only)
- Line Total Cost (read-only)
- Total Order
- Repeating Section
After nesting the choice and number controls into the repeating section control, you will build variables. The variables will be required for two purposes.
First, you need to determine the constant values of the per item cost. In the example below, pasta costs $10.99 per item. The ‘decFormTotal’ variable will use the form function of sum() to add the line total cost of each row in the repeating section.
Second, you will need to build the form rules for each item in the choice – single dropdown (pizza, pasta, salad). These rules will set two configurations in how your form operates. Note that it will state that if a dropdown value equals ‘x’, the per item cost is set to the per-item cost variable you previously built. Additionally, these rules are only going to be applied to the repeating section and not the entire form.
Within the same rule, you will also create a formula to multiply the item quantity with the per-item cost (Item Quantity * Item Cost).
Repeat these same rules for each item in the choice – single dropdown.
To show the form total below the repeating section, click on the label control to open the configuration pane. In the ‘Text configuration’ section, type ‘Total Order: $’ and then use the ‘Insert’ tab to insert the decFormTotal variable.
Not sure where to start with Nintex Workflow Cloud? Nintex University is your source for getting up and running quickly with the Nintex Process Platform. Or, if you need help on a particular feature or function of Nintex, be sure to check out Nintex Help Files.
If you are interested in learning more about the Nintex Process Platform and what it can do to help your organization manage, automate, and optimize your business processes, click here to request a live demo.