I am trying to create a form that will contain a table of items. The users can order up to 5 of each item if they wish. I'm thinking I can put the items in a separate list and fill in the form using that list. I would like an input field at the end of each item though. Can anyone explain how I can get the input value saved or is there is a better way of going about this? I have tried using an HTML table but the input values do not get saved when saving the form to SharePoint. Also the form will be parsed by a Java program after the form is saved and parsed for information (hopefully). Is it possible to name each input differently? Thank you.
Solved! Go to Solution.
I had a similar issue and resolved it by putting repeating sections into my form. The section had a list lookup, where the user could select the desired item from a dropdown. Once selected, price and detail were displayed. The user can then enter the quantity of the selection and then add a new item to the repeating section for the next ordered item. Order totals are also displayed on the form.
All required output from the individual rows in the repeating sections were concatenated into a multi-line variable with a delimiter of choice for both the value separator and the row seperator. This allowed me to process the output variable via collection controls in my workflow to do what was required. I'm not sure if you are using Nintex workflow, as you have not stated that.
It works pretty well, and I was not able to come up with an alternative that would allow a list to be pulled in with the relevant selection ability or quantity entry.
In the settings of a repeating section, in Appearance section, you can set "Prevent add/delete in new/edit mode" to Yes so that users cannot add or delete rows in your repeating section.
What type of Nintex Forms is it ? A start form, task form, list form ?
If it was a task form, in the Nintex workflow where you generate the task, you could build XML before creating the task and in the task form, you could connect the generated XML to a repeating section and you could have exactly what you'd like.