cross matrix for entering data

M

mcchu

Hi all,

I need to find a way where a user can enter data for a matrix build
automatically(somehow) based on two columns of fields(field1 and field2).
The field1 data and field2 data can come from another view of the form. From
those two repeating fields I want to make a matrix based on that and have
user entered the third field(for each field1 crossing field2). At the end,
field1 and field2 data will be used to fill another part of the schema.

Here is an example. Schema looks like

RepeatingGroup1
field3
field4
field5

The matrix will look like the following:
field2[1] field2[2] ...
field1[1] x11 x12
field1[2] x21 x22
field1[3] x31 x32
....

Result is as follows:
field3 field4 field5

field1[1] field2[1] x11
field1[2] field2[1] x21
field1[3] field2[1] x31
field1[1] field2[2] x12
field1[2] field2[2] x22
field1[3] field2[2] x32

I am having lots of trouble trying to think of the a way to build this so a
user can enter data for this matrix. There are two issues I found here. The
first one is the fact that the number of rows for field1 and field2 are
undetermined. If needed be, I can use a limit number to represent the
maximum number of rows or columns. The second issue is the fact that I might
have to build a repeating table of some sort to let the user to fill in x
values.

Please advice on this issue. In Excel this is easy, but I realize in
InfoPath there is no easy control like a grid that can handle such things.
But if there is tips or tricks, please let me know. Any comment would be
greatly appreciated.

Thanks,
Michael
 
M

mcchu

I realize that there might be a solution if I change the schema to the
following format:
RepeatingGroup1
field3
RepeatingGroup2
field4
field5

From Greg Collin's infopathdev.com example, Repeating Cascading Lists of
Cascading Lists, this might be a solution.

There is a flat database schema from my first post versus this current more
used way of XML schema. Please comment on when one would use this over the
other.

Thanks,
Michael
 
M

mcchu

Hmm.. I found out that the example mentioned from previous post does not
predefined the layout so user does not have to choose from each cascading
drop down list. It is a lot of work for the end user to choose from each
drop down list in order to fill out a number at the end of the lowest
hierarchal element. Is there a way to make this example more powerful in
terms of displaying all the controls knowing that the end user might have to
fill out all the possible cascading lists.
 
M

mcchu

Here is the final thought of the day. How do I get a repeating table field
in the main data source, which is filled out by a user, to be stored as data
in another repeating table field in the main data source without writing
JavaScript. There is no action from applying rules that allow me to add a
row. Unless, I can somehow set a field's value (and magically it is added).

Thanks,
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top