InfoPath Dev

I would add a data connection to the list or library where the form submits. Don't run the query on form load (that is a checkbox toward the end of the data connection wizard). Instead, once the user enters the vessel in the form, set the query field for the vessel name with the selected or entered vessel name and then run the query. You ...

Okay, I get it now. So, your filter is just going to be more complex on the L2-Benefits-1 dropdown. The first two dropdowns stay the same in the filter condition - but for the third one, use a formula: xdXDocument:GetDOM("Business L1 Organization External")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:Title = ...

I apologize, I'm having a little trouble understanding this. Can you attach a copy of your form under the Options tab in a reply so I can look at the rules?

Can you attach your form under the Options tab in a reply so I can see what your formatting currently is?

Hi - your pictures aren't showing up for me - you can attach an image under Options in a reply. You can use the title for the value, but that will change your filters - maybe just attach your form and I'll give you a hand?

Maybe you could start with this tutorial, and then once you have an idea of how REST in general works I could help you with the syntax? 

I wonder if you could use REST to join the lists - https://scottcurrier.wordpress.com/2010/01/02/rest-and-sharepoint-2010-quick-start-guide-multiple-columns-expand-and-filter-almost-a-join/

So - each part number is its own column? I started out trying to describe adding a filter, but then realized that each part number was its own column. Where do your options for the Part Name drop down come from? Are they the exact same names as the columns? Any chance I can see a copy of your form - you can attach it to a reply under the Options ...

Hi - I replied to your email to support with this information as well - the first thing to verify is that you are a site collection admin and the form is injected with the Sandbox / Browser option selected.

In the attached sample, I've added fields for the ROI and calculated values for Y1 & 2 - here's a link on dealing with NaN and Infinity in InfoPath: http://www.braintrove.com/id/71 I'm not very math-y and don't know how one would implement "^ 1/5 power" in InfoPath.