Validate 10 fields on Infopath form before Submit form data

Question

I have SharePoint 2010 list and I Customize list form in InfoPath form in 2010

In my scenario I have 15 Fields

I want to give the validation alert on fields before submitting the button.

Also one more thing at the end of the form whenever m going to submit the data following error occurs,

I want user friendly message over here. as "Please fill all the required fields"

Please Help

Thanks in advance

Answer 1

In InfoPath :

1.Select the field for validation.

2.If the Rules task pane is not already showing, click Manage Rules on the Home tab.

3.In the Rules task pane, click New then select Validation to create a validation rule action.

4.Build a custom rule to validate the field

For details use this link (look at Part 3 ─ "Adding Validation, Conditional Formatting, and Logic to Your Form").

Answer 2

Create a calculated field, let's say it's called NonBlankFields. Set the formula of this field to be all of the string lengths for the fields you want to check multiplied together. If any of the fields have a 0 length, the product will be zero. You can have a formatting rule with the condition that if NonBlankFields = 0 then disable your SUBMIT button.

Example:

string-length(Name) * string-length(phone) * string-length(email)

If any of those fields are blank, the result = 0 otherwise it is some meaningless number.

Answer 3

I use Phil Greer's elegant solution, but eliminate the computed field. Instead, I insert his formula directly into the Condition of the Formatting Rule:

My expression, which validates six fields, looks like this:

string-length(/my:myFields/my:scnBasicProgramInformation/my:ContactPerson/pc:Person/pc:DisplayName) * string-length(/my:myFields/my:scnBasicProgramInformation/my:ProgramTitle) * string-length(/my:myFields/my:scnBasicProgramInformation/my:ProgramBegin) * string-length(/my:myFields/my:scnBasicProgramInformation/my:ProgramEnd) * string-length(/my:myFields/my:scnBasicProgramInformation/my:ProgramLocation) * string-length(/my:myFields/my:scnAudience/my:Audience) = 0

I obtain each field's XPath location by finding the field in the "Fields" window, right-clicking on it, and selecting "Copy XPath":

That stores the field's XPath location it in the clipboard. I paste each XPath location into NotePad, where I assemble the entire expression before copying and pasting it into the Condition dialog box.