I have a table with a column of form control check boxes on each row that I want a user to be able to select from and then have those selected rows add some of that data to new columns in another table.
So example Table 1:
Let's say I check boxes 1 and 3, so I'd then want to add 2 columns to Table 2, like so:
Been trying to salvage together some code but not having any success, essentially I'm trying to cycle through each check box, if true then add column to Table 2 and populate as indicated above. The check boxes are labeled sequentially 1-53 and I have a set number of them.
So example Table 1:
| A1 | A2 | A3 | Check Box 1 |
| B1 | B2 | B3 | Check Box 2 |
| C1 | C2 | C3 | Check Box 3 |
| D1 | D2 | D3 | Check Box 4 |
Let's say I check boxes 1 and 3, so I'd then want to add 2 columns to Table 2, like so:
| Title text | <added column> | <added column> | Summary formula |
| Title text | Value from A1 | Value from C1 | Summary formula |
| Title text | Value from A3 | Value from C3 | Summary formula |
| Title text | dynamic user-adjusted field | dynamic user-adjusted field | Summary formula |
| Title text | formula referencing dynamic field | formula referencing dynamic field | Summary formula |
Been trying to salvage together some code but not having any success, essentially I'm trying to cycle through each check box, if true then add column to Table 2 and populate as indicated above. The check boxes are labeled sequentially 1-53 and I have a set number of them.
