+2Nintex responsive form on SharePoint 2019
I’ve got a sum field that totals 10-14 fields depending on how many are chosen.
Even using named controls the sum field is not working in real time.
When
FIELD_A==”Yes” && FIELD_B==”No”
Then
Set Value
sum([_1a Score A,_1b Score A,_1c Score A,_2a Score A,_2b Score A,_2c Score A,_3a Score A,_3b Score A,_3c Score A,_4a Score A,_4b Score A])
By default FIELD_A and FIELD_B are set to Yes and No.
What am I missing here?
Best answer by bamaeric
One option to try is to use a Calculated Value control for the total and configure it with something like the formula below (I only used 4 integer fields for the socres):
If(and(FIELD_A,not(FIELD_B)),sum([ScoreA, ScoreB, ScoreC, ScoreD]),0)
This will calculate the Total sum if FIELD_A is checked, FIELD_B is unchecked, and numbers are added to the score fields. If the checkboxes don’t meet the conditions, then 0 is display in the Total field.
+13I assume you are using the Responsive designer (and not the New Responsive designer). What type of controls are FIELD_A and FIELD_B -- Yes/No or Choice?
The Yes/No (checkbox) control can be tricky in form rules. Check out the blog post below and see if it helps with the rule:
+13One option to try is to use a Calculated Value control for the total and configure it with something like the formula below (I only used 4 integer fields for the socres):
If(and(FIELD_A,not(FIELD_B)),sum([ScoreA, ScoreB, ScoreC, ScoreD]),0)
This will calculate the Total sum if FIELD_A is checked, FIELD_B is unchecked, and numbers are added to the score fields. If the checkboxes don’t meet the conditions, then 0 is display in the Total field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
