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
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