Constructed Lists from Combo Box Grid

Question

I want to construct 2 lists based on the answers of a Combo Box Grid.  One list for the row labels and another list for the column labels.  Is this feasible and how?  Right now I can only make either list to work, but not both because of the row vs column question issue.  Any workaround?

Thanks in advance!

Comments

I didnt understand your question fully? In a grid questions settings you can select a constructed list for the row in rows tab and for the columns in the column tab. How exactly does it not work?

---

Thank you for your reply.  

Let me try to explain better what I'm struggling with.

I have a grid question with product A, B, C, D on the left as row labels, then I have brands 1, 2, 3, 4, 5 across on top as the column labels.  This is a combo box question with a drop down menu currently use, have used, aware but not used and unaware as the options.  So for each product (A, B, C or D), people have to choose their experience of each brand.

Then, I want to create multiple constructed lists.

1) A list of the products that at least one brand is currently use or have used

2) All the brands that are currenty used or have been used for Product A

3) Same as 2 but for Product B

etc.

If I set it as a columnn question, I can only populate the row labels which are the products,  but I cannot populate the brands.

Vice versa, if I set it as a row question, I can only populate the column labels which are the brands, but not the products.

I want to do both but I'm not sure if it is possible with the current set-up.

(converting this to a comment rather than an answer - Bahadir Ozkurt)

Answer 1

If your grid question (referred as "grid" in the code below) looks like the following and you want your constructed list to be accessible after hitting submit on this page; you can use Perl to achieve what you want to do:
http://imageshack.us/a/img831/9602/gridq.png

type this in Constructed list instructions

[% Begin Unverified Perl
if(VALUE("grid_r1_c1")== 1) { ADD("Products",1); }
if(VALUE("grid_r1_c2")== 1) { ADD("Products",1); }
if(VALUE("grid_r1_c3")== 1) { ADD("Products",1); }
if(VALUE("grid_r2_c1")== 1) { ADD("Products",2); }
if(VALUE("grid_r2_c2")== 1) { ADD("Products",2); }
if(VALUE("grid_r2_c3")== 1) { ADD("Products",2); }

End Unverified %]

I haven't tested but it should work, ofc you have to fill out the rest of the conditions :)

Comments

Excuse my ignorance.  Where exactly do I put these codes? Thanks.

---

This is the list building logic, which would go into the text entry area when you create a new constructed list.  If you are unfamiliar with list building, it would be helpful to read through this help file first: www.sawtoothsoftware.com/support/issues/ssiweb/online_help/hid_web_listbuilding.htm

---

Thanks Brian,
When it says [ is an invalid character, what does it mean and what should I do?

---

That's a typo in Bahadir's code.  When you are building a list, you do not need to start with [%, i.e. just start off with Begin Unverified Perl on the first line, and then the last line should be End Unverified without the %] characters

---

Thank you!