I have a list of questions (150+). Each question has a particular type of answer and some of the answers can be picklists. Now I want to create the response picklists based on the question, how can I do so? I do not want the question to be a controlling picklist, as the number of questions can grow further.
Thanks for the help in advance.
Example Ques Response Type Value What is your fav game? Picklist Chess, Tennis, Checkers What is your fav colour? Picklist Red,Green,Blue, Yellow Which is your fav food? Picklist Indian, Chinese, Italian, Mexican
So I need to populate the picklist values based on the questions. I have more than 150 questions. So making the question controlling picklist and the Value as dependent picklist does not seem to be a suitable solution. How can I achieve this functionality?