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 thoughts

    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.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s