InfoPath Dev

Uhhhhhh.  It's Monday again.  ; )   Thanks.  Sometimes it's the simple things. 

Well, you weren't having a Monday all by yourself - you kept telling me what you were trying to do, and I kept overlooking the ! in front of the = myself. :-}

Hilary Stoupa:

Sounds like you are saying you want:

[my:Total != 0 and my:PullID = '']

So that you submit anything that has not been submitted (i.e., pull id is equal to blank) but has a total that is not equal to zero.

Actually, now looking at it, I think I need -

[my:Total != 0 or my:PullID != '']

That way new items that equal zero will not be submitted.  But items that are zeroed out later (that have already been submitted), will get updated in the list still.  No, because if it zeroed out it still won't submit.  Dangit!

I want new items (no ID) with values of 0 to not be submitted.  But if an item gets zeroed out later (after being submitted; ie, with an ID), I want them to get updated in the list. 

Okay - so you want new items with non zero amounts to be submitted:

[my:Total != 0 and my:PullId = ""]

AND, if something that has been submitted gets changed to 0, it should still be submitted - but shouldn't it just be the case that if it has a PullId, it is always submitted? If so:

[my:PullId != ""]

So, to combine:

[(my:Total != 0 and my:PullId = "") or my:PullId != ""]

That what I'm talking about!!!!   Thanks!   Eventually, I won't be too quick to exhaust all my mental resources. 

It appears that it does not like the syntax.  I get a "Failed to generate batch from mapping" error with the combined rule. 

I found that using this filter - [my:Total != 0 or my:PullID !=''] works just fine for my scenario.