Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of Questions, in field 'Question'. I want to create a list box that will only show two of the specified questions, "Group: Productivity" and "Self: Productivity". I'd like to be able to just have these two questions listed as possible selections, and at the same time, change the text to read just "Group" and "Self".
Are either of these solutions possible?
Thanks,
Tim
In your list box, try an expression as field (last item <expression> in the field drop down list):
=If( Match( Question, 'Group: Productivity','Self: Productivity'), Subfield(Question,':',1) )
In your list box, try an expression as field (last item <expression> in the field drop down list):
=If( Match( Question, 'Group: Productivity','Self: Productivity'), Subfield(Question,':',1) )
Thank you, that worked perfectly!