InfoPath Dev

Hello,

I was trying to create something in Excel, but discoverd the power of Infopath, and like to learn more about it.
I'm making a form for users to fill in some values, and the form will return some values.

Now the idea is this: I have an search-matrix in Excel. Infopath has to look horizontally an vertically in this matrix, and return the right value.

Is this possible? Thanks!

hi cyberdhine,

would you like to elaborate what you want to say, i cant get what you want

Hello Qazi,

firstly thank you for the fast reply!
I have a form, with 2 boxes. In these boxes users must type a value.

So with these 2 values, Infopath should go search in a table (inside or outside Infopath?) And find the corresponding value.

 Small example:
Matrix:
        A     B      C
E      1      2      3

F      4      5      6

G     7      8      9

So if a user gives the values "B" & "G", infopath should fill in another box with the value "8".

I hope you get me now? 
Thanks! 

Update:

For everyone who would like to look into this, I will hereby provide the some files.
The zip contains one excel sheet, on which the search table is. Further one JPG to show what I'm trying to achieve.

Thanks!

 This is entirely possible in InfoPath, but you need to put the data in a format that InfoPath will understand.  This is a little tricky when the original data is in Excel.  I created and ran an XSL transform on the data in your spreadsheet to produce the attached XML file.  This can then be added as a secondary data source in InfoPath, and then retrieving data from it when you want just requires a bit of rudimentary XPath.  I recommend getting up to speed on XPath if you are not very familiar with it yet.

 http://www.w3schools.com/XPath/default.asp

Hello Jimmy,

thank you very much for the xml-file. I've tried to find a program that could create such a list for me, but could'nt find one. This is great!
I've been reading a lot of chapters concerning the xpath, but it's still all very "rocket-sciency" to me.

I think I'll just go and try some things...I guess I should make some kind of formula which refers to the values of the two drop-down boxes, and searches for the corresponding value in the xml document?

Hmmm, well, wil go and try!

Thanks!

Right now using this formula:

xdXDocument:GetDOM("SearchMatrix")/data/dataRow[@rowValue = "../my:Alpha"]/dataCell/@colValue = "../my:Beta"

the editor says: "the formula contains no errors".
But when I test my form, the output is the value "false" instead of the correct value.

I filled the two boxes "alpha" & "Beta" with the values of the "searchmatrix".

 Nice attempt.  Please see if this formula works:

 xdXDocument:GetDOM("SearchMatrix")/data/dataRow[@rowValue = current()/../my:Alpha]/dataCell[@colValue = current()/../my:Beta]

 If that doesn't work, could you tell me where you are using this formula (in a default value, rule, etc.) and attach a screenshot of your main data source (from the taskpane)?

Hmm,

That one doesn't seem to work either.
Maybe it's not in the formula itself, but in the type of boxes? Or other settings?

To be sure I've attached the form & the search-matrix. I've modified the xml a littlebit to make sure all values are 2 decimals.

Take a look, hope you can find something!

 In your formula, you're matching rowValue against Alpha and colValue against Beta, but actually rowValue corresponds to Beta and colValue corresponds to Alpha.

 This formula should work:

 xdXDocument:GetDOM("SearchMatrix")/data/dataRow[@rowValue = current()/../my:Beta]/dataCell[@colValue = current()/../my:Alpha]

Yes,

I've noticed I had switched the values, but I've corrected that in my drop-downlists.
You should think this formula would work, but it doesn't!

Very strange...

 Could you attach your form again in its current state?

Here it is.

No luck on this one yet.

Any ideas? :)

 Sorry for not responding sooner.  It seems I missed your post.  I tried opening the latest form you attached in Preview mode, adding a row to the table, selecting a value for a and b, and Cb is showing the corresponding value just fine.  What happens when you try that?