Best logic to check results from muliple fields

  • 16 July 2018
  • 1 reply
  • 0 views

Badge +10

Hi

I thought I'd actually plan this out instead of lurching straight into this!

I have an InfoPath form with two different view, a Design and a Check view. When the Design view has been completed the Check view gets sent. The Check View has 40 drop down boxes with 'Pass', 'Fail' an 'N/A' .

If any of those 40 drop downs are 'Fail' is needs to get bounced back to the user to amend the Design view until it's correct.

What would people recommend the best way to approach this would be? I've got some ideas around a loop but want some advice before I start, as this could get very complicated very quickly!

Thanks in advance!


1 reply

Userlevel 2
Badge +11

Hi, you want to recreate this in Nintex Form or does your question still apply to the InfoPath???

In Nintex Form I would add a Calculated value that OR's all checkboxes, e.g.: chbx_01 || chkbx_02 || ..... || chkbx_40 (you may have to use chkbx_01 == Yes or chkbx_xx == true). Hide the calculated value and name it so you can use it from the Hide rule of both panels (replacing the InfoPath view pages)..

Reply