Multi choice Validation - InfoPath Dev
in

InfoPath Dev

Multi choice Validation

Last post 07-26-2017 10:09 AM by poporacer. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 07-26-2017 05:47 AM

    Multi choice Validation

    I have a form where people will enter the department they are working in. This is a single choice item. Then they will select the departments that they would like to obtain training in. This is a multi choice item. I need some validation to make sure that they don't select the department they are currently working in as an option that they want to get training in. I tried a couple things, but I couldn't get it to work correctly and searching hasn't helped. I am probably searching for the wrong terms. I tried a formula validation =If(search[transfer dept],[current dept],false,true) but it failed on all entries. Thanks for your help
  • 07-26-2017 08:46 AM In reply to

    Re: Multi choice Validation

     Is this a SharePoint List? Is the form customized in InfoPath or is the validation just on the list column? I ask because your formula looks like it might be for a SharePoint column, not InfoPath. :)

    Hilary Stoupa

  • 07-26-2017 10:09 AM In reply to

    Re: Multi choice Validation

     The current department is populated from a SharePoint list as well as the requesting dept. This is a list of all of the depts.The first list is a single select where the requesting dept. is a multi select.

    I was trying both methods and yes that formula was a SharePoint formula but one that looked like it should work. It doesn't matter where the validation comes from.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.