I am very new to SharePoint and Nintex forms. Currently, I am designing a form ( through Responsive designer) which is not linked to a list (but it will be).
I have created a Repeating section and it has different Choices. According to these choices, I need to calculate and store a value.
Example of drop down list:
Enrolled: Full Year or Half Year (if Full Year the value will be 1 if Half Year the value will be 0.5)
Studying: Full time or par time ((if Full Time the value will be 1 if Part time the value will be 0.5)
I have created 2 number fields to store the values, calcuate and show it in another number field. For this I have created the rules also.
I have already worked similar to this and it worked pefectly fine, but when I am doing in the repeating section it is not working at all.
Any idea what is the issue with the repeating section?
Thanks in advance.
Solved! Go to Solution.
Attaching my form screen shot (1.jpg). When I select "Full Year " from enrolled drop down, the value in "ValueEnrolled" should be 1.
I am also attaching the Rule screen shot for your reference.
Kindly note, I have taken those two fields (Enrolled and Value Enrolled) out from the Repeating section and created the rule again and it worked fine. Also, I tried keeping a default value in few fields inside the repeating section and that is also not working.
@SimonMuntz Yes, that would be great 🙂
I have another question, I want to do some calculations in the repeating section. For example
ValueEnrolled * ValueStudying * Supervision = Weighting
When I am creating the Variable, it says: "Formula return type does not match type number" and in look up it is appearing as Array (number) and not number. Should I create a new case for this?