InfoPath Dev

Hours_Total

0 != xdMath:Nz(.) + xdMath:Nz(../my:Absence_Total)

and

40 != xdMath:Nz(.) + xdMath:Nz(../my:Absence_Total)

 -------------------------------------------------------------------------------------

Absence_Total

40 != xdMath:Nz(.) + xdMath:Nz(../my:Hours_Total)

and

0 != xdMath:Nz(.) + xdMath:Nz(../my:Hours_Total)

Given the XPaths to your fields:

Hours_Total XPath =       /my:myFields/my:Hours/my:Total_Hours/my:Hours_Total

Absence_Total XPath =     /my:myFields/my:Absence/my:Absence_Total

I think the correct expressions would be:

Hours_Total

0 != xdMath:Nz(.) + xdMath:Nz(../../../my:Absence/my:Absence_Total)

and

40 != xdMath:Nz(.) + xdMath:Nz(../../../my:Absence/my:Absence_Total)

 -------------------------------------------------------------------------------------

Absence_Total

40 != xdMath:Nz(.) + xdMath:Nz(../../my:Hours/my:Total_Hours/my:Hours_Total)

and

0 != xdMath:Nz(.) + xdMath:Nz(../../my:Hours/my:Total_Hours/my:Hours_Total)

The XPaths are relative - so, for Hours_Total, it needs to be "how do I get from here to Absence_Total?" and for Absence_Total, "how do I get from here to Hours_Total?"

More on XPath here.

Yes yes yes, that worked when the hours equal 40, Thank you! :)

 Now, when the total hours DON'T equal 40, I get this message here...

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 

This form contains validation errors. Errors are marked either with a red asterisk (required fields) or a red, dashed border (invalid values).

Do you still want to send it?  YES/NO BUTTONS

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Can I instead, have it say something like "Total Hours do not equal 40", please fix before sending" with an OK button.

Basically people tend to ignore dialog boxes and will just press whatever they need to force a message to go through. My way eliminates this.

Can this be done?

 Thanks again so much for your help.

So, what are you doing when you get the message? Clicking Submit? Do you have Submit rules set up? Or is this some other button?

Ahh, yes I forgot to tell you that small detail.

 I have the form published to email recipients. They open up the email, fill out the form, type the email address it goes to and hit "Send". Once the "Send" button is hit is when I get the message I stated above.

I haven't used email forms much. I don't know if there is a way to entirely block Send - you may want to post a new question on that. I know that with a standard InfoPath form, you can't submit if there are validation errors - which is why I'd suggested validation. But it sounds like it doesn't block emailing.

Ahh, ok, At least it'll warn them.

Thread solved and thanks!

 Hi,

I have been trying to do similar kind of activity. 

Scenario: There are two boxes to enter data .  ex: 40 in one box and 60 in another box. here i need to check that sum of both boxes should be 100. For this i tried above approach but not succeeded.

my fields xpaths: 

first field : -          /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:FiscalYear1SavingSharePercentage

Second field :-    /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:FY2SavingsSharePercentage

 Could you please help me out this.

Note: I am using infopath 2010 designer.

So, your validation rule would have the condition that (/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:FiscalYear1SavingSharePercentage + /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:FiscalYear1SavingSharePercentage) ! = 100, I think - why don't you post your form with what you've tried? You can attach it under the Options tab... You'd probably also want to add conditions to the validation that both fields are not blank, to avoid showing the error before the user enters the data.

Hi

Thanks a lot for your help. It worked well.

Regards

KV