InfoPath Dev

I've attached a sample with a data validation rule that does what I think you want. When selecting the field from your SQL connection for the first part of the condition, you can use the drop down in the field selector to pick "Any occurance of" the field being equal to your main data source field. Save the sample locally, right ...

To the best of my knowledge, you cannot paste from Excel into IPFS the way you can into filler - I'm sorry I don't have better news for you. I just recently tried this myself in a ShP 2010 enviro.

What about adding one more field to the data source - called Subtotal (or something that makes sense to you). It doesn't have to show on the form - just add it to the data source. It's default value could be the formula you have above -  "Total Expenses" - "Less Company Paid" - "Less Travel Advance" ...

Okay so here is the setup and question that I have. I am working on a expense report form and I have the following fields:  "Total Expenses", "Less Company Paid", Less Travel Advance", "Less Personal Expense", "Due to Employee", and "Due From Employee".  In the "Due to ...

So what I'm thinking is, all items in the kit will have the same unique gear ID.  If the top level item (the main item) has a "need" value of 0, then all the sub items will be hidden.  But how do I determine (in an expression) what the top (first) instance of a particular gear ID is?  How will I hide all BUT the ...

got it resolved just used substrings

Hello, We are using SharePoint 2010 /w InfoPath 2010. We have built a Browser Form where the user fills out form then submits the Form to SharePoint for processing. The Submit Button appears only in the Form until submitted. We have a big Save & Close button in the Ribbon at the top. New users keep trying to Save on 1st instance instead ...

Yeah, my syntax was off.   Thanks.

You bet - we've all had those "Why didn't I think of that!" moments (I have lots, myself.... )

You know this is one of those moment you just want to kick yourself, I know thats where i could have gotten the full path. lol thank you very much for you help.