The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
INFOPATH + Formula with If Statements
i have an infopath form with several fields for the user to fill out, and a button that submits the data to a sharepoint list.
when the button is clicked i want to check three of the fields and if any of them have a value of "DUPLICATE" then i set the value of another field as "BAD" and if none of the three fields have the value then the other field would be set to "GOOD"
Is there a way to use an if statement in the formula field so this can be achieved?
when the button is clicked i want to check three of the fields and if any of them have a value of "DUPLICATE" then i set the value of another field as "BAD" and if none of the three fields have the value then the other field would be set to "GOOD"
Is there a way to use an if statement in the formula field so this can be achieved?
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
1. For your validation field best practice would be to use a boolean or the false rather than good or bad in a text field. A little bit simpler and faster.
2. There are two approaches to the check. Put the check on the submit button as an action. Create a new rule and add a condition. Field1 equals Duplicate or field2 equals Duplicate or field3 equals duplicate. Then have the action be a set a fields value
3. The other way is to put a rule on each of the fields to be checked. If the field equals one of the other fields or duplicate then set the field value to true. The advantage here is that you can alert the user to bad input sooner rather than at the end and they have to start over. It is also easier to have messaging as to the exact field which is the problem since it is in context.
so the answer is to use OR statements and conditions. This is often not trivial and takes experimenting to get the correct logic. Such as if you use not equals you have to flip to and statements. Always do things in small steps and validate before moving on to the next one.