So lets say I have a cell in which the user has to select from a drop down menu a value from 1-10.
Based on this selection I want the user to get presented a fully formatted table with additional dropdown menu's
For example the user selects 2. He will be shown a table with 2 columns, and two rows showing in the first column Q1 and another drop down menu in the second column. And under that Q2 with a second drop down menu.
If he selects 3 this will be 3 columns and 3 rows etc.
As this is an example, it's fine that this would be hardcoded. 4 could give the same table as 2 or 5 might give just one addition question. I just want to know how I could change the presented table when a different entry is selected in the dropdown menu.
Finally I would like to know how to give information about the selection.
Let's say I selected 2 and the answer to Q1 is a name 'Arnold' I then would like in a different table to show information about the selection 'Arnold' (stuff like age, married yes/no, kids yes/no etc.)
If you know any way of doing this, please let me know.
Bookmarks