Skip to main content
Nintex Community Menu Bar

How to validated multi-select field

  • September 10, 2017
  • 4 replies
  • 259 views
  • Translate
D

I have a Nintex field based on a Site Column that is a Lookup.  To clarify, the site column is connected to a list at the root of the site collection and this list provides the lookup values for the field.

I enabled this Site Column for Multiple Selections, and then I changed the Appearance settings on the Nintex Form to show checkboxes.  All of this works fine.

 

Now, I want to have another field require a value if a certain value in that list is in the list of selected values.

I have seen multiple posts regarding how to validate if a check box is checked using isArray, and how to Array check box values,etc. and I have attempted the following validation rule on the ReportsTo field:

 

inArray(StatusReasons, 'Reports To Change') && isNullOrEmpty({Self})

 

Nothing is happening.  I suspect its because the source field is not actually an array because the source field is not a Choice field, but a Lookup field, but I am not certain.

 

Can you put the values of a multi select lookup field from SharePoint into an Array and evaluate as above?

    Did this topic help you find an answer to your question?

    4 replies

    N
    Forum|alt.badge.img+3
    • nps9
    • 24 replies
    • September 11, 2017

    Devin,

    Could I get a little more info. When you say "I have a Nintex field based on a Site Column that is a Lookup" what type of Nintex field have you connected to the site look up column?

    thanks

    Translate
    D
    • devingig
    • Author
    • 2 replies
    • September 12, 2017

    The field is a Lookup field in SharePoint, getting its data from another list,.  it is in a List Lookup field rendered as Option Buttons 

    Translate
    N
    Forum|alt.badge.img+3
    • nps9
    • 24 replies
    • September 15, 2017

    OK Devin,

    I created a calculated value with the following expression:

    contains(parseLookup(LookupColumn), 'Reports To Change')

    Lookup column being the site column lookup.

    So I get either true or false in the calculated value field but it is in string format not Boolean.

    Then I created a validation rule with this expression: tbxReportsExists=='true' && ReqdTbx==""

    tbxReportsExist being the calculated value field. ReqdTbx is the single line that is required if "Reports To Change" has been selected - regardless of if any of the other options have been selected.

    No need for any kind of array.

    Translate
    TomaszPoszytek
    Forum|alt.badge.img+17

    ‌ have you resolved your issue? Is any from the above answers helpful thus you could mark it as "correct"?

    Regards,

    Tomasz

    Translate
    Regards, Tomasz Poszytek

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings