Be inquisitive, be curious, be a jigyasu(an eternal learner)

Blogs

Lookup Validation in #Nintex Form for #Office365

 

Business Requirement:

Description field should be valid for submission ONLY if the lookup control in the form  was a specific text.

Solution:

  1. Add Rule to the associated control
  2. Choose Rule Type > Validation
  3. Select formula > Runtime Functions > parseLookup(Syntax: parseLookup([array or single lookup value], [optional bool showText]) ) remove everything in the hard bracket and select the desired control from your Named Controls reference section.
  4. In the image below and for my requirement the working validation formula was: parseLookup(Reasonforchange)!=’Other’  as seen in the image below.
    2-17-2016 1-39-20 PM

Now when a user tries to submit the form by typing contents the description control when the lookup control value is not equal to ‘Other’ they get alerted and will not be able to submit the form until the form values are fixed.

2-17-2016 2-00-00 PM

2 responses to “Lookup Validation in #Nintex Form for #Office365”

  1. Great Solution! ..worked like charm! ..Thank you

    1. I am glad you find t useful!! 🙂 Always makes me happy to know my solutions help someone in need! Rock on! and thanks for the update.

Leave a Reply

Discover more from Woman In Tech: NAVIGATING THE DIGITAL WORLD

Subscribe now to keep reading and get access to the full archive.

Continue reading